View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
brentm brentm is offline
external usenet poster
 
Posts: 35
Default 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.