Table Header in Index to link to cell

Hi, I have a formal that pulls the company names from a table, where a specified field equals yes.

Please Login or Register  to view this content.

That is then pulled down the page and seems to work quite happily. However I would need to have multiple versions of this formula to display each category. I need to be able to select the Column header in Table2 dynamically. For example in A1 would be a drop down menu containing 5 categories, the selection from A1 would then be within 'Table2[A1]'. I've tried to match the contents, perform a lookup, but really all i want to do is literally put the contents of A1 within the #Header choice. i.e

Please Login or Register  to view this content.

Thanks, i think that has attached ok!

Tony I managed to figure it out! Thanks very much though!

Please Login or Register  to view this content.

Thats the part that I had to put it:

Please Login or Register  to view this content.