Hello everyone,
Hoping to get some help with the attached file. I'm looking to lookup specific data from one table and somehow paste it into another table. I'm thinking you might have to transpose but perhaps it can be achieved using index match formula.
I've colored the associated cells to help guide what data I need where. Please note this is a small subset of data and the tables are much larger than the example.
Thank you in advance for your help
Bookmarks