Hi,

I have a database being extracted from a BIM (builiding information model) that creates a list of all the elements, items, materials, assemblies etc. that make up the building that has been modeled. We link this database back to the BIM model and then amend data in the Excel spreadsheet to send back to the BIM model. We have a problem where we are not able to undertake this from on spreadsheet and have another in use that is providing quantity information.

Both spreadsheets contain the individual code for each item.

What I want to do is in the master spreadsheet create a formula that will search the slave spreadsheet for any code values that match. Where a match is found it will link the data for the quantity in the slave spreadsheet back to a defined cell in the master spreadsheet.

I want to keep this spreadsheets linked.

Many thanks,

Adam.