|
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 |
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 |
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 |
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 |
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 |
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 |
| All times are GMT +1. The time now is 04:22 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com