I have a spreadsheet with two tabs, once called data and one called breakdown. Please see attached spreadsheet. I need to have a function to bring back the relevant information to each cell from the data tab to the breakdown section of the spreadsheet. Please can someone help me?



i.e., on breakdown tab i need to completed cell B2, matching project site governance workflow id on both tabs, and returning the the debtor "comments" field - Cardiac Imaging Research South Australia Limited.

Hope this makes sense, and my apologies if it doesn't. This is my first time of posting.

Attached Files

invoices.xlsx (92.0 KB, 14 views)