Forum Discussion
Or condition for vlookup output
For my condition if suppose vlookup has two specific output based on that I need to condition with if how it is possible Formula: Vlookup(A2, C:D,2,false) this will produce either #N/A or - as output...
As far as I have understood the problem definition correctly or have translated it, these formulas could help you.
This can be used to suppress the error message
ISNA(VLOOKUP($A$2,$C:$D,2,FALSE))
with this formula your desired text should be appear
=IF(ISERROR(VLOOKUP(A$2,$C:$D,2,0))," NO-REC",VLOOKUP(A$2,$C:$D,2,0))
* Provided that I have correctly translated the formulas into English.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.
* Beware of scammers posting fake support numbers here.