conditional formula

K

Karen Hunter

I am doing a spreadsheet for purchases. I want to have a formula to make
sure that the user spells the vendor's name correctly. If the vendor name is
spelled correctly, the purchase will go into one column and if it is
misspelled, then the purchase will go into a different column. I created an
IF formula that includes an INDEX to my list of vendors. The logic is there,
but the formula is not working.

=IF(E30=INDEX(Q27:Q33,,R38)," ",F30)
 
M

Mike H

Karen,

I couldn't quite figure out what your formula was trying to do so a
different approach.

=IF(ISERROR(VLOOKUP(E30,Q27:Q30,1,FALSE)),"Customer name not in
database","Customer Found")

Checks cell E30 for the Customer name and validates it in your database
(Q27:Q30?) with a suitable message if the Customer name isn't found.

Mike
 
P

Peo Sjoblom

Use

=IF(ISNUMBER(MATCH(E30,$Q$27:$Q$33,0))R38,F30)

why don't you just use validation and prevent misspelling
 
K

Karen Hunter

Thank you! I never even thought of that. I know how to do that in Access,
but forgot about it in Excel!
 
K

Karen Hunter

Thank you so much. That works beautifully! We have been trying to figure
this out for days. We knew there was a way to do it, we were just going the
wrong way.
 
Top