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

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

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

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

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