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 |
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 |
All times are GMT +1. The time now is 11:11 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com