I have a spreadsheet with 2 different drop-down lists.

dropdown#1 has 4 choices
dropdown #2 has 8 choices

Depending on the combination of the choice, there are recommendations that I
need to give to the client. The recommendations are already typed in other
rows of the spreadsheet.

Is there a way to incorporate a formula into a blank cell that will pick the
appropriate recommendation based on the choices from the drop down list? I
was thinking an IF function but I know you can only have 7 IF functions
nested in one. I am not very experienced with IF functions either.