Sorry, think I mis-read it earlier ..

Put this in C1, array-enter the formula by pressing CTRL+SHIFT+ENTER
(instead of just pressing ENTER):
=INDEX($B$1:$B$4,MATCH(TRUE,ISNUMBER(SEARCH($B$1:$ B$4,A1)),0))
Copy C1 down to the extent of data in col A. This will return the results
that you seek,
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"GD1226, Captain Ahab, manface" wrote
Thanks for the response. I tried that formula and it returns:

C1: Baseball
C2: Footbal
C3: Soccer
C4: Golf
C5: <blank
C6: <blank

Basically, it's returning the base comparison items instead of looking
it up and finding which to print.

Any other ideas? I really appreciate the help