Right most cell with a value and return column header

[cooldude36]

I am TIRED! I have tried and tried for the past one hour and can't do this myself and need your expert help.

My file is set up like this:
Deal Jan Feb Mar....... Dec
A 0 11 0
B 0 0 23
C 13 0 12
and so on

Meaning deal A got cash of 11 in Feb and B of 23 in March

For a certain month (which could change), I want to specify the most recent month of a payment and return the month

So in April, row A returns 2, Row B March and Row C March

[benishiryo]

hi there, welcome to the forum. assuming your data starts in A1 to D4, try this:
=LOOKUP(2,1/($B2:D2),COLUMN(B$1:D$1)-COLUMN($B$1)+1)

because you said in Apr, you want to return the result, i'm assuming it's column E then. and you first mentioned you want to return 2, but later the name of the month, so i'm a little confused. for month:
=LOOKUP(2,1/($B2:D2),B$1:D$1)

as you can see with so many assumptions i made, uploading a sample Excel file will enable us to help you better. to upload, press "Go Advanced" beside the "Post Quick Reply" button & click on the paperclip icon
ideally, it should contain your desired results

[cooldude36]

sorry - here is the attachment