conditional formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
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
 
Use

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

why don't you just use validation and prevent misspelling
 
Thank you! I never even thought of that. I know how to do that in Access,
but forgot about it in Excel!
 
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.
 
Back
Top