| 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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Q on how to search for text in a column
Try this:
...........A..........B 1...CYAB....Blue 2...CYAM...Green 3...CYYJ....White 4...CYYR...Brown 5...CYYT...Red 6...OTHER...None A10 = lookup value =VLOOKUP(IF(COUNTIF(A1:A6,A10),A10,"Other"),A1:B6, 2,0) -- Biff Microsoft Excel MVP "TheMilkGuy" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Q on how to search for text in a column
Hey, that looks great! Thanks Biff, can't wait to try it out.
Cheers! Craig On May 15, 12:54*am, "T. Valko" wrote: Try this: ..........A..........B 1...CYAB....Blue 2...CYAM...Green 3...CYYJ....White 4...CYYR...Brown 5...CYYT...Red 6...OTHER...None A10 = lookup value =VLOOKUP(IF(COUNTIF(A1:A6,A10),A10,"Other"),A1:B6, 2,0) -- Biff Microsoft Excel MVP "TheMilkGuy" wrote in message ... 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Q on how to search for text in a column
Hey, that looks great! Thanks Biff, can't wait to try it out.
Cheers! Craig On May 15, 12:54*am, "T. Valko" wrote: Try this: ..........A..........B 1...CYAB....Blue 2...CYAM...Green 3...CYYJ....White 4...CYYR...Brown 5...CYYT...Red 6...OTHER...None A10 = lookup value =VLOOKUP(IF(COUNTIF(A1:A6,A10),A10,"Other"),A1:B6, 2,0) -- Biff Microsoft Excel MVP "TheMilkGuy" wrote in message ... 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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Q on how to search for text in a column
Hey, that looks great! Thanks Biff, can't wait to try it out.
Cheers! Craig On May 15, 12:54*am, "T. Valko" wrote: Try this: ..........A..........B 1...CYAB....Blue 2...CYAM...Green 3...CYYJ....White 4...CYYR...Brown 5...CYYT...Red 6...OTHER...None A10 = lookup value =VLOOKUP(IF(COUNTIF(A1:A6,A10),A10,"Other"),A1:B6, 2,0) -- Biff Microsoft Excel MVP "TheMilkGuy" wrote in message ... 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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Q on how to search for text in a column
You're welcome!
-- Biff Microsoft Excel MVP "TheMilkGuy" wrote in message ... Hey, that looks great! Thanks Biff, can't wait to try it out. Cheers! Craig On May 15, 12:54 am, "T. Valko" wrote: Try this: ..........A..........B 1...CYAB....Blue 2...CYAM...Green 3...CYYJ....White 4...CYYR...Brown 5...CYYT...Red 6...OTHER...None A10 = lookup value =VLOOKUP(IF(COUNTIF(A1:A6,A10),A10,"Other"),A1:B6, 2,0) -- Biff Microsoft Excel MVP "TheMilkGuy" wrote in message ... 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 |
| Reply |
| 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) | |||
Linear Mode
