**VLookup** is good ONLY when you have **rows** to get the values from. For **columns**, you can use HLookup. Yet, in your example, you have **rows** **and** **columns** at the same time you want to get the values from. For this to work, there is another way to do this by using index (reference, match (),match ()).

You can use the following syntax with the **VLOOKUP** function in Google Sheets to look up a value in a range and return the corresponding values from **multiple columns**: =ArrayFormula (**VLOOKUP** (A14, A2:D11, {2, 4}, FALSE)) This particular formula looks up the value in cell A14 in the range A2:D11 and returns the corresponding values in **columns** 2 and. Could you please elaborate a bit as question is not very clear? Better, if you illustrate with an example / data.

This new lookup **column** is illustrated in **column** B below: Now we have a single lookup **column** that can be used with a traditional lookup function such as **VLOOKUP**. The report can be populated by looking up the combined names within the new lookup range, as shown below: This same approach can be used when two, three, or more lookup **columns** need to.