G
Guest
Hi,
As you know, when VLOOKUP uses "FALSE" for Range_lookup and no exact match
is made, Excel produces an output "#N/A".
This is messing up formulae that are based on the output of cells where this
formula is used, where then produce the same "#N/A".
I have tried using an If function in conjunction with VLOOKUP but it did not
produce the desired effect. Can someone please tell me if this is possible
(and I have made a mistake) or is there some other way.
Thanks in advance for any feedback.
Sam
As you know, when VLOOKUP uses "FALSE" for Range_lookup and no exact match
is made, Excel produces an output "#N/A".
This is messing up formulae that are based on the output of cells where this
formula is used, where then produce the same "#N/A".
I have tried using an If function in conjunction with VLOOKUP but it did not
produce the desired effect. Can someone please tell me if this is possible
(and I have made a mistake) or is there some other way.
Thanks in advance for any feedback.
Sam