If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|