| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Vlookup and returning #n/a
is there a way to return a zero or blank in the place of #n/a in a vlookup
result that is FALSE? |
|
#2
|
|||
|
|||
|
=IF(ISNA(vlookup_formula),0,vlookup_formula)
-- HTH RP (remove nothere from the email address if mailing direct) "Cathrine" wrote in message ... is there a way to return a zero or blank in the place of #n/a in a vlookup result that is FALSE? |
|
#3
|
|||
|
|||
|
Hi
=IF(ISERROR(VLOOKUP(...)),"",VLOOKUP(...)) or =IF(ISNA(VLOOKUP(...)),"",VLOOKUP(...)) (instead "" you can use 0 as return value for error too) -- Arvi Laanemets (When sending e-mail, use address arvil<Attarkon.ee) "Cathrine" wrote in message ... is there a way to return a zero or blank in the place of #n/a in a vlookup result that is FALSE? |
|
#4
|
|||
|
|||
|
Thank you both!!
"Arvi Laanemets" wrote: Hi =IF(ISERROR(VLOOKUP(...)),"",VLOOKUP(...)) or =IF(ISNA(VLOOKUP(...)),"",VLOOKUP(...)) (instead "" you can use 0 as return value for error too) -- Arvi Laanemets (When sending e-mail, use address arvil<Attarkon.ee) "Cathrine" wrote in message ... is there a way to return a zero or blank in the place of #n/a in a vlookup result that is FALSE? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLOOKUP not returning results | Excel Worksheet Functions | |||
| MY VLOOKUP IS RETURNING N/A AND THEREFORE MY TOTAL SUM AT THE BOT. | Excel Discussion (Misc queries) | |||
| VLookup Return Value | Excel Worksheet Functions | |||
| troubleshoot vlookup returning #N/A | Excel Worksheet Functions | |||
| Vlookup returns incorrect match | Excel Discussion (Misc queries) | |||
Hybrid Mode
