Vlookup formula based on 2 column values

[Satish.digit]

Hi,


I have excel sheet which has employee performace like below:

[pre]

A  Name    B Parameter  C Jan   D Feb   E Mar   F Apr   G May
A1 Satish  B1 Prod%     C1 98%  D1 95%  E1 97%  F1 96%  G1 94%
A2 Satish  B2 Acc%      C2 98%  D2 95%  E2 97%  F2 96%  G2 94%
A3 Sarita  B3 Prod%     C3 98%  D3 95%  E3 97%  F3 96%  G3 94%
A4 Sarita  B4 Acc%      C4 98%  D4 95%  E4 97%  F4 96%  G4 94%
in this data i need only Prod% for all the employees in Sheet2(SheetName-Prod)like below

A  Name    B Parameter  C Jan   D Feb   E Mar   F Apr   G May
A1 Satish  B1 Prod%     C1 98%  D1 95%  E1 97%  F1 96%  G1 94%
A2 Sarita  B2 Prod%     C2 98%  D2 95%  E2 97%  F2 96%  G2 94%

[/pre]
for June month onwards if i update in Main sheet prod sheet should update automatically.


i need a formula for this.


Regards,

Digit

 

[Luke M]

See here for how to do a lookup based on multiple criteria (Name and Parameter, in this case)

http://chandoo.org/wp/2010/11/02/multi-condition-lookup/