Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
finding a value between a range | Excel Worksheet Functions | |||
Functions- Finding and counting specified text in cell range | Excel Worksheet Functions | |||
Finding a value associated with a range | Excel Worksheet Functions | |||
finding name within range | Excel Worksheet Functions | |||
finding if name within range | Excel Worksheet Functions |