VLOOKUP Error using a dynamic named range

[brentm]

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.

 

[brentm]

Nevermind! I got it using an ISNA statement.