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 » microsoft excel training - Find/Match/Copy
microsoft excel training - Find/Match/Copy
Resolved · Low Priority · Version Standard
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.
Mon 17 Dec 2007, 11:11Trainer Rajeev said...
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
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:Repeat actionThe F4 key will usually repeat your last action. e.g. delete a row, then select another row and press F4 to delete again. |
