I doubt that that my question title really describes the situation, but please take a look at the attached workbook. Basically I have a table with 4 columns, each containing 2 to 6 rows of data under the header.
The table data comprises 16 items that will be distributed over a 2500 row column elsewhere in the workbook. I needa function (ideally) or a macro such that when one of the data values in the table appears in the long target column, it will return the header value of whatever column it resides in the table.
I'm sure my explanation here isn't very clear either, but I hope the workbook will make things clear!