Is it possible in Excel to use data like this
obj circuit floor
1234 23 First


1235 24 First
1236 26 First
1236 26 First

then add columns like this with Pivot table or another way?
obj circuit floor type make
1234 23 First flood lucas
1235 24 First spot lucas
1236 26 First D/L phillips
1236 26 First D/L phillips

using another workbook with data like this
obj type make
1234 flood lucas
1235 spot lucas
1236 D/L phillips
1236 D/L phillips

Sorry for the strange way of showing the problem. So based on the common obj link the extra data would be added to the first wookbook.

Problem is the first set of data would not stay in sync with the second workbook.
The sequence in the first workbook may be
1234
1234
1234
1236
and would only have a subset of obj codes. The second workbook would contain all the obj codes.