Forum Discussion
Solved
How to make VLOOKUP return multiple error values
Hi all Not sure if this is possible, but what I am trying to do is a regular VLOOKUP with the caveat that: Where the lookup value is an empty cell, instead of N/A, the formula returns "Unkno...
Let's say you have
=VLOOKUP(A2, $F$2:$G$100, 2, FALSE)
Change this to
=IF(A2="", "Unknown", VLOOKUP(A2, $F$2:$G$100, 2, FALSE))
Let's say you have
=VLOOKUP(A2, $F$2:$G$100, 2, FALSE)
Change this to
=IF(A2="", "Unknown", VLOOKUP(A2, $F$2:$G$100, 2, FALSE))
- Thanks!!
