Excel Vlookup query

  untouchable1974 12:21 17 Nov 10
Locked

Hello

I'm trying to create a vlookup up formula which when working corrcetly should pull data from 3 colums.
i.e column A1- Wayne Rooney
column B1, Manchester United
column C1, England
column D1- unique id (e.g 12345)

What i am trying to do is in another column say 'E' or 'F',type in 12345 and in the next three columns i'd get his name, team and then country.

I can do the vlookup to pull the value from one column but not all three.

Any ideas?

  VoG II 12:33 17 Nov 10

With ID to lookup in E1

Name =INDEX(A:A,MATCH(E1,D:D,0))

Club =INDEX(B:B,MATCH(E1,D:D,0))

Country =INDEX(C:C,MATCH(E1,D:D,0))

  untouchable1974 13:36 17 Nov 10

VoG

i'm getting an n/a error

unique num Name Club Country
123 Wayne Rooney Man Utd England
122 Carlos Tevez Man CityArgentina

  untouchable1974 13:36 17 Nov 10

VoG

i'm getting an n/a error

unique num Name Club Country
123 Wayne Rooney Man Utd England
122 Carlos Tevez Man CityArgentina

  untouchable1974 13:42 17 Nov 10

oops hit reply too early

#N/A

unique num Name Club Country
123 Wayne Rooney Man Utd England
122 Carlos Tevez Man City Argentina

These are the values across the 4 colums A to D.

There may be upto 300 records set up this way and the only way i will refernce them is via a unique Id which i enter in cell E. Although not all 300 records are referenced all the time, i may input up to twenty different values in cell E. will this produce the name, club, country in cells F to H for each row(providing i enter the formuala as you have written it)?

  VoG II 13:43 17 Nov 10

That's because you are using the columns in a different order than you originally posted.

Name =VLOOKUP(E1,A:D,2,FALSE)

Club =VLOOKUP(E1,A:D,3,FALSE)

Country = VLOOKUP(EQ,A:D,4,FALSE)

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

Huawei P10 review

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

How Nearly Normal created super-fun papercraft for Google

47 iPhone camera tips to help you take better photos