I have been working on automating a reporting sheet I have and discovered the very handy use of arrayformula in Sheets that autofills the column with your formula based on data in another column.
Anyway, whenever I try this approach with a lookup formula it only uses the second row of the column it looks up against and then fills up all rows with the result of the lookup against that first row.
I tried using both INDEX MATCH and VLOOKUP.
With INDEX MATCH the formula was actually looking up against the heading so was returning no results.
With VLOOKUP I get the aforementioned issue where it only looks up against second row.
The VLOOKUP formula I curently have is:
=arrayformula( if(B:B<>"",IF( row(B:B)=1, "Country",vlookup(D:D,FBlookup!$A$3:$B$20,2))))
Am I doing anything wrong or are lookups, especially against a table in another sheet just not working as an arrayformula autofilling a column?