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