matthewoaks
New Member
- Joined
- Jan 31, 2014
- Messages
- 30
https://www.dropbox.com/s/9nj4qgrd71wd5ex/Copy of Ullage Report.xlsx?dl=0
We have designed a simple spreadsheet with some Vlookup formulas to look at calibration tables of a tank volume within the workbook but on separate tabs.
Basically the chief officer onboard the ship will enter a ullage number in mm an the relevant volume will appear automatically from those tables.
I would like to know if it was possibly or rather what would be the best method for them to do this backward as well on the same spreadsheet. So they input a volume figure and the ullage will appear.
If you would like to look at the spreadsheet I've uploaded it in the above link.
If you look at 3 grades tab
Officer currently enters a number over 330 into Column C, Vlookup appears in column I
They also want to be able to enter a number in column I and the figure auto-populates in column C
Thanks in advance
Matt
We have designed a simple spreadsheet with some Vlookup formulas to look at calibration tables of a tank volume within the workbook but on separate tabs.
Basically the chief officer onboard the ship will enter a ullage number in mm an the relevant volume will appear automatically from those tables.
I would like to know if it was possibly or rather what would be the best method for them to do this backward as well on the same spreadsheet. So they input a volume figure and the ullage will appear.
If you would like to look at the spreadsheet I've uploaded it in the above link.
If you look at 3 grades tab
Officer currently enters a number over 330 into Column C, Vlookup appears in column I
They also want to be able to enter a number in column I and the figure auto-populates in column C
Thanks in advance
Matt
