Hi Community
I would like a formulae to pull data from different tabs using two columns for look up. Not sure if I have to firstly use Concatenate followed by Index & Match.
I have attached a workbook with explanation in the analysis tab.
Would be grateful for any assistance.
Thanks
Bookmarks