How can I do this in excel?

[Dafella]

All

I have a spreadsheet like this:

Sheet 1
Jan Feb Mar Apr May Jun
Col A Col B Col C Col D Col E 0 0 0 0 0 0 0

SVOP SOM013 SB124 SoES - Client Support Technical
(284) 0 0 0 0 0 0 0
DKL
E3P
ZLP



Sheet 2

Col A Col B Col C Jan Feb Mar Apr May
SB124 DKL 10 11 20 6 7
SB124 E3P 22 17 10 17 27
SB124 ZLP 90 41 50 61 14
SB125 DKL 10 11 20 6 7
SB125 DKL 19 21 10 16 17
SB125 DKL 14 31 70 68 71



I'd like to lookup the value where Sheet1(Col D) = Sheet 2(Col A) and
Sheet1(Col A) = Sheet 2(Col B).

I'm posting actual hours worked by a group on a project.


Thanks in advance
Steve