LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
finding a value between a range Susan Excel Worksheet Functions 9 March 6th 07 12:07 AM
Functions- Finding and counting specified text in cell range holliedavis Excel Worksheet Functions 8 November 22nd 06 05:49 PM
Finding a value associated with a range Raymond Gallegos Excel Worksheet Functions 5 November 25th 05 08:38 PM
finding name within range sheila Excel Worksheet Functions 4 September 14th 05 07:52 AM
finding if name within range sheila Excel Worksheet Functions 9 September 13th 05 04:24 AM


All times are GMT +1. The time now is 09:20 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"