Drop down menu from a list that auto fills another cell

[melliard5779259]

I want to select Work Type and it will then look at the list data and auto fill the highlight cells. I have attached a test page as it makes more sense.

[mikeTRON]

TEST1.xlsm

If you maintained the same column headings you could use index+match with ONE formula, but instead yours are different so you can use vlookup instead.

[melliard5779259]

That looks good, I could change the headings if that would be cleaner?

[mikeTRON]

I always try to maintain consistency for the sake of simplicity but this is so simple(or small and easy to audit) it doesnt matter as much.

Fortunately, (or unfortunately) I have been playing with millions of rows of data so every little thing I can do to simplify the matter will help. haha

[Kazi Sazzad]

Thanks, I am looking for a solution where I can enter data in a cell from a drop down list and once i enter a key word or test in the cell, the desired outcome shall pop up automatically. I got the solution from this thread.

Let me know how to upload the file here, thus any one can get it for useful hints.

[mikeTRON]

Are you asking for help or saying this thread helped or both?

If you are asking for help then you should start a thread of your own per the forum rules.

To attach, just click on advanced reply and its beneath the text box.