Hi all, Im generally good at working these things out but im stumped on this one.
I have a data list in cell A1 on sheet one, returning a list of employee names
On sheet 2 all the names are lined out horizontally with 3 rows of info under each name
So i would like to create a second drop down list on sheet 1 cell A2 that will look at the value in A1 (employee name) and look for that value in sheet 2, and return a drop down list with the 3 pieces of information located under that name in sheet 2.
I've been trying a few things such as lookup and if functions and seem to have completely confused myself.
any more info or if you need an example let me know
Any help be great
Regards,
Simon
Bookmarks