Formula to search for matching data in a seperate workbook.

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.

In very simple terms I have provided Spreadsheet A and Ab.

A is the master and Ab is the slave.

In A there are the numerical values 1-10 in Column A.

In Ab the numerical values, 1-10, are in column E and in column G are alphabetical values.

I need a formula in the Master Spreadsheet (A) that will look in Ab for a matching value to the numerical values and then in column B provide the alphabetical data that is in column G in spreadsheet Ab.

I hope this make sense.