search table display column header for n occurences

**martin_mcnamara** · 01-27-2011, 05:44 PM

Hello

I have a table that has row headers to the left, column headers on top, and all the row data increases left to right.

I'm trying to write a function that will automatically find the correct row header (that matches a previously calculated cell), search across the row to find a fixed value "x", then go to the top of the column and display the column header.

The result of this is that the proper column header is displayed for a given row input and table value.

This has been dealt with in a previous post (http://www.excelforum.com/excel-gene...ml#post2143062) but I would like to return results for multiple occurences in a given row - the solution here only returns the first occurence in a row

Any help greatly appreciated

**MarvinP** · 01-27-2011, 06:06 PM

Hi martin,

It sounds like you want to filter your data so only rows show that have this searched-for value show.

I'd be looking for an Advanced Filter function.

**martin_mcnamara** · 01-27-2011, 07:11 PM

The attached sheet shows a previously posted solution for one occurence
Searching row defined in cell a1 for value defined in cell a2 puts solution in cell j2

I would like to be able to find other solutions returning them in adjacent cells - so in this example searching for value 11 in row f - return letters c in k2 and e in k3 and if there were a 3rd match then that column header in k4 and so on for n occurences

again, any help appreciated

**MarvinP** · 01-27-2011, 10:03 PM

Hi Martin,

After some advanced puzzle solving techniques here is your answer. You are on your own if you want 3 or 4 letters.

Find the attached with these two new formulas.

Please Login or Register  to view this content.

Change the A1 and/or B1 letter and number to show the results.
I really believe a conditional formatting would suffice.
I've put that on the attached also.