Vlookup - Multiple columns - How do I do this in Excel?

[SteveJ]

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

 

[Bernie Deitrick]

Steve,

You don't say what value you want to look up, just the value where:
Sheet1(Col D) = Sheet 2(Col A) and
Sheet1(Col A) = Sheet 2(Col B).

Do you want the lookup formula to be on Sheet1 or Sheet2? And which
column from which sheet do you want the value of, when the two
conditions above are met?

HTH,
Bernie
MS Excel MVP