If functions

[Guest]

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.

 

[Guest]

That is correct there would only be one recommendation for each como of
choices. I think I see what you are suggesting now....I hope. This would
work.
How would this formula work in E1:
in E1: = VLOOKUP($A$1&$B$1,$C;$D,2,0)

Would I need to change the format or just leave it like this?

Thanks

 

[Guest]

If the data is in the columns I proposed, then there is no need to change the
formula.

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

This matches the A & B choices against the C ("key") data and returns the
corresponding recommendation from volumn D.

 

[Guest]

Thank you, I tested the formula and it works great!