I need to do something like a vlookup but to populate multiple columns. Heres my sheet:
https://docs.google.com/spreadsheets/d/1QsarnElwfKplVOsHo_i9mebL36dqsRxbQJUsQ1MeNdk/edit?usp=sharing
use this formula in B1 cell:
=ARRAYFORMULA(IFERROR(VLOOKUP(A1:A, {Sheet2!D1:D, Sheet2!A1:F}, {2,3,4,6,7}, 0)))