Hi
New to the forum. Have used excel for a while and reasonably OK with it but am struggling to understand the best lookup formula/data validation process to achieve the following.
One worksheet, 2 tabs.
Want to be able to select a name from a drop down in say A1 from tab 1, go to A2 (tab1) and see a drop down list of names which is stored against the name selected on sheet2 (tab 2)
Can anyone help with the correct formula to use
I have attached a small spreadsheet that explains it better.
Bookmarks