Excel - drop down between 2 sheets

Occasional Visitor


I am seeking help with a formula, that will allow the following


Sheet 1 - will contain raw data with individual referenced towns with information

Sheet 2 - will be a presentable view of the information, based on a drop down using the individual references, in the hope that it pulls through all the relevant along the same row from Sheet 1.


I hope this make sense, and someone is able to offer some help.




0 Replies