| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Defind Dynamic named Range up to first error | Excel Worksheet Functions | |||
| #value! error trying to create a simple dynamic named range | Excel Discussion (Misc queries) | |||
| using a dynamic named range in a VLOOKUP | Excel Discussion (Misc queries) | |||
| Trapping error from Empty Dynamic Named Range | Excel Programming | |||
| VLookup Error in Part of a Named Range | Excel Worksheet Functions | |||
Hybrid Mode
