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.

Nintendo Switch review: Hands-on with the intuitive modular console and its disappointing games…

1995-2015: How technology has changed the world in 20 years

The updated 'Corel Painter inside Photoshop' plugin ParticleShop offers new brushes

Best running headphones | Best sport & fitness headphones: 4 brilliant pairs of wireless…