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

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)),"Custome r 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

"Karen Hunter" wrote:

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

Use

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

why don't you just use validation and prevent misspelling


--
Regards,

Peo Sjoblom



"Karen Hunter" wrote in message
...
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

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


"Peo Sjoblom" wrote:

Use

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

why don't you just use validation and prevent misspelling


--
Regards,

Peo Sjoblom



"Karen Hunter" wrote in message
...
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

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.
--
Karen Hunter


"Mike H" wrote:

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)),"Custome r 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

"Karen Hunter" wrote:

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