Hi all,
I am using the following formula to look up a value when validated data "yes"or "no" is in A1.
=IF(A1="yes",vlookup(b1:c10,3),vlookup(b1:c10,4)
this works ok if "yes" or "no" is in A1.
how can I stop it giving #N/A if neither is selected in A1.
Thank you in advance.
Greg.
Bookmarks