| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Q on how to search for text in a column
Hi folks,
I'm not sure if this matters or not, but I'm using Excel 2007 to create files used in 2007 and 2003. I have a list of codes in a column with pertinent data in following columns. Example of column 1: CYAB CYAM CYYJ CYYR CYYT OTHER I would like to be able to enter a code on one worksheet and have that input searched through the column for an exact match so that I can refer to data along its row. If the code entered does not match any in the list, I would like to be referred to the "OTHER" line. I am stymied. Can anyone lend a hand? Many thanks! Craig |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Search For Common Text in Column | Excel Worksheet Functions | |||
| Search text string for ssn and copy to new column | Excel Discussion (Misc queries) | |||
| search a column for last instance of text | Excel Discussion (Misc queries) | |||
| Search a Column by text length | Excel Worksheet Functions | |||
| Search column and move text formula | Excel Discussion (Misc queries) | |||
Threaded Mode
