refering data from another sheet

[mani_singh]

hi everyone, anyone know how i'm going to do this...


i want to be able to type a unique ref into a cell on one sheet (sheet1) and when i press enter after typing i need it to lookup data on a table in another sheet (sheet2) and copy the data from cols a, d, e & f.

finally paste this infor into the same row as originally typed into on sheet1



thanks everybody!

 

[Richard Schollar]

Hi

Look at the function VLOOKUP in the Excel help files.

 

[mani_singh]

thanks will do

 

[Aladin Akyurek]

hi everyone, anyone know how i'm going to do this...


i want to be able to type a unique ref into a cell on one sheet (sheet1) and when i press enter after typing i need it to lookup data on a table in another sheet (sheet2) and copy the data from cols a, d, e & f.

finally paste this infor into the same row as originally typed into on sheet1



thanks everybody!

Step 1:

MATCH(Ref,Range,MatchType)

Step 2:

INDEX(ReturnRange,Result Of Step 1)

 

[mani_singh]

thanks for the quick replies everyone - got it sorted now!

much appriciated