tank

Using Excel 2016. In the GMH Table, I am attempting to Lookup "Gas Tank Fill" in Event column of the History Table to return the date from same row in the Out column of the History Table using a table that will advance the formula when the next row is added. =LOOKUP("Gas Tank...

I have cell J11 with a drop down list which are 1,2,3,4. I need that: 1. When I choose 1, in cell c16 appears cell 'Tank 1'!E9 2. When I choose 2, in cell c16 appears cell 'Tank 2'!E9 3. When I choose 3, in cell c16 appears cell 'Tank 3'!E9 4. When I choose 4, in cell c16 appears cell 'Tank...

I have cell J11 with a drop down list which are 1,2,3,4. I need that: 1. When I choose 1, in cell c16 appears cell 'Tank 1'!E9 2. When I choose 2, in cell c16 appears cell 'Tank 2'!E9 3. When I choose 3, in cell c16 appears cell 'Tank 3'!E9 4. When I choose 4, in cell c16 appears cell 'Tank...

I have read some of the other posts, but can't seem to get the suggested formulas to work right. I've tried using vlookup, isblank, index/match, etc. I have a summary sheet in one tab where I want to lookup a tank number in the first column and get the first non-blank result for that tank...

Hi Guys, I'm new here and new to anything but the basics of excel. Trying to make a cell for fuel tank capacity based on the height (dip) of the fuel. Tank is uneven. The individual formulas work in a sheet where you have to put the figure in the corresponding cell, e.g between 43 to 63, however...

Hi All Bit of maths help please. There is a tank of Active Carbon, which when full to 100% holds 57 M3(meters Cubed) (1% of the tank would be 0.57 M3) If the amount used in a day was say 1% which is 0.57 M3, how do i convert this to tonnes? Any help will be greatly received.

Hi All New to this forum so not sure if it's the correct place to get help creating a spreadsheet. I tried an excel freelancer but they couldn't seem to make the calculations work proportionately. It's simple to do on paper but creating a formula seems to be more difficult. I'm not an expert on...