VLookup Question

  [email protected]© 06:47 22 Jul 2009
Locked

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 2009

Sheet2:

A1: Name to lookup

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

Drag to the right, C1 becomes

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

  [email protected]© 09:14 22 Jul 2009

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 2009

With Sheet2:

In A1 enter the name that you want to lookup

In B1 enter the formula

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

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.

Elsewhere on IDG sites

WPA2 hack: How secure is your Wi-Fi?

Microsoft Surface Book 2 hands-on review – bigger and 5x faster

Best kids apps for iPhone & iPad

Que faire si son iPhone ou iPad est tombé dans de l'eau ?