Excel - drop down between 2 sheets

Occasional Visitor

Hello,

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.

 

Thanks

 

0 Replies