Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

excel sorting

ResolvedVersion Standard

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.

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)

RE: Excel - Sorting

Paul,

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

Thanks,

Adam

RE: Excel - Sorting

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

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

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.13 secs.