If functions

F

Frank

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.
 
F

Frank

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
 
T

Toppers

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top