Multiple VLOOKUP on Multiple Values

[db1966]

Not sure if I can even explain this properly, but I'll try!

I'm creating a table to show data pulled from another spreadsheet in the same workbook. What I want to do is extract the data based on two different values, the Contractor Name and Month/Year. I've put together examples that will hopefully help:-

Data1.PNGData2.PNG

the first image, Data1, shows the layout of the data to be extracted. The second image shows the layout of the "new" data to be used for various charts. The data I'm using is in Column E (Data1) named Fig3.

So basically I want to look for the value in column E where the month/year and Contractor match. Does that make sense?!!

Any help, as always, will be appreciated

[Pepe Le Mokko]

Please post a sample sheet. Pictures are nice but useless

[e.isayev]

=sumproduct(($a2=$b$2:$b$9)*(b$1=$a$2:$a$9)*$e$2:$e$9)

assuming that all the datas in same sheet