VLOOKUP based on two criteria

[kumawat_s]

I am looking a function (may be vlookup) which can provide the value based on two conditions.

I am attaching a xls file.

When I use vlookup based on column A it gives wrong value because column A value are multiple in list.

If I use use colun C the same problem is there.

How can I use VLOOKUP (or any other function) based on two criteria (first column A and then column C) and get the column D value (batch)

I am using XP.

Please reply urgently as my boss has given me limited time


thanks