VLookup Question

Is it possible to VLookup more than one column at a time? For example A - Names - B Age - C DOB so would I be able to VLookup age and Dob into sheet 2 from sheet 1 if so how would I do it? Thanks.

  VoG II 08:22 22 Jul 09


A1: Name to lookup

B1: =VLOOKUP($A1,Sheet1!$A$1:$C$10,COLUMN(),FALSE)

Drag to the right, C1 becomes


Thanks VoG but I am finding this a little difficult to understand. Could you talk me through step by step. I have no problem when looking up 1 column

  VoG II 09:18 22 Jul 09

With Sheet2:

In A1 enter the name that you want to lookup

In B1 enter the formula


Click in B1, hover the cursor over the bottom right of the cell until the cursor turns into a + then hold down the left mouse button and drag right across as many columns as you need.

This thread is now locked and can not be replied to.

Surface Pro (2017) vs Surface Pro 4

20 groundbreaking 3D animation techniques

How to mine Bitcoin on Mac