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