How to avoid 40 nested IF functions

I have 2 corresponding columns of data. Column A is the data source for a column in a table on a different sheet, and column B is the corresponding number.   The dropdown list that uses Colum...