Help with formula

B

Bob

This formula works fine as long as there is a match in the "Customer
Record"
=IF(A3="","",INDEX('Customer Record'!B:B,MATCH(A3,'Customer Record'!
A:A,0),1))
But... is there a way to modify it to allow me to enter my own value
in Column B if there is no match.
Thanks in advance!!
 
I

isabelle

hi Bob,

=IF(A3="","",IF(ISERROR(MATCH(A3,'Customer Record'!A:A,0)),"Your Value",INDEX('Customer Record'!B:B,MATCH(A3,'Customer Record'!A:A,0),1)))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with formula 2
match and index function - getting it to keep its original referencecell, in spite of sorting the da 1
Whole Column Conditional Formatting 2
Count Values in a Range, Not Formulas 2
FORMULA Help 2
Building closed workbook file path within an Index Function 6
"Match" function - erratic behavior in Excel 2007 but not 2003 4
formula error 1

Top