Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
vlookup question if item isn't in table
How can I change a VLOOKUP formula to provide a set response if the item
being searched for in the VLOOKUP is not in the table? I have a formula that looks up a part number entered into column B and fills in column F with data if the part number entered in column B is in my table. =IF(B64="","",VLOOKUP(B64,ProductLookup,8,FALSE)) If B64 isn't in the ProductLookup table, I want the column F to default to Hdwr/Sftwr rather than #N/A. Thanks, Nancy |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
vlookup question if item isn't in table
Excel 2003 & earlier:
=IF(B64="","",IF(ISNA(VLOOKUP(B64,ProductLookup,8, FALSE)),"Hdwr/Sftwr",VLOOKUP(B64,ProductLookup,8,FALSE))) in Excel 2007: =IF(B64="","",IFERROR(VLOOKUP(B64,ProductLookup,8, FALSE)),"Hdwr/Sftwr") "NANGO" wrote in message ... How can I change a VLOOKUP formula to provide a set response if the item being searched for in the VLOOKUP is not in the table? I have a formula that looks up a part number entered into column B and fills in column F with data if the part number entered in column B is in my table. =IF(B64="","",VLOOKUP(B64,ProductLookup,8,FALSE)) If B64 isn't in the ProductLookup table, I want the column F to default to Hdwr/Sftwr rather than #N/A. Thanks, Nancy |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
vlookup question if item isn't in table
=IF(B64="","",IF(ISNA(VLOOKUP(B64,ProductLookup,8, FALSE)),"Hdwr/Sftwr",VLOOKUP(B64,ProductLookup,8,FALSE)))
best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "NANGO" wrote in message ... How can I change a VLOOKUP formula to provide a set response if the item being searched for in the VLOOKUP is not in the table? I have a formula that looks up a part number entered into column B and fills in column F with data if the part number entered in column B is in my table. =IF(B64="","",VLOOKUP(B64,ProductLookup,8,FALSE)) If B64 isn't in the ProductLookup table, I want the column F to default to Hdwr/Sftwr rather than #N/A. Thanks, Nancy |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
vlookup question if item isn't in table
One way ..
Use: =IF(B64="","",IF(ISNA(VLOOKUP(B64,ProductLookup,8, 0)),"Hdwr/Sftwr",VLOOKUP(B64,ProductLookup,8,0))) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "NANGO" wrote: How can I change a VLOOKUP formula to provide a set response if the item being searched for in the VLOOKUP is not in the table? I have a formula that looks up a part number entered into column B and fills in column F with data if the part number entered in column B is in my table. =IF(B64="","",VLOOKUP(B64,ProductLookup,8,FALSE)) If B64 isn't in the ProductLookup table, I want the column F to default to Hdwr/Sftwr rather than #N/A. Thanks, Nancy |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
vlookup question if item isn't in table
Thank you so much! I actually run 2007, however others run 2003 so I'm
gratefull you provided both ways. "Bob Umlas" wrote: Excel 2003 & earlier: =IF(B64="","",IF(ISNA(VLOOKUP(B64,ProductLookup,8, FALSE)),"Hdwr/Sftwr",VLOOKUP(B64,ProductLookup,8,FALSE))) in Excel 2007: =IF(B64="","",IFERROR(VLOOKUP(B64,ProductLookup,8, FALSE)),"Hdwr/Sftwr") "NANGO" wrote in message ... How can I change a VLOOKUP formula to provide a set response if the item being searched for in the VLOOKUP is not in the table? I have a formula that looks up a part number entered into column B and fills in column F with data if the part number entered in column B is in my table. =IF(B64="","",VLOOKUP(B64,ProductLookup,8,FALSE)) If B64 isn't in the ProductLookup table, I want the column F to default to Hdwr/Sftwr rather than #N/A. Thanks, Nancy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLookup - can I set my formula to fill in date if item isn't in ta | Excel Discussion (Misc queries) | |||
Vlookup/Pivot table question | Excel Worksheet Functions | |||
Pivot Table Calculated Item | Excel Discussion (Misc queries) | |||
Pivot Table Calculated Item | Excel Discussion (Misc queries) | |||
Pivot Table Calculated Item | Excel Discussion (Misc queries) |