Help with VLOOKUP using two criteria please!!

[sarah_watson]

Hello,

First an apology if this is in a sticky or another answer already, I did have a search but turned up nothing. I'm new here so please be gentle!

OK, here is the problem. I need to do a VLOOKUP formula but it must match two criteria to pull the value through.

The table below shows a sample of my data [it is from a pivot table but I've pasted the values out to make it easier to work with]:

[TABLE="width: 500"]
<tbody>[TR]
[TD]Row labels[/TD]
[TD]MPG[/TD]
[/TR]
[TR]
[TD]58911[/TD]
[TD]40[/TD]
[/TR]
[TR]
[TD="align: right"]KU60TB[/TD]
[TD]34[/TD]
[/TR]
[TR]
[TD="align: right"]DP47JT[/TD]
[TD]44[/TD]
[/TR]
</tbody>[/TABLE]

An employee with payroll number 58911 has driven two cars and gets 34 MPG in one of them and 44 MPG in the other.

On a separate tab I have a list of payroll numbers and current vehicles. Also a blank column for MPG. I need it to pull through the MPG for the driver for their current vehicle only. So in the above case it needs to match payroll number 58911 AND vehicle reg KU60TB and display 34 as the gas consumption.

Any help would be much appreciated, if you need more information please let me know.

Thanks!
S.

 

[hemesh]

Sarah Can you please upload your look up table also