If statement with Lookup

I am using this formula currently in my app. 

Lookup([ID_No],"Form","Enter ID","Name")

I want another formula similar to this

If lookup [ID_No] found in column "Enter iD", it should say done, if doesnt find it should say pending.

Thanks

 

 

0 6 582
6 REPLIES 6
Top Labels in this Space