Sep 17 2021 03:19 AM
Hi all
Not sure if this is possible, but what I am trying to do is a regular VLOOKUP with the caveat that:
So far I have only been able to use an IFERROR to pull back "Unknown" for all missing values in the table array.
Is this even possible?
Many thanks :)
Sep 17 2021 03:24 AM
SolutionLet'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))
Sep 17 2021 03:24 AM
SolutionLet'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))