If I've understood correctly, try this

=VLOOKUP(A1,MyNamedRange,2,TRUE)

Mike

"gigglygover" wrote:

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?