Help on multiple formulas in one cell

[jkr4250]

Alrighty so I wasn't too sure how to word my title.

So i have a cell that i would like a dropdown menu in and i can pick any of the following numbers by the way these numbers represent pipe size 1,1.5,2,2.5,3,3.5,4,6,8,10,12,14,16 when i pick a number i would actually like a number that corresponds to each of them like for instance if you pick #1 the corresponding value is 0.957 ( which represents the inner diameter of pipe) So lets say I have cell A1 that contains my drop down menu i would like cell B1 to show the inner diameter value that corresponds to its number my numbers are this

1 1.049
1.5 1.610
2 2.067
2.5 2.469
3 3.068
3.5 3.550 I hope this makes sense sorry if i am not clear i can post an actual excel file if i need to let me know well
4 4.026 thank you so much for taking the time to read this and hopefully saving me forty hours of frustration
5 5.047
6 6.065
8 7.981
10 10.020
12 11.938
14 13.125
16 15.000

[NBVC]

Go to A1 and then to Data|Validation, select List and enter the input values, separated by a comma... or if you have them listed somewhere on the sheet, select the range....

Then use formula:

=Lookup(A1,{1,1.5,2,2.5,3,3.5,4,5,6,7,8,10,12,14,16},{1.049,1.610,2.067,3.068,3.550,4.026,5.047,6.065,7.981,10.020,11.938,13.125,15.000})

If you have the list in the sheet somewhere, say in X1:Y10, then =LOOKUP(A1,X1:Y10)