Question : google sheets return multiple columns with vlookup
Answered by : charlesalexandre-roy
# Basic syntax:
=ARRAYFORMULA(VLOOKUP(search_key, search_range, {columns,#s,to,return}, is_search_range_sorted))
# Example usage:
=ARRAYFORMULA(VLOOKUP($A$14, $A$1:$G$9, {2,3,6,7}, FALSE))
# This formula returns entries from columns 2, 3, 6, and 7 when the
# entry in cell A14 is found in the range from A1 to G7. Source : https://www.benlcollins.com/formula-examples/vlookup-return-multiple-columns/ | Last Update : Tue, 22 Sep 20