Selecting data in columns dependant on specific criteria

Hi, apologies if this is very basic, but I a wanting to know what formula I need so that when a cell has a specific value it looks up the cell with the same value in another sheet and returns information relevant to this. Eg if in Sheet 1 cell A1 is "101000" I want to cell B1 to give me the name in Column B of sheet 2 that corresponds to reference "10100" in column A of sheet 2. I hope this makes sense and someone can help. Many thanks

You can use vlookup for this:
=vlookup(value to search, range to search in, column number to return)
for example, you would want:
=vlookup(Sheet1!A1,Sheet2!A1:B1000,2)

That will be something like this:

Please Login or Register  to view this content.

Hi, many thanks for getting back so quickly. Unfortunately though what you have suggested does not seem to work.
What I have is an excel sheet that I am putting details of sales in (invoice number, client name and address, value) etc and I am trying to link this sheet to a template sales invoice on a different sheet where I am wanting to just input the relevant sales invoice number and the rest of the information will flow through. using a "SUMIF" formula i am able to get the numerical and date information but not the narrative. Any suggestions please?
Many thanks

Can you upload your workbook please, click go advanced and then manage attachments.

We just need a sample of your data, you can remove any sensitive information.

Sales 2.xlsx

I hope that has worked

So in cell A10 of the invoice sheet you need:
=VLOOKUP(N$2,Sales!B$3:T$14,3,FALSE)
in cell A11 you need
=VLOOKUP(N$2,Sales!B$3:T$14,4,FALSE)
in cell A12 you need
=VLOOKUP(N$2,Sales!B$3:T$14,5,FALSE)

and so on.

Thank you very much yudlugar, really appreciate it!