Excel query

Bassmansam · 5 Jan 2022 at 22:53

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 · 5 Jan 2022 at 23:04

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 · 6 Jan 2022 at 10:01

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 · 8 Jan 2022 at 19:08

Bassmansam said:
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).