If statement with Lookup

[itsmaxsingh]

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

[Steve]

IF() - AppSheet Help

[itsmaxsingh]

Hello sir, thanks for reply. I went through the article but still cannot find how to use "IF Statement with "LOOKUP", thanks

[Steve]

Please explain in plain language what you are trying to accomplish. Please do not use AppSheet terms. If English is not your native language, please feel free to explain in your native language.

[itsmaxsingh]

Sir, my question is simple. " How to use IF Statement with LOOKUP in appsheet.

IF(Lookup

[SkrOYC]

LOOKUP() - AppSheet Help

[Aurelien]

Hi @itsmaxsingh 

Both @Steve and @SkrOYC gave you examples and links to documentation. 

You should read these, it is for free and it is useful. I report these below.

In addition, here are a few examples.

If that does not help you, please share what you actually tried, and what you expect.

Share also your table structure (columns and type).

Screenshot are best.

IF(
  LOOKUP(yourValue,"table", "columnToSearch", "columnToReturn")="yourExpectedCriteria",
  valueIfTrue,
  valueIfFalse
)

Alternatively:

SWITCH(LOOKUP(yourValue,"table", "columnToSearch", "columnToReturn")="yourExpectedCriteria",
  expectedValue1,returnValue1,
  expectedValue2,returnValue2,
  returnValueDefault
)

For reference:

IF() - AppSheet Help

LOOKUP() - AppSheet Help

SWITCH() - AppSheet Help

Conditional expressions - AppSheet Help