bill_s1416
Board Regular
- Joined
- Feb 12, 2003
- Messages
- 103
Sheet A ('Customers Alignment'):
--------------------------------------
column A- name of sales representative
column B - customer ID
(Not sorted in any particular order. So, a sales rep could be listed in row 5, 27, etc)
Sheet B ('Sales Rep Lists'):
------------------------------
cell 'A1' drop-down selection of sales rep name.
I need below that to list the customers of the sales rep selected in cell A1 in a continuous list, even though the data is randomly sorted on sheet A. Can this be done with a single formula (maybe with an Vlookup and/or an Offset?)
--------------------------------------
column A- name of sales representative
column B - customer ID
(Not sorted in any particular order. So, a sales rep could be listed in row 5, 27, etc)
Sheet B ('Sales Rep Lists'):
------------------------------
cell 'A1' drop-down selection of sales rep name.
I need below that to list the customers of the sales rep selected in cell A1 in a continuous list, even though the data is randomly sorted on sheet A. Can this be done with a single formula (maybe with an Vlookup and/or an Offset?)