Double lookup formula

[Frank Kabel]

Hi
enter the following array formula (entered with
CTRL+SHIFT+eNTER) in cell B2 on your first sheet:
=INDEX('sheet2'!$C$1:$C$100,MATCH(1,('sheet2'!
$A$1:$A$100=B$1)*('sheet2'!$B$1:$B$100=$A2),0))

and copy this down / to the right

 

[Govind]

Hi Tarzan,

If there are more than one rows with the same valve # and same date, do
you want the quantities to be summed up as well ?

If so,use something like

=SUMPRODUCT((Sheet2!B2:B100=Sheet1!A2)*(Sheet2!A2:A100=Sheet1!B1)*(Sheet2!C2:C100))

Change references accordingly.

Regards

Govind.