How to avoid 40 nested IF functions

[Jeremy1565]

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

[#2 · Accepted solution]

@Jeremy1565 

Use XLOOKUP() or VLOOKUP().

[#3]

Thanks for that! I feel kind of dumb now for not thinking of that. Worked perfectly