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 Column A as a source is in column C on the table's sheet, and the corresponding number needs to go in column G based on which item is selected.

I tried using nested IF functions, but I couldn't figure out how to do it without typing every single If function out for each cell