Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Matching data in columns
I hope somebody can help me.
I have a list in column C of 13000 names with a reference number against each of them in column D. The reference numbers are between 1 and 760 and each of the 13,000 names in column C has one of the 760 numbers against it in column D. In column F, I have the list of 760 numbers with text for each of these numbers in column G. I need to correctly insert the text for all these 760 names against my main list of 13,000 names. To try to explain it I want to: If number in any cell in column D equals the same number in any cell column F, then paste the text in column G for that number to column E, to correspond with the same number in column D. I hope this is clear! Daria |
#2
|
|||
|
|||
Hi
Add a sheet, p.e. References, and enter all unique reference numbers into column A, and according reference texts into column B - i.e. you'll have there a table in range A1:B760 On your sheet with names, enter p.e. into cell F2 the formula =VLOOKUP(D2,References!$A$1:$B$760,2,0) and copy it into all 13000 cells in column C -- When sending mail, use address arvil<attarkon.ee Arvi Laanemets "Daria1977" wrote in message ... I hope somebody can help me. I have a list in column C of 13000 names with a reference number against each of them in column D. The reference numbers are between 1 and 760 and each of the 13,000 names in column C has one of the 760 numbers against it in column D. In column F, I have the list of 760 numbers with text for each of these numbers in column G. I need to correctly insert the text for all these 760 names against my main list of 13,000 names. To try to explain it I want to: If number in any cell in column D equals the same number in any cell column F, then paste the text in column G for that number to column E, to correspond with the same number in column D. I hope this is clear! Daria |
#3
|
|||
|
|||
Thank you very much, You have made me very happy!
Daria "Arvi Laanemets" wrote: Hi Add a sheet, p.e. References, and enter all unique reference numbers into column A, and according reference texts into column B - i.e. you'll have there a table in range A1:B760 On your sheet with names, enter p.e. into cell F2 the formula =VLOOKUP(D2,References!$A$1:$B$760,2,0) and copy it into all 13000 cells in column C -- When sending mail, use address arvil<attarkon.ee Arvi Laanemets "Daria1977" wrote in message ... I hope somebody can help me. I have a list in column C of 13000 names with a reference number against each of them in column D. The reference numbers are between 1 and 760 and each of the 13,000 names in column C has one of the 760 numbers against it in column D. In column F, I have the list of 760 numbers with text for each of these numbers in column G. I need to correctly insert the text for all these 760 names against my main list of 13,000 names. To try to explain it I want to: If number in any cell in column D equals the same number in any cell column F, then paste the text in column G for that number to column E, to correspond with the same number in column D. I hope this is clear! Daria |
#4
|
|||
|
|||
Excuse Arvi, but
where you say: On your sheet with names, enter p.e. into cell F2 the formula =VLOOKUP(D2,References!$A$1:$B$760,2,0) and copy it into all 13000 cells in column C wouldn't it be: On your sheet with names, enter p.e. into cell E2 the formula =VLOOKUP(D2,References!$A$1:$B$760,2,0) and copy it into all 13000 cells in column E ? Sorry, just throwing it out... "Arvi Laanemets" wrote in message ... Hi Add a sheet, p.e. References, and enter all unique reference numbers into column A, and according reference texts into column B - i.e. you'll have there a table in range A1:B760 On your sheet with names, enter p.e. into cell F2 the formula =VLOOKUP(D2,References!$A$1:$B$760,2,0) and copy it into all 13000 cells in column C -- When sending mail, use address arvil<attarkon.ee Arvi Laanemets "Daria1977" wrote in message ... I hope somebody can help me. I have a list in column C of 13000 names with a reference number against each of them in column D. The reference numbers are between 1 and 760 and each of the 13,000 names in column C has one of the 760 numbers against it in column D. In column F, I have the list of 760 numbers with text for each of these numbers in column G. I need to correctly insert the text for all these 760 names against my main list of 13,000 names. To try to explain it I want to: If number in any cell in column D equals the same number in any cell column F, then paste the text in column G for that number to column E, to correspond with the same number in column D. I hope this is clear! Daria |
#5
|
|||
|
|||
Hi
"Jim May" wrote in message news:A0JNd.55480$jn.37513@lakeread06... Excuse Arvi, but where you say: On your sheet with names, enter p.e. into cell F2 the formula =VLOOKUP(D2,References!$A$1:$B$760,2,0) and copy it into all 13000 cells in column C wouldn't it be: On your sheet with names, enter p.e. into cell E2 the formula =VLOOKUP(D2,References!$A$1:$B$760,2,0) and copy it into all 13000 cells in column E ? Looks like you are right. I was confused with OP's directions a bit - I didn't realise, that she has there 2 different tables together. But it looks like she got it anyway! -- When sending mail, use address arvil<attarkon.ee Arvi Laanemets |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Colors of columns after sorting data in the supporting table | Charts and Charting in Excel | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Comparing data in two columns and highlighting the data | Excel Worksheet Functions | |||
Lookup Data in Several Columns | Excel Worksheet Functions | |||
Comparing Data in two columns | Excel Worksheet Functions |