--
John from Bognor


"JE McGimpsey" wrote:

One way:

=IF(ISNA(MATCH(A1,J1:J100,FALSE)),"",VLOOKUP(A1,J1 :K100,2,FALSE))

In article ,
JR wrote:

When Look up returns #N/A as there is no exact match in the range. Is it
possible to leave the cell blank? ie is there an "IF" "THEN" "ELSE" type
function tha can be added to the look up formula?



Thanks for the reply.

The formula I currently have is a simple =HLOOKUP($K$1,B3:H3,1,FALSE)

How would I re write this to match the formula suggested?