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.
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
