Hey everyone!
Having a major brain fart.
First off, here is the link to the workbook I am working with: This is a Google Sheet (I know, I want it in Excel but several people that will need access to this do not have Excel) https://docs.google.com/spreadsheets...it?usp=sharing
What I am trying to accomplish is for the data to pull from the 'Business by Rep' sheet to the corresponding Rep sheet. For example, Test 1 is Hart's business so it should only display on his tab.
I hope this makes sense, I think a nested If should work, but not really getting it to display multiple results like I want.
I do have a formula that works and shows the first result, but I can't get it to show multiple results properly
Thanks in advance everyone!
Bookmarks