| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
I need a VLOOKUP to display 0 or blank instead of N/A
|
|
#2
|
|||
|
|||
|
=IF(ISNA(MATCH(LookupValue,LookupColumn,0)),"",VLO OKUP(YourFormula)
-- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "Rachel" wrote in message ... |
|
#3
|
|||
|
|||
|
Rachel
=IF(ISNA(your lookup),0,your lookup) or =IF(ISNA(your lookup),"",your lookup) Regards Trevor "Rachel" wrote in message ... |
|
#4
|
|||
|
|||
|
Rachel,
Try: =(IF(ISNA(YourVlookup)),0,YourVlookup) tj "Rachel" wrote: |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| display negative values as a blank cell in Excel | Excel Discussion (Misc queries) | |||
| display negative values as a blank cell in Excel | Excel Discussion (Misc queries) | |||
| In Exel 2000, stop the blank cells (with formulas) from printing. | Excel Discussion (Misc queries) | |||
| conditional formatting blank cell | Excel Discussion (Misc queries) | |||
| Conditional display of a .jpeg file? | Excel Discussion (Misc queries) | |||
Linear Mode
