Flashart80
New Member
- Joined
- Apr 9, 2011
- Messages
- 1
Hi All
I have an issue which I would appreciate help with.
I have a sheet with lots of data in it. This sheet has named ranges within it. In another sheet I have a combo box and a list of clients. What I want to achieve is the user selects a client from the dropdown box, and it returns summed totals.
So for example, user selects a client, and then a cell is populated with the summed total of impressions from the named range, data_impressions.
I think i need some sort of vlookup/sum formula coupled with index (i presume). Can anyone help me out here?
Much appreciated
Peter
I have an issue which I would appreciate help with.
I have a sheet with lots of data in it. This sheet has named ranges within it. In another sheet I have a combo box and a list of clients. What I want to achieve is the user selects a client from the dropdown box, and it returns summed totals.
So for example, user selects a client, and then a cell is populated with the summed total of impressions from the named range, data_impressions.
I think i need some sort of vlookup/sum formula coupled with index (i presume). Can anyone help me out here?
Much appreciated
Peter
