Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel training - Find/Match/Copy
|
|
|
The UK's most regular 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. |
microsoft excel training - Find/Match/Copy
Resolved · Low Priority · Version Standard
Reply Thu 13 Dec 2007, 17:17Delegate Jonathan said...
Jonathan has attended:
Excel Intermediate course
Excel Advanced course
Excel Advanced course
Find/Match/Copy
I would like to search for a cell value for example A3 (J.Parm), match the cells next to his name, b3,c3,d3, then copy the results to another workbook.
For upcoming training course dates see: Pricing & availability
RE: Find/Match/Copy
Dear Johnathan
Thank you for attending our Excel Inter and Adv. Training!!
The best feature I can think to resolve this will be VLOOKUP!!
Remember that the result of the VLOOKUP can be extracted from one sheet to another. This will save you time from copying it and pasting it to another sheet.
I think we sat after the training on Thursday and you showed me the file on the USB stick and we have resolved this problem.
If you have any further problem then please do post it on the forum!
It was a shame not having you in the Excel Advanced training as you were sick!! I hope you are feeling better now! :)
Kindest Regards
Rajeev Rawat
MOS Master Instructor 2000 AND 2003
|