Hi Jaime,


Re 2, I can't see where or even on which worksheet you want to enter the search name or how you propose/want to relate Columns A & B in the 'Index' worksheet to their apparent equivalents, columns H:K in the 'search' worksheet.


As for the data, it seems you have at least four IDs that can be used by different parts of the organisation to identify the same items - the DRAW. TAG, Plant Nomenclature, O&M TAG and the FAMIS NUMBER. Some of these seems to be duplicated, but the dupicates don't necessarily refer to the same items (eg DRAW. TAG 'CHP-01' refers an item for which the O&M NAME gives two descriptions - CHILL WATER PUMP -1, BALDOR AC/TEFC MOTORS & SUCTION PUMP - the second having no O&M TAG and the last having a completely different O&M TAG than the first). That's certainly an inefficient arrangement, is liable to cause confusion at times and could ultimately end up being costly. And how one is supposed to create a definitve index with such inconsistencies in the data is beyond me.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]