Excel - Sorting

The UK's most regular instructor-led training courses.
Training information: microsoft-excel-courses · Excel in courses · Microsoft Excel Training
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

Excel - Sorting

Adam has attended:
Excel Advanced course
Excel VBA course

by - delegate Adam [2 posts] (2008 Feb 13 Wed, 10:00) Reply

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.

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003/XP	2008 Jul 17 Thu + 18 Fri	Bloomsbury	3	book now	£475	£495
2003/XP	2008 Jul 30 Wed + 31 Thu	Bayswater	5	book now	£450	£485
2003/XP	2008 Aug 7 Thu + 8 Fri	Bloomsbury	6	book now	£450	£485
2003/XP	2008 Aug 14 Thu + 15 Fri	Bloomsbury	5	book now	£450	£485
2003/XP	2008 Aug 26 Tue + 27 Wed	Bayswater	6	book now	£450	£485
2003/XP	2008 Sep 8 Mon + 9 Tue	Bayswater	7	book now	£345	£399
Full Schedule: See all 48 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: Excel - Sorting

by - delegate Paul gold contributer [121 posts] (2008 Feb 13 Wed, 16:38) Reply

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

by - delegate Adam [2 posts] (2008 Feb 14 Thu, 12:13) Reply

Paul,

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

Thanks,

Adam

RE: Excel - Sorting

by - trainer Pete platinum contributer [600 posts] (2008 Mar 13 Thu, 12:23) Reply

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

· Microsoft Excel Features and Functions for Accountants
· How to Create Better Excel Spreadsheets: Part Three
· MS Excel: Excel At Making The Most Of Your Christmas
· Reasons Why VBA for Excel Training Fails
· Tools From Advanced Excel Courses: Goal Seek and Solver

Please browse our web site to find out more about
microsoft-excel-courses and other Microsoft training courses.

Excel tip:

Select blank cells automatically

Get Excel to find any blank (empty) cells in a region for you by:

1. Selecting the appropriate region from your spreadsheet.

2. On the menu bar, go to Edit - Go to.

3. Click the 'Special' button, then select Blanks and click OK.

View all Excel hints and tips