98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel - Sorting
Excel - Sorting
Resolved · Low Priority · Version Standard
Wed 13 Feb 2008, 10:00Delegate 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:38Delegate 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:13Delegate Adam said...
RE: Excel - Sorting
Paul,
Perfect thankyou, that's saved us about 20 hours a month!
Thanks,
Adam
Thu 13 Mar 2008, 12:23Trainer Pete said...
RE: Excel - Sorting
Well done Paul, thank you for that response, it looks like Adam is well pleased. Best regards Pete.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Hiding and unhiding columns using the keyboardCTRL + 0 hides your columns and CTRL + SHIFT + ) unhides them although you would need to highlight the column letters either side as per normal |
