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

--
Sam H. Carson