Find first blank cell and return a different cell value

[paulaqq]

We have a task in my job that takes roughly 45 steps to fully complete. We have a separate worksheet in a single workbook for each task, and the worksheet has a checklist of the steps that have been completed. an example, imagining columns A, B, and C.

A B C
1. Step 1 X
2. Step 2 X
3. Step 3

In this example, steps 1 and 2 have an X to mark completion, and 3 is not complete.

The first sheet in the workbook is a summary page for management to review overall progress at a summary level. I am looking for an equation that I can put on the summary sheet to indicate that Step 3 is the open action. I am hoping to find logic that will find the first blank cell at C3, and return the value of A3 on the summary page.

 

[nise23]

If you want to look up the first empty cell in column C of Sheet2 and return the value of the corresponding cell in column A, put this formula on your summary sheet and confirm with Control + Shift + Enter because it is an array formula.
Change the sheet names from Sheet2 to the names of your actual worksheets

=(INDEX(Sheet2!A:C,MATCH(TRUE,Sheet2!C:C=0,0),1)) Control + Shift + Enter

I would appreciate your feedback on my solution!

nise23

 

[paulaqq]

If you want to look up the first empty cell in column C of Sheet2 and return the value of the corresponding cell in column A, put this formula on your summary sheet and confirm with Control + Shift + Enter because it is an array formula.
Change the sheet names from Sheet2 to the names of your actual worksheets

=(INDEX(Sheet2!A:C,MATCH(TRUE,Sheet2!C:C=0,0),1)) Control + Shift + Enter

I would appreciate your feedback on my solution!

nise23

nise23: It's PERFECT! Thank you so much!