Excel query

[Bassmansam]

Hi All

Can anyone help with the file sample at the link below please?

On sheet 2 in the file i need to do a vlookup back to sheet 1 but I only need the total price which relates to the bottom ID in column A. I thought about doing an if statement from sheet 2 to check if a cell is not blank then do the vlookup but that didn't work.

https://easyupload.io/z5dzgq

 

[Sui]

You can probably get to the answer using a LOOKUP formula. I can look tomorrow but hopefully someone will pop by before to give you a better answer!

 

[hood1971]

Been having fun with SUMPRODUCT lately
Paste in B2 on sheet 2 and copy down

=SUMPRODUCT((Sheet1!$A$2:$A$21=Sheet2!A2)*(Sheet1!$B$2:$B$21))

 

[gpuerrilla]

I thought about doing an if statement from sheet 2 to check if a cell is not blank then do the vlookup but that didn't work.

You were nearly there then. Use the ISBLANK function (wrap it around the vlookup).