Find

**vthokie2010** · 01-15-2010, 10:34 AM

I am trying to automate this huge query that has a description field. In it it will say something like this:
TIP
TIP-MID
TIP MIDDLE
BUTT MIDDLE
BUT
BUTT-MID
BUTT MID
Each line is a different example. How can I get this to distinguish between TIP and TIP-MID or any of those varieties. Sometimes the same cell will have:
TIP, TIP-MID
BUTT, TIP, TIP MIDDLE
Pretty much any combination you can think of. I need it to pick up each one and distinguish between TIP and TIP MIDDLE etc since the FIND function only searches for the word I can't figure out how to adjust.

edit: Here are some more exact examples.

AD AB BROKEN TIP AND TIP-MID,RCVD W/CASE AND SACK
AD AC BROKEN BUTT AND BUTT-MID,RCVD ROD ONLY
AD AC BROKEN TIP-MID AND BUTT-MID,RCVD W/CASE
AC BROKEN TIP MIDDLE AND TIP AND BUTT-MID

Thanks in advance.

**NBVC** · 01-15-2010, 10:35 AM

What kind of result are you looking for?

**vthokie2010** · 01-15-2010, 10:51 AM

I want to look in the description and return the specific component TIP, TIP-MID, BUTT, BUTT-MID.
I have it set up like this right now
=IF(ISERROR(FIND("TIP",G3535)), 0, 50)
returns 50 if it finds TIP 0 if unable to match. Only problem it is will give me 50 if it says TIP-MID. I have another cell that would catch the TIP-MID and return 75. If it only has TIP-MID it should only catch the 75 not the 75 and 50. Also if it has TIP and TIP-MID I need it to catch both the 50 in one cell and 75 in the other.