Linking values into an adjacent cell to choices in drop down

Hello,

I have a list for a drop down. Based on the choices selected from that drop down a specific numeric value is attached to it.
So in my main sheet I have the drop down and then in the adjacent cell I would like the numeric value associated with it to match.
There are 20 choices in the drop down so I don't believe 20 IF THEN formulas are necessary! I hope.
Picture 1 is the data source and then picture 2 is the main sheet where in row 28 you have the drop down (mab select in this case) and then the blue cell would have the associated numeric value.
excel.jpg
excel 2.jpg

Thank you very very much in advance

You can probably use a VLOOKUP formula to do that, but it would help if you attached a sample Excel workbook so we can see how your data is laid out - just follow the directions given in the yellow banner at the top of the screen.

Hope this helps.

Pete

Process Calculations Copy.xlsx

Thank you. Yes that makes the most sense.
So to explain a bit.

On the tab 'mAb Capture' in cell A28 is my drop down list of choices.
In the blue cell C28 is the value that should be directly associated with that choice.

In the 'Source' sheet, column E has all of the choices for the drop down from the 'mAb Capture' sheet cell A28 and Column F is the value associated with the corresponding product in column E.
So you pick mAb Select SuRe in Cell A28 and Cell C28 will be 35, mAb Select LX will change C28 to 60, mAb Select Xtra = 40 and so on.

Thank you again for the help.

Process Calculations Copy.xlsx

That is all that it needed! Thank you very much. Too kind of you to help.