Find a specific column header, and list ALL values under that header

[k_mak]

Hello All,
How does one find a specific column header and then list ALL values under that header?

 

[k_mak]

I'm trying the add-in and not certain if it will display properly...but here goes.

The data is the same that you provided.

Here is the "Alias" List:

Excel 2013/2016
	A	B	C
1	CAT1	CAT2	CAT3
2	City	Postcode	District
3	County	Postal Code	Sector
4	Town	Zip Code
5	Village
6
7
LIST

Here is the template:

Excel 2013/2016
	A
1	City
2	Cambridgeshire
3	Norfolk
4	East Riding of Yorkshire
5	East Riding of Yorkshire
6	Cambridgeshire
7
8
9
TEMPLATE

 

[Fluff]

Unfortunately I don't understand what you are trying to do.
Are you saying that if any value from Cat1 is used, it will show all values in the City column, or anything from Cat2 would show the Postcode column?

 

[k_mak]

That's exactly correct!!! I have many data sources with different column header names and different column locations.
Therefore, the formula's lookup value cannot be a "fixed" location or column name, ie: $C$1 or County.
Any assistance is greatly appreciated!

 

[Fluff]

I don't see how a lookup table will help, if the column header & position vary.