spreadsheet help please!!!

[aaaaaaaaaaaaaaa]

Hi there first post so hope it makes sense when i explain my problem. I have devised a workbook comprising of 2 sheets and it works ver simple. I have the idea of what i want it to do but dont know how to get it work whether i use formulae, vlookup or macro etc. I basically on sheet one have a column labelled ref number which counts 1 to 50,000. on the second sheet i have it laid out like a word document in a sense basically plain sheet with lines for text to go. i simply want a formulae or code etc so that when on sheet two the reference number is inputted it pulls the data from sheet one into the designated areas of sheet two. ie finds the row that matches the ref number and brings each field from that row and pastes them onto the corresponding lines. I have seen a sheet that this works on i just dont know how to do it i will post my spreadsheet to someone can have a look that would be great. Also if you need any help please comment as it may not sound as straight forward as i think it does. i also have a copy of the sheet that this feature works on if that any help.

Thanks in advance.

 

[Andrew Poulsom]

You can use VLOOKUP or INDEX/MATCH. For a tutorial see:

http://www.contextures.com/xlFunctions02.html

http://www.contextures.com/xlFunctions03.html

 

[aaaaaaaaaaaaaaa]

thanks for the reply had a look at the links but seems as if it only brings back one column worth of data in steead of the full row also i dont know how to put each field in that one row into different rows on the second sheet any chance anyone can have a look at the sheet i have made and put something togethjer for it if so that would be great.

 

[Andrew Poulsom]

You have to put a different formula in each cell, specifying the column number in VLOOKUP's third argument.

 

[aaaaaaaaaaaaaaa]

there is cell a7 on sheet two where the user will input the ref number once entered it brings up the row matching that ref number and pastes each field from that row onto the corresponding lines such as b9 b10 b11 etc. from your reply i am still struggling to know how to do it apologise but i am rubish at spread sheets so hoping someon can give me a little bat of time to help.

 

[Andrew Poulsom]

How is the data you want to look up laid out? Where do you want to put the results of the look up formulas?

 

[aaaaaaaaaaaaaaa]

sheet one is laid out in a table format with ref number listed in column a column b to k have headings for the information to be entered under. on sheet to i have a cell called ref number so when a number is put in for exaple ref 2 then it will pull all the data from ref 2 row so cells a2 to k2 and paste them onto specified cells on sheet two ie where the corresponding headings are on sheet two. it is so once the ref number is entered it pulls the data from that row accross and can be printed as a document styled sheet. basically sheet one is a log of orders that users will fill out info then sheet two is to enter the ref number of that order and it will pull the info up and paste it in the way i have laid it out so works as a paper copy of the order. if that makes sense.

 

[Andrew Poulsom]

So use VLOOKUP, adjusting the column index (third argument) as necessary.

 

[aaaaaaaaaaaaaaa]

i was hoping you wouldnt say that as I HAVE ALWAYS STRUGGLED WITH THEM DONT KNOW WHY BUT JUST CANT WORK OUT HOW TO USE THEM I ALWAYS GET THEM HALF WORKING FOR SOME REASON HOWEVER I WILL GIVE IT A TRY AND GET BACK IF STRUGGLING CHEERS

 

[JackDanIce]

I don't think typing in caps will help resolve any faster, especially after the advise that's already been posted.

Suggest looking for VLOOKUP examples to familiarise yourself with them. It's also a useful function to learn which you may find useful in the future:
http://www.contextures.com/xlfunctions02.html