CODEWITHSUNDEEP
arraysgoogle-sheetsmatchrowspreadsheet
wrought_gamma
wrought_gamma

Reputation: 13

How do I pass the value of Row() into the ArrayFormula function in Google Sheets?

I want to always have the current Row number in this formula:

=ArrayFormula(IFNA(match(2,1/(A5:5<>""))))

The ROW() function works for getting the current row number. How can I implement it into this ArrayFormula() like this? I imagine it working like this but it doesn't:

=ArrayFormula(IFNA(match(2,1/(A&ROW():ROW()<>""))))

How do I pass the value of Row() into the ArrayFormula() function?

Upvotes: 1

Views: 703

Answers (1)

player0
player0

Reputation: 1

this is not an arrayformula issue...

constructed range always needs to be INDIRECTed:

=ARRAYFORMULA(IFNA(MATCH(2, 1/(INDIRECT("A"&ROW()&":"&ROW())<>""))))

Upvotes: 1

Related Questions