CODEWITHSUNDEEP
arraysgoogle-sheetsgoogle-sheets-formulaarray-formulasgs-vlookup
Jonas Blazinskas
Jonas Blazinskas

Reputation: 79

Array formula index match?

Is there a way to make this formula into an actual array one? Where it would fill in everything A2:A itself?

=ARRAYFORMULA(INDEX('Handle Finish'!$B$2:$B$24,MATCH(TRUE,ISNUMBER(SEARCH('Handle Finish'!$A$2:$A$24,A2:A)),0)))

enter image description here https://docs.google.com/spreadsheets/d/1S3svXvdC45VqCFu1710_VrEuo4kWo0kKe6CuxbpnqnI/edit?usp=sharing

Upvotes: 1

Views: 94

Answers (1)

player0
player0

Reputation: 1

use:

=ARRAYFORMULA(IFNA(VLOOKUP(IFNA(REGEXEXTRACT(LOWER(A2:A), 
 TEXTJOIN("|", 1, 'Handle Finish'!A2:A))), 'Handle Finish'!A2:B, 2, 0)))

p

Upvotes: 2

Related Questions