Making A Number Entered Correspond to A Column

[ProductionOperator]

Hello!

I've tried to search for the answer in the forums, but can't seem to find what I need. I'm trying to make a spreadsheet for work, but having a very tough time due to my lack of experience in Excel.

We have round horizontal chemical tanks, and take a reading in centimetres monthly. From that reading we have a chart from the manufacturer that tells us how many litres remain in the tank. I've copied the cm to litre data from the manufacturer into two columns already on one sheet. On the first sheet I want to make it so the guys enter the amount of centimeters and it automatically enters in the corresponding litres.

I've attached a screenshot of my columns. You'd think it would be easy enough for everybody to just refer to the table supplied by the manufacturer, but it keeps getting screwed up. Any help would be greatly appreciated.

[twiggywales]

try

=index($B$1:$B$1000,match(X1,$A$1:$A$1000,0),)

where is x1 is whatever cell you put the size in and the ranges can be altered to suit (a1:a11500 etc)

[ProductionOperator]

That worked perfect, thanks!

[twiggywales]

remember to mark solved