=VLOOKUP('ITEM ADD-CHG Form'!Z19,Brand_V,2,FALSE)
Another wrench!
If the value in cell Z19 is not found in the named range "Brand_V", the formula returns #N/A
I need to replace #N/A with the verbiage DEF while leaving the other results intact.
=VLOOKUP('ITEM ADD-CHG Form'!Z19,Brand_V,2,FALSE)
Another wrench!
If the value in cell Z19 is not found in the named range "Brand_V", the formula returns #N/A
I need to replace #N/A with the verbiage DEF while leaving the other results intact.
Last edited by amthyst826; 02-19-2010 at 07:15 PM.
Which version of Excel are you using? In Excel 2007 you can use IFERROR, i.e.
=IFERROR(VLOOKUP('ITEM ADD-CHG Form'!Z19,Brand_V,2,FALSE),"DEF")
or in earlier versions
=IF(ISNA(VLOOKUP('ITEM ADD-CHG Form'!Z19,Brand_V,2,FALSE)),"DEF",VLOOKUP('ITEM ADD-CHG Form'!Z19,Brand_V,2,FALSE))
Awesome! Thank you very much!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks