Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel - Sorting

Excel - Sorting

ResolvedVersion Standard

Wed 13 Feb 2008, 10:00 Delegate Adam said...

Adam has attended:
Excel Advanced course
Excel VBA Intro Intermediate course

Excel - Sorting

What is the best way to pull in information from one spreadsheet to another using a unique identifier. I.E. a product code is the same on two sheets but the price is different can I pull the price from one sheet next to the price in the other.

Wed 13 Feb 2008, 16:38 Delegate Paul said...

RE: Excel - Sorting

A simple vlookup could do this.

=vlookup(A1,sheet2!A1:E2000,2,0)

assuming that A1 is the product code.

sheet2!A1:E2000 is the range that vlookup is looking in

and that the price on sheet2 is in column B (second column along)

Thu 14 Feb 2008, 12:13 Delegate Adam said...

RE: Excel - Sorting

Paul,

Perfect thankyou, that's saved us about 20 hours a month!

Thanks,

Adam

Thu 13 Mar 2008, 12:23 Trainer Pete said...

RE: Excel - Sorting

Well done Paul, thank you for that response, it looks like Adam is well pleased. Best regards Pete.

Training courses

98.1 % recommend us

More live stats...

Training information:

Excel tip:

Do a fast scroll

In big Excel databases with many records, you can move down thousands of rows super-fast as follows: hold down Shift then click on the scrollbar somewhere below the scrollbar handle. This will move you way down the sheet without your having to use the scrollbar up/down arrows or drag on the scrollbar handle.

View all Excel hints and tips