Dougal has attended:
Project Management - Framework & Processes course
Excel Intermediate course
Linking cells and copying cell relationship to new worksheet
Hi there,
I know this was part of the training but it's something I'm struggling with. In one worksheet I need to link a list of items in one column to their values in another column, and then copy that relationship to a different worksheet where the list is in a totally different order. The end result being that the values for the items in the list are the same in worksheet 2 as in worksheet 1, even though the order is different.
Any help would be greatly appreciated.
RE: linking cells and copying cell relationship to new worksheet
Hi Dougal,
Thank you for the forum question.
You can use a Vlookup to lookup the values. The item will be the lookup value.
Please watch the video below.
https://www.youtube.com/watch?v=wsTXTufM_Lc& ;t=95s
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector