google sheets
I'm trying to use ArrayFormula to reference a list of IDs from 1 sheet, then match them to another and get information from their corresponding row.
At the moment, this is returning 1 result, but not continuing down the list of IDs, because that's not how Match works in this case
=ArrayFormula(Index(SIHOT!F2:Q, Match(A2:A,SIHOT!F2:F, 0)+1, 1))
You added single quotes to the sheet references:
=ListBy('sheet1'!A1:A10, 'sheet1'!A1:A10, "needle")
If you leave those:
=ListBy(Sheet1!A1:A10, Sheet1!A1:A10, "needle")
then your script works as planned.
Sheet2:
Sheet1:
It looks like you're trying to create a heading in row 1, then below it, run a vlookup if there is a value in column B - This works
={"Country";arrayformula(if(len(B2:B)>0,vlookup(D2:D,FBlookup!$A$3:$B$20,2,false),))}
Best Answer
Instead of combining
indexandmatch, usevlookup, which is designed to do both things at once: find a match and return an entry from another column in the matching row. Example:returns an array of entries of column G (second in the range F2:Q) where the column F matches the content of column A.