Find next available row

[wladoD]

Hi Guys,

How could I find next available row in table?
I have bunch of matches if result is entered it will change status "played" in "T" and add date in "A".
Is there a way to use vlookup or index function here?

I have attached the data workbook.

Big Thanks

[benishiryo]

hi there. so is row 18 the results you are hoping to get? if so, try this array formula in cell B18:
=IFERROR(INDEX(B$2:B$11,SMALL(IF($T$2:$T$11="Waiting",ROW(B$2:B$11)),ROWS(B$18:B18))-ROW($B$2)+1),"")
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.

copy to other cells you want to paste to

[samba_ravi]

b18=INDEX(B$2:B$11,MATCH("",$A$2:$A$11,0))
Try this and copy towards right

[wladoD]

b18=INDEX(B$2:B$11,MATCH("",$A$2:$A$11,0))
Try this and copy towards right

Fantastic!!!

Big Thanks

[AliGW]

In B18:

=MIN(IF(A1:A11="",B1:B11))

... confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.

Then use INDEX MATCH or VLOOKUP to populate the other cells in row 18.