• Notice regarding image hosts and attachments. See here.

Excel query

Soldato
Joined
22 Nov 2007
Posts
4,412
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