B
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.
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.