Hello!
I am really stuck on a formula and am trying to create a formula (in my Leads tab, column L) that looks at another tab (Territory tab) and returns data that matches certain criteria (in my Leads tab, column L) and also I need the formula to be able to cycle thru data based on territory/location (columns I thru R).
Basically, I am trying to create a formula (for my Leads tab, column L) that will provide me with the name of the individual listed in a certain location based on county &/or zip code information (Territory tab). In some locations, there are multiple people (columns I thru R in the Territory tab) and I will also need this information to cycle to another individual, if applicable. For example, if I receive 2 leads, I need leads distributed evenly amongst those in the territory/location. After that, I would need to see if I can also set the formula up so that the next person in line will receive leads. For example, if someone received leads today, then tomorrow everyone else in line would receive leads, depending on the quantity received.
This is very difficult to explain, but I have attached the workbook for you to see.
Any help you can offer would definitely be appreciated.
Thank you,
Tina
Bookmarks