Return Specific Value in VLookup if no exact match

[Robert Edens]

When using VLookup and exact match, if I do not find an exact match in the table, I would like the cell with VLookup to resolve with a predetermined value.

 

[VoG]

Try like this

=IF(ISNA(your formula),your predetermined value,your formula)

 

[Robert Edens]

Thank you, but that did not work. Here is my formula...
=VLOOKUP(Customer_Name,CustomerList,2,FALSE) and it works. But when I don't have a match in the lookup, I want it to Resolve to Street Address.

If I understood your suggestion I get the response that there are too many arguments. I tried two versions of your suggestion.

Number 1:
=IF(ISNA(VLOOKUP(Customer_Name,CustomerList,2,FALSE),Street Address,Customer_Name,CustomerList,2,FALSE)

Number 2:
=IF(ISNA(VLOOKUP(Customer_Name,CustomerList,2,FALSE),Street Address,(VLOOKUP(Customer_Name,CustomerList,2,FALSE)

 

[VoG]

Try like this. If Street Address is a named range it cannot have a space it must be Street_Address (as I have used) or StreetAddress

=IF(ISNA(VLOOKUP(Customer_Name,CustomerList,2,FALSE)),Street_Address,VLOOKUP(Customer_Name,CustomerList,2,FALSE))

 

[Robert Edens]

Street Address is not a "Named Range", it is the value I wish to have the formula resolve too if their is not an exact match.

 

[T. Valko]

Thank you, but that did not work. Here is my formula...
=VLOOKUP(Customer_Name,CustomerList,2,FALSE) and it works. But when I don't have a match in the lookup, I want it to Resolve to Street Address.

If I understood your suggestion I get the response that there are too many arguments. I tried two versions of your suggestion.

Number 1:
=IF(ISNA(VLOOKUP(Customer_Name,CustomerList,2,FALSE),Street Address,Customer_Name,CustomerList,2,FALSE)

Number 2:
=IF(ISNA(VLOOKUP(Customer_Name,CustomerList,2,FALSE),Street Address,(VLOOKUP(Customer_Name,CustomerList,2,FALSE)

If you're using Excel 2007 or later then you can use the IFERROR function.

=IFERROR(VLOOKUP(Customer_Name,CustomerList,2,0),predetermined value)

 

[VoG]

Street Address is not a "Named Range", it is the value I wish to have the formula resolve too if their is not an exact match.

Then try

=IF(ISNA(VLOOKUP(Customer_Name,CustomerList,2,FALSE)),"Street Address",VLOOKUP(Customer_Name,CustomerList,2,FALSE))

 

[Robert Edens]

The IFERROR formula returns the correct answer if an exact match is found, but it does not return the predetermined value if there is no match. It returns #NAME?

 

[VoG]

Try

=IFERROR(VLOOKUP(Customer_Name,CustomerList,2,0),"Street Address")

 

[Robert Edens]

VoG,
that worked. Thank you very much. Problem resolved...
Bob