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 Hunter