Returning value in top row of table

Hi,

I'm new to this forum and excel in general. I'm looking for help with the following: in the table below, how do I locate certain value and return corresponding value from top row of the same table?

I.e. if I'm looking for 2000, but don't know what row/column is it, I want formula to return February.

table.png

Hi and welcome
Try https://www.quora.com/What-is-the-fo...nd-table-value

What do you expect to be your result when looking for '5'?

Thanks for reply Pepe Le Mokko however this formula won't work as there are no row headings. I know the value I'm looking for and I need to locate it in a table with only column headings and return the value in the top row for that column.

Originally Posted by kersplash

What do you expect to be your result when looking for '5'?

I'm looking for max value which is very likely to be unique.

The max value in your table is 4000, so it's a bit confusing.

It would help if you attached a sample Excel workbook.

To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.

Do not try to use the Paperclip icon, as this does not work on this forum.

Hope this helps.

Pete

Originally Posted by Pete_UK

The max value in your table is 4000, so it's a bit confusing.

It would help if you attached a sample Excel workbook.

To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.

Do not try to use the Paperclip icon, as this does not work on this forum.

Hope this helps.

Pete

Thanks Pete, I've now attached a sample table. What I'm looking for is to return a column heading for max value in the table - in this case february as the max value is 5678.

Something like =INDEX(A1:D1,SUMPRODUCT(COLUMN(A2:D5)*(A2:D5=MAX(A2:D5)))-COLUMN(A2:D5)+1)

Errr, it's Pepe , not Pete ...