software

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 quot;Falsequot; or quot;#Value!quot;. Please
help.

Thanks
phyllis b.

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

quot;Phyllis B.quot; gt; wrote in message
...
gt; Hi,
gt;
gt; Can anyone tell me the best way to accomplish this.
gt;
gt; I have two worksheets the first on contains these columns and data
gt;
gt; A B C D
gt; 1 EE# Qtr Ded Code Amount
gt; 2 1010 1 FIT 39.95
gt; 3 1010 1 SIT 4.65
gt; 4 1010 2 FIT 39.95
gt; 5 1010 2 SIT 4.65
gt; 6 1012 1 SDI 10.15
gt; 7 1012 2 SDI 10.15
gt;
gt; My second worksheet looks like this
gt;
gt; EE# Qtr FIT SIT SDI
gt; 1010 1
gt; 1010 2
gt; 1012 1
gt; 1012 2
gt;
gt; I want to take the amounts from worksheet 1 column D and input them into
gt; the
gt; appropriate column on worksheet 2 based on the EE#, Qtr and Ded Code. I
gt; tried index match, but it kept returning either quot;Falsequot; or quot;#Value!quot;.
gt; Please
gt; help.
gt;
gt; Thanks
gt; phyllis b.
thank Biff, it worked like a charm. You're the best.

quot;Biffquot; wrote:

gt; Hi!
gt;
gt; Try this:
gt;
gt; Enter this formula in Sheet2 C2:
gt;
gt; =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)
gt;
gt; Copy across to E2 then down.
gt;
gt; Biff
gt;
gt; quot;Phyllis B.quot; gt; wrote in message
gt; ...
gt; gt; Hi,
gt; gt;
gt; gt; Can anyone tell me the best way to accomplish this.
gt; gt;
gt; gt; I have two worksheets the first on contains these columns and data
gt; gt;
gt; gt; A B C D
gt; gt; 1 EE# Qtr Ded Code Amount
gt; gt; 2 1010 1 FIT 39.95
gt; gt; 3 1010 1 SIT 4.65
gt; gt; 4 1010 2 FIT 39.95
gt; gt; 5 1010 2 SIT 4.65
gt; gt; 6 1012 1 SDI 10.15
gt; gt; 7 1012 2 SDI 10.15
gt; gt;
gt; gt; My second worksheet looks like this
gt; gt;
gt; gt; EE# Qtr FIT SIT SDI
gt; gt; 1010 1
gt; gt; 1010 2
gt; gt; 1012 1
gt; gt; 1012 2
gt; gt;
gt; gt; I want to take the amounts from worksheet 1 column D and input them into
gt; gt; the
gt; gt; appropriate column on worksheet 2 based on the EE#, Qtr and Ded Code. I
gt; gt; tried index match, but it kept returning either quot;Falsequot; or quot;#Value!quot;.
gt; gt; Please
gt; gt; help.
gt; gt;
gt; gt; Thanks
gt; gt; phyllis b.
gt;
gt;
gt;

You're welcome. Thanks for the feedback!

Biff

quot;Phyllis B.quot; gt; wrote in message
...
gt; thank Biff, it worked like a charm. You're the best.
gt;
gt; quot;Biffquot; wrote:
gt;
gt;gt; Hi!
gt;gt;
gt;gt; Try this:
gt;gt;
gt;gt; Enter this formula in Sheet2 C2:
gt;gt;
gt;gt; =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)
gt;gt;
gt;gt; Copy across to E2 then down.
gt;gt;
gt;gt; Biff
gt;gt;
gt;gt; quot;Phyllis B.quot; gt; wrote in message
gt;gt; ...
gt;gt; gt; Hi,
gt;gt; gt;
gt;gt; gt; Can anyone tell me the best way to accomplish this.
gt;gt; gt;
gt;gt; gt; I have two worksheets the first on contains these columns and data
gt;gt; gt;
gt;gt; gt; A B C D
gt;gt; gt; 1 EE# Qtr Ded Code Amount
gt;gt; gt; 2 1010 1 FIT 39.95
gt;gt; gt; 3 1010 1 SIT 4.65
gt;gt; gt; 4 1010 2 FIT 39.95
gt;gt; gt; 5 1010 2 SIT 4.65
gt;gt; gt; 6 1012 1 SDI 10.15
gt;gt; gt; 7 1012 2 SDI 10.15
gt;gt; gt;
gt;gt; gt; My second worksheet looks like this
gt;gt; gt;
gt;gt; gt; EE# Qtr FIT SIT SDI
gt;gt; gt; 1010 1
gt;gt; gt; 1010 2
gt;gt; gt; 1012 1
gt;gt; gt; 1012 2
gt;gt; gt;
gt;gt; gt; I want to take the amounts from worksheet 1 column D and input them
gt;gt; gt; into
gt;gt; gt; the
gt;gt; gt; appropriate column on worksheet 2 based on the EE#, Qtr and Ded Code.
gt;gt; gt; I
gt;gt; gt; tried index match, but it kept returning either quot;Falsequot; or quot;#Value!quot;.
gt;gt; gt; Please
gt;gt; gt; help.
gt;gt; gt;
gt;gt; gt; Thanks
gt;gt; gt; phyllis b.
gt;gt;
gt;gt;
gt;gt;