IF Statements

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am really a rookie when it comes to excel. Can you have more than one IF
statement in a cell? For example, I have a drop down chart with a list of 7
people, I want one cell to list different information depending on which
person is chosen from the drop-down menu. Please Help!!
 
You can have up to 7 nested functions (which can all be IF functions) in a
cell. However, a better approach might be a lookup table. See Help for
VLOOKUP.

Jerry
 
You must log in or register to reply here.

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

Similar Threads

Changing a cell value from another cell. 2
making a drop-down list with two separate columns 2
Multiple IF statement 5
Drop Down List 3
look up formula 3
IF statement circumvent with Criteria or VBA,vlookup, index 9
Combining two non-contiguous lists into one for data validation, with one range being dynamic 0
Filtered drop down list 2

Back
Top