Hi There!
Everyone in this forum is so fantastic and I'm hoping someone can help again.
I have a spreadsheet that I'm trying to use a billing tab to populate a summary tab. On the attached spreadsheet - I want to populate the Schedule Summary tab, with the sales person's name on the appropriate date they've signed up for based on the May Tab. I've also added a desired result tab as an example of what I wanted it to look like.
I've been able to get it to work for one line by using this formula - but when I copy it down, it doesn't work properly for the next results - it gives me blank cells, instead of finding the next hit that meets the requirements.
I'm guessing I need to use an index/match formula, but haven't been able to get it to work. I've also tried this formula, but it did not work, it gave me a result of "0".
Also to note - the attachment is in Excel, but I need it to work in google sheets.
Help Please!
Thank you!!!
Bookmarks