=IF(ISNA(VLOOKUP(A1,MyNamedRange,2,FALSE)),"NotFou nd",VLOOKUP(A1,MyNamedRange,2,FALSE))

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"gigglygover" wrote in message ...
| Need to create a vlookup, but if the vlaue is not found to bring back a word
| rather than the nearest number.
|
| eg looking up number 99 and if my name range data stops at 80 it brings back
| the value next to the 80.
|
| all the code I've done so far is =vlookup(A1,MyNamedRange,2)
|
| looking up whatever is in A1, looking for this in my named range, then
| brining back the value in column 2 of the named range.
|
| I know there's a way, to bring back only the exact match eg if there is no
| 99 then say Not found or leave empty?
|