Good Morning,
I am attempting to use the Index/Match to match each instance of "R&D" that is mentioned in Column B (B61:B100) (R&D Summary Tab), which have been pulled from the 'January Tab', and pull its subsequent "Description", "Date" and "$$" into the top 1/2 of the the same form --the "January Section" of the R&D Summary tab. The problem that I am running into, as you might imagine, is that the Index/Match formula is only matching the 1st instance of the "R&D" and not moving on the subsequent matches in the search array.
I know that I most likely need to use some type of ROW function to help it determine when to move on, however, I am relatively new with excel, so I am struggling with the right combination. I know the solution is not difficult, but any help would be greatly appreciated.
I have attached a sample spreadsheet for any possible assistance.
Thank you in advance.
Bookmarks