VLOOKUP Error using a dynamic named range
 

Greetings everyone!

I have a spreadsheet that uses a named range as:
=offset(CHASE!$A$2,0,-1,COUNTA(CHASE!$A:$A),3)

and a vlookup referencing this range as:
=VLOOKUP($A838,CHASE1,2,FALSE). How can I get the value of null or "" to
populate the cells instead of #N/A when $A838 isn't found in the named range?

Thanks in advance.

VLOOKUP Error using a dynamic named range
 

Nevermind! I got it using an ISNA statement.

"brentm" wrote:

Greetings everyone!

I have a spreadsheet that uses a named range as:
=offset(CHASE!$A$2,0,-1,COUNTA(CHASE!$A:$A),3)

and a vlookup referencing this range as:
=VLOOKUP($A838,CHASE1,2,FALSE). How can I get the value of null or "" to
populate the cells instead of #N/A when $A838 isn't found in the named range?

Thanks in advance.