Guys,

I'm pretty new to excel, and am trying to accomplish something that should be pretty easy. Basically, 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 end result of this is that the proper column header is displayed for a given row input and table value.

I couldn't figure it out with VLOOKUP, INDEX, OFFSET, MATCH, etc. but I know there are smarter folks out there. Any help would be appreciated, thanks!