[Macro Help] Search Column in a Table and Return Heading

Lets see if I can put this into words.

I am trying to find matches of a specific cell in various columns. Example: Cell A1 holds the word "Abc123" I'd want to search columns B-H, for an exact or similar match and return the heading for that column.

So the results would show me the COLUMN Heading for anything that reads: abc123, ABC123, AbC123, aBC123.

Is this possible?

Thanks in Advance!

Hi

This assumes that there will only be one match (if any). If there is likely to be multiple matches, then how do you want to progress?

Please Login or Register  to view this content.

rylo

There will be one match in each column.

Header 1 -------Header 2----------Header 3
ABC123---------abc123-----------abd123
abd123---------hjk321------------hdn234
Abc123---------dsd123-----------sds332

If I searched for the value abc123 I want it to return Headers 1 and 2. It would not matter if the same value is in one column multiple times

Also, because there will be multiple lines returned, I would want it returned to a column in excel.

Hi

Exactly where do you want it returned?

Same sheet as the data? If so where?

rylo

Originally Posted by rylo

Hi

Exactly where do you want it returned?

Same sheet as the data? If so where?

rylo

Nowhere specific as long as it's in excel. If it can be put in the same sheet fine. I just need to get the overall headers that match the given value.

Can anyone help with this?

Hi

Put up an example file that shows your structure.

rylo