Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to replace #N/A with my Vlookup
Cant seem to work this out, can you please show me how to replace the #N/A with a blank if the value searched is not found
=VLOOKUP(D2,Q2:W47,6, False) many thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to replace #N/A with my Vlookup
Hi Charlotte,
Am Mon, 15 Feb 2016 12:13:13 -0800 (PST) schrieb : =VLOOKUP(D2,Q2:W47,6, False) try it with: =IFERROR(VLOOKUP(D2,Q2:W47,6, False),"") Regards Claus B. -- Vista Ultimate / Windows7 Office 2007 Ultimate / 2010 Professional |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i replace #n/a in a vlookup? | Excel Worksheet Functions | |||
replace vlookup | Excel Programming | |||
Replace a vlookup #N/A result with a value | Excel Worksheet Functions | |||
How do I replace a return value of #N/A in a vlookup with zero? | Excel Worksheet Functions | |||
When VLOOKUP returns a #N/A How can you get it to replace #N/A wi. | Excel Worksheet Functions |