Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I need to know how to copy the contents of one cell to another cell based on
a match in two other cells. Something like this: A B C D 1 TH125 1.25 YG452 2 YG452 3.65 KE956 3 UH555 2.30 AM522 4 KE956 6.33 GH522 What I need to do is match the contents in columns A and C and if they match insert the value for B into D As you can tell the contents in column A do are also in C but not in the same order, there is nothing in D which are the cells I need to polulate from B. Also, A has 12000 rows where C may only have 3000. If there is not match then D should remain blank or 0 When completed it should look like this: A B C D 1 TH125 1.25 YG452 3.65 2 YG452 3.65 KE956 6.33 3 UH555 2.30 AM522 4 KE956 6.33 GH522 Is this possible, Seems I did it many years ago in Excel 2003 but cannot remember how. Thanks a bunch |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Anyone?
"TerryB" wrote: I need to know how to copy the contents of one cell to another cell based on a match in two other cells. Something like this: A B C D 1 TH125 1.25 YG452 2 YG452 3.65 KE956 3 UH555 2.30 AM522 4 KE956 6.33 GH522 What I need to do is match the contents in columns A and C and if they match insert the value for B into D As you can tell the contents in column A do are also in C but not in the same order, there is nothing in D which are the cells I need to polulate from B. Also, A has 12000 rows where C may only have 3000. If there is not match then D should remain blank or 0 When completed it should look like this: A B C D 1 TH125 1.25 YG452 3.65 2 YG452 3.65 KE956 6.33 3 UH555 2.30 AM522 4 KE956 6.33 GH522 Is this possible, Seems I did it many years ago in Excel 2003 but cannot remember how. Thanks a bunch |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I add a cell based on another cells contents? | Excel Discussion (Misc queries) | |||
Copy contents to cell based on value in second cell | Excel Discussion (Misc queries) | |||
matching cell contents | Excel Discussion (Misc queries) | |||
Add Rows based on Cell contents | Excel Discussion (Misc queries) | |||
Sum numbers based on the contents of another cell | Excel Worksheet Functions |