Drop-down list of three tables

[mahmoud-lee]

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

[alansidman]

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.

[mahmoud-lee]

Explanation inside ShEEt

[alansidman]

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.

[mahmoud-lee]

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

[Admin]

Hi

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

Arrange your data in that manner.

[Ingolf]

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?

[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

[mahmoud-lee]

UP

[Ingolf]

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.