Converting text from rows to columns
Hi,
Can anyone tell me the best way to accomplish this. I have two worksheets the first on contains these columns and data A B C D 1 EE# Qtr Ded Code Amount 2 1010 1 FIT 39.95 3 1010 1 SIT 4.65 4 1010 2 FIT 39.95 5 1010 2 SIT 4.65 6 1012 1 SDI 10.15 7 1012 2 SDI 10.15 My second worksheet looks like this EE# Qtr FIT SIT SDI 1010 1 1010 2 1012 1 1012 2 I want to take the amounts from worksheet 1 column D and input them into the appropriate column on worksheet 2 based on the EE#, Qtr and Ded Code. I tried index match, but it kept returning either "False" or "#Value!". Please help. Thanks phyllis b. |
Converting text from rows to columns
Hi!
Try this: Enter this formula in Sheet2 C2: =SUMPRODUCT(--(Sheet1!$A$2:$A$7=$A2),--(Sheet1!$B$2:$B$7=$B2),--(Sheet1!$C$2:$C$7=C$1),Sheet1!$D$2:$D$7) Copy across to E2 then down. Biff "Phyllis B." wrote in message ... Hi, Can anyone tell me the best way to accomplish this. I have two worksheets the first on contains these columns and data A B C D 1 EE# Qtr Ded Code Amount 2 1010 1 FIT 39.95 3 1010 1 SIT 4.65 4 1010 2 FIT 39.95 5 1010 2 SIT 4.65 6 1012 1 SDI 10.15 7 1012 2 SDI 10.15 My second worksheet looks like this EE# Qtr FIT SIT SDI 1010 1 1010 2 1012 1 1012 2 I want to take the amounts from worksheet 1 column D and input them into the appropriate column on worksheet 2 based on the EE#, Qtr and Ded Code. I tried index match, but it kept returning either "False" or "#Value!". Please help. Thanks phyllis b. |
Converting text from rows to columns
thank Biff, it worked like a charm. You're the best.
"Biff" wrote: Hi! Try this: Enter this formula in Sheet2 C2: =SUMPRODUCT(--(Sheet1!$A$2:$A$7=$A2),--(Sheet1!$B$2:$B$7=$B2),--(Sheet1!$C$2:$C$7=C$1),Sheet1!$D$2:$D$7) Copy across to E2 then down. Biff "Phyllis B." wrote in message ... Hi, Can anyone tell me the best way to accomplish this. I have two worksheets the first on contains these columns and data A B C D 1 EE# Qtr Ded Code Amount 2 1010 1 FIT 39.95 3 1010 1 SIT 4.65 4 1010 2 FIT 39.95 5 1010 2 SIT 4.65 6 1012 1 SDI 10.15 7 1012 2 SDI 10.15 My second worksheet looks like this EE# Qtr FIT SIT SDI 1010 1 1010 2 1012 1 1012 2 I want to take the amounts from worksheet 1 column D and input them into the appropriate column on worksheet 2 based on the EE#, Qtr and Ded Code. I tried index match, but it kept returning either "False" or "#Value!". Please help. Thanks phyllis b. |
Converting text from rows to columns
You're welcome. Thanks for the feedback!
Biff "Phyllis B." wrote in message ... thank Biff, it worked like a charm. You're the best. "Biff" wrote: Hi! Try this: Enter this formula in Sheet2 C2: =SUMPRODUCT(--(Sheet1!$A$2:$A$7=$A2),--(Sheet1!$B$2:$B$7=$B2),--(Sheet1!$C$2:$C$7=C$1),Sheet1!$D$2:$D$7) Copy across to E2 then down. Biff "Phyllis B." wrote in message ... Hi, Can anyone tell me the best way to accomplish this. I have two worksheets the first on contains these columns and data A B C D 1 EE# Qtr Ded Code Amount 2 1010 1 FIT 39.95 3 1010 1 SIT 4.65 4 1010 2 FIT 39.95 5 1010 2 SIT 4.65 6 1012 1 SDI 10.15 7 1012 2 SDI 10.15 My second worksheet looks like this EE# Qtr FIT SIT SDI 1010 1 1010 2 1012 1 1012 2 I want to take the amounts from worksheet 1 column D and input them into the appropriate column on worksheet 2 based on the EE#, Qtr and Ded Code. I tried index match, but it kept returning either "False" or "#Value!". Please help. Thanks phyllis b. |
All times are GMT +1. The time now is 08:56 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com