vlookup with multiple drown list

[Arup Dutta Chowdhury]

I have a work book where I want to derive the value by selecting name and month. The value will automatically change when I change the name and month.

 

[bosco_yip]

In "Value" C9, enter formula :

=VLOOKUP(C7,B3:E5,MATCH(C8,B2:E2,0),0)

Regards
Bosco

 

[Arup Dutta Chowdhury]

Thanks