VLOOKUP returns N/A - Need to return blank cell

Hi,

I have a normal VLOOKUP of this loookup range:

A 1
B 2
C 3
D 4

=VLOOKUP(T14,U6:V9,2,TRUE)

If the value in T14 is in the lookup range, I get the expected value returned. If the value exceeds the vlaues in the lookup range (e.g. I enter "E"), I get the last value in the range (4).

How do I get it to return a blank cell if the entry in T14 is not found?

You need to use FALSE rather than TRUE if you want an Exact match (ie entering E returns an error), eg:

=VLOOKUP(T14,U6:V9,2,FALSE)

If you want Blank returned if an Exact match is not found conduct as ISNUMBER(MATCH test on T14 against U prior to executing the VLOOKUP, eg:

=IF(ISNUMBER(MATCH(T14,U6:U9,0)),VLOOKUP(T14,U6:V9,2,FALSE),"")

Aah, I see you are from Fife... I went to Uni at St.Andrews and miss that part of the world...