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...
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
an example file (without sensitive data) would be advantageous ... for you and for those who would like / are allowed to help
NikolinoDE Please find the sample file
Can it help you like this?
Is with conditional formatting.
If it doesn't help, please give us a short feedback.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.
- Please provide formula for that one