Drop-down list of three tables

Explanation inside ShEEt

If you choose from the cell (JOP) function such as (Accountant) and choose from the cell SHIFT character (A) gives me in the drop-down menu (RESULT) column (SHIFT A) and
If you choose from the cell (JOP) function such as Accountant and choose from the cell SHIFT character (B) gives me in the drop-down menu (RESULT) column (SHIFT B)
Etc. .............

I see no explanation of what you are trying to do. My crystal ball broke this week and I failed mind-reading at University. Please explain what you want.

Explanation inside ShEEt

So you want to have cascading combo boxes?

Look here Create a Multilevel Cascading Drop Down Menu/List in Excel 2010 | MS Office Training Courses Sussex Hamphire Surrey Kent Berks Bucks

Google is your friend.

Method found in the link is not required
I want the way in the Sheet

Hi

Try the method described here http://www.excelfox.com/forum/f12/de...-formulas-111/

Arrange your data in that manner.

Quote:

---

Originally Posted by mahmoud-lee

Method found in the link is not required
I want the way in the Sheet

---

Both links shows you how to do what you need. Want someone to give you the solution or want to learn?

This message appears when I try to login

mahmoud-lee, you do not have permission to access this page. This could be due to one of several reasons:
I want a solution because I need it

UP

Quote:

---

Originally Posted by mahmoud-lee

This message appears when I try to login

mahmoud-lee, you do not have permission to access this page. This could be due to one of several reasons:
I want a solution because I need it

---

So, you're not interested in learning, you "want" solution to your problem.
If you're willing to pay for the solution you can hire someone to solve your problem.

Both links still available, without restrictions. No need to log.

This message appears when loading

I don't know what link you were clicking on to get the VB Bulletin, but if you click on this link below, you should get directly to the tutorial you need to complete your project. Learning is the important part of working with excel. If you don't want to learn, then you shouldn't be posting here and should hire a contractor to do your work. We are all volunteers here who do not get paid. We do this to help you learn not to do your work for you.

Create a Multilevel Cascading Drop Down Menu/List in Excel 2010 | MS Office Training Courses Sussex Hamphire Surrey Kent Berks Bucks

Thanks for your help