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...
=IFERROR(VLOOKUP(A2, C:D, 2, FALSE), "NO-REC")
Thanks for stopping by and answering my query,
This formula will produce two output
1) #N/A
2) -
So need to provide condition based on my above two outputs
If #N/A or - occurs I need to do another lookup I don't know how to provide or or if condition in this scenario
This formula will produce two output
1) #N/A
2) -
So need to provide condition based on my above two outputs
If #N/A or - occurs I need to do another lookup I don't know how to provide or or if condition in this scenario