Try this "model" :

Using Data Validation, A1=Dropdown #1 (values 1 to 4)
B1=Dropdown #2 (values A to H)

In columns C &D :

C1=1A, D1="choice 1"
C2=1B, d2 = "choice 2"
etc

in E1: = VLOOKUP($A$1&$B$1,$C;$D,2,0)

Or to allow for errors

=IF(ISNA(VLOOKUP($A$1&$B$1,$C;$D,2,0)),"No
match",VLOOKUP($A$1&$B$1,$C;$D,2,0))

HTH

"Frank" wrote:

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.