Excel query

Soldato
Joined
22 Nov 2007
Posts
4,209
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
 
Back
Top Bottom