Hi,
I have tried solving this myself for a couple days now, tried tables, pivot tables, range names, unique lists... just can't work it out.
In the attached sample, I would like a unique drop down list in 'Employees!C2' based in the data 'Directory!A:A.
I did achieve this by adding column 'Directory!D:D' with formula copied down:
{=IFERROR(INDEX('Sample.xlsm'!Area, MATCH(0,COUNTIF($A$1:D1, 'Sample.xlsm'!Area), 0)),"")}
What i required next and where the problem lies is in 'Employees!F2', I need a drop down list from all the store codes in 'Directory!B:B' that correspond to the number selected in 'Employees!C2' that matches 'Directory!A:A'.
A lot of data has been removed for security reasons but this will then later be used to reference the store name in 'Directory!C:C' that matches the store code selected in 'Employees!F2'
I trust all that makes sense lol.
Tez
Bookmarks