What is the best way to do this? I have 6 cells that need to be populated based on the results of 4 different cells.

C8 is the beacon score

C9 is the year model (could be one of 25 possibilities)

C10 is the model code (could be one of 115 possibilities)

O5 is the lender (could be one of 9 possibilities)

Based on the results of these 3 cells, the values of cells O6, O7, O8, O9, O10 and O11 will be determined. And all four of the 1st 4 cells I mentioned above will be required to determine each of the O6:O11 cells.

For just one cell a simple IF formula would work but there are so many possible values that could result that I don't know how to approach this project. Macros? Formulas? I'm still a novice at excel so this is tough on me. Ideas?

## Bookmarks