vlookup with some conditions

Hi there,

can somebody help me with the following:
I have on file with two tabs, from which I want to do a vlookup but with specific conditions.
I the pictures below, what I want to do is:
In the second table I want to do a vlookup to give me the volumes from the 1st table, but it has to give me only the corresponding for the lines of table 1.
In other words, if the item and the line do exist in the 1st table, it should give the the corresponding volume in the 2nd table.

I guess it is a combination of an if function with vlookup. Can somebody help.

Thank youPic 1.pngPic. 2.png

it is not possible in excel to vlookup from right to left, so in Pic 1 you would need to change your columns to Item, Line, Volume. Then you would want to concantinate your Item and Line in that table, formula would be A1&B1 and drag down, in column C. Then on your second picture in the volume column you would put this formula:

=IFERROR(VLOOKUP(A1&B1,'Sheet1!C1:D3,2,FALSE),"")

I learn something new every day. Thanks.