| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
replace N/A by a blank
How do i replace a #N/A that I get sometimes in a Vlookup by A blank ? or
the value if eveything is fine TKS |
|
#2
|
|||
|
|||
|
One way:
=IF(ISNA(MATCH(A1,Sheet2!A:A,FALSE)),"",VLOOKUP(A1 ,Sheet2!A:B,2,FALSE) In article , yyy wrote: How do i replace a #N/A that I get sometimes in a Vlookup by A blank ? or the value if eveything is fine TKS |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to delete blank rows | Excel Discussion (Misc queries) | |||
| blank cell turns to 0 | New Users to Excel | |||
| blank cells | Excel Discussion (Misc queries) | |||
| Blank Cells in Pivot Tables | Excel Discussion (Misc queries) | |||
| VLOOKUP, OFFSET, MATCH PROBLEM, HELP? | Excel Worksheet Functions | |||
Hybrid Mode
