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.