change cell value based on another cell value

[meonly123]

How to change cell value J2(Quantity) based on tank number in cell H2 (Tank no.) ?

[Ace_XL]

Your current formula in J2 already factors in the value in H2

=SUMIFS(C:C,A:A,H2,B:B,I2)

In essence, it sums Column C values, when the value in Col A matches H2 (tank no.) and the value in Col. B also matches I2 (Depth metres). Since there is only a single match for a unique combination of Col A and Col B it returns the value of that match. In Row 2 it returns the value 1299473 (found in Cell C2906)

Try changing the values in Cells H2 and I2 and see the values change in J2

[meonly123]

Oooops !“You are true!”

Thanks for your help