Collect information from 2 different cells in List Validation

Hi,

I have been slowly trying to develop a spreadsheet that will allow me to quickly create a document/ spreadsheet from previously stored information on an excel sheet.

What i can not seem to work out is the formula that will allow me to select an item from a list, which will then autofill the corresponding information related to that cell.

This is all related to some safety documentation I have to complete on a near daily basis. Over the years I have developed a large number of 'Hazards' and the corresponding "controls". I would usually just cut and paste what I needed, but with the more experience i am getting with Excel, I’m sure there is a formula out there that will make this more efficient.

Now what i would like to do, is on a modified work sheet, create a drop down list of "hazards" and when the particular hazard is selected from the list the adjacent cell will auto fill with the corresponding 'control'

I have attached the worksheet i have been working on.

Any help would be greatly appreciated.

Many thanks

Thanks Pike, It works a treat

Hi,

First post so please bear with me! Having a similar issue to the above post where I am trying to autofill a cell relating back to a list on a different worksheet. I have set up two lists and what to select a job from a dropdown list and then when the job is selected I want the job title to 'autofill' from the correct cell.

I have attached a copy of the file for information - please help! I have tried the solution shown on this forum but no luck and starting to tear hair out!

Thanks

Andrew Martin

Got this one sorted using the formula above - had incorrectly entered it the first time but success this time - great formula!!