Formula for Calculating weights

[Andy66]

Hi

I'm trying to find a way to calculate the weight of a container based on whether I add 1,2,3,4 or 5 in a cell that references figures from another sheet.
For Example

In sheet "Weights" I have 5 cells with 40, 200, 480, 760, 1040 these are weights from an irregular shaped container based on 20% intervals which are marked on the side of the container.
In the main sheet I want to add either 1-5 to show how many marks of 20% the measurement is of the container from the outside.
So if it measures 40% that would be 2, therefore when I enter 2 in cell P5 I want O5 to insert 200 from the weights worksheet. Or if its 4 then it would insert 760 to O5

I think it's an IF statement but I cannot get it to work

Thank you

Andy

 

[steve the fish]

You could use choose function for that:

=CHOOSE(P5,40,200,480,760,1040)

 

[FormR]

In sheet "Weights" I have 5 cells

Hi, if those five cells are A1:A5 for example, you could try:

=INDEX(Weights!A1:A5,P5)

 

[Andy66]

Hi, if those five cells are A1:A5 for example, you could try:

=INDEX(Weights!A1:A5,P5)

That works nicely thank you, however in O5 and O6 it has placed 500 and 660 in it
The weights in the "Weights" worksheet are E2:E5 in this case 40, 180, 340, 500, 660 so when I add the formula to Col O in the other worksheet I get the 500 and 660 added as it references the figures in E5 and E6 where I would ideally like nothing in Col O until I add 1-5 in Col P

 

[FormR]

I would ideally like nothing in Col O until I add 1-5 in Col P

HI, not sure I fully understood everything in that last post but I think you want something like:

=IF(P5="","",INDEX(Weights!A1:A5,P5))

Adjust the A1:A5 range as appropriate.