Tina Walt
asked on
Excel Match/Index formula?
Hi, me again. I was asking something very similar to this a couple of days ago. Here goes again! In the spreadsheet attached, I have project names and basically when they started (indicated by a 1, the zero indicates when the project ended). I dealt with the project end date by a wonderful solution posted on here a couple of days ago using Match and Index. Here is what I need now: I need to know when a number 1 appeared in the cell, and then I want the date above in row B to appear in the cell. For example: the project in cell F19 did not become active until Feb 4, 2014 (as indicated by the 1 in the cell). Can you please help me write a formula that will automatically tell me the date. The last formula I used (Thank you for the solution!!!!!!) was: =IFERROR(INDEX(D$1:AS$1, MATCH(0, D3:AS3, 0)), MAX(D$1:AS$1)). This error checks is the cell has a #N/A in it. Thank you.
SnapShotExcel.png
SnapShotExcel.png
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER