View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Always need help asap :-) Always need help asap :-) is offline
external usenet poster
 
Posts: 1
Default Finding text in a range

Hello. I'm a fairly new user to Excel and need help with an IF statement.
I've tried using ISTEXT, but that only seems to work with single cells.

I have a spreadsheet several columns wide and in the first column, need to
put a value, based on which column the text is in (There's only 1 item per
line).

Example:
Col A B C D..... J H I ..... W X Y Z
Results Text
Results Text

If the text is in Col. D, I need the result to be "IBM", if it's in Col. H,
then "CA", etc.
Can someone help me with this, please?