SOLVED

How to avoid 40 nested IF functions

Occasional Contributor

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.

Jeremy1565_0-1664307637458.png

 

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.

Jeremy1565_1-1664307737897.png

 

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 Replies
best response confirmed by Jeremy1565 (Occasional Contributor)
Solution

@Jeremy1565 

Use XLOOKUP() or VLOOKUP().

 

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