Copy cell based on lookup and match of another.

Occasional Visitor

I have a document with 3 fee schedules in different tabs. All fees schedules have some similar codes with related fees but some fee schedules don't have a specific code. I would like to combine it into 1 Tab, either a new tab with all the fees or add the other fees to an existing tab so I can compare fees. I attached an example of what I have. 

1 Reply

@Dr_Wes If you can create one (structured) table with an extra column indicating the Fee Category (1,2 or 3), a Pivot Table could easily create the combined report you desire. You'll find a working example in the attached workbook.

Screenshot 2021-05-20 at 06.16.56.png