Excel: Can anybody help me to take-off quantities of loose furniture in the best and fastest way?

Can anybody help me to take-off quantities of loose furniture in the best and fastest way?

Information as follow:

There are about 2000 different types of rooms and 300 sets of different furniture

Two different schedules are provided to me;

1- Furniture-Code for each room that represent to a set of furniture

2- Furniture-Code Explained, means which type furniture related to each code

for excel data use this link enter link description here

I want to prepare a schedule in excel where each room and its furniture listed and finally sum of each furniture C-1, C-2, C-3 …….. etc

Kind regards