Rachel has attended:
Excel Intermediate course
V lookup
Why when dragging Vlook up down cells (to copy the format) does it display anything or any errors? I have tried editing the format but it won't link with the data correctly.
RE: V lookup
Hi Rachel,
Thank you for the forum question.
If the first cell shows the right result and you get errors (N/A) when you copy it down, then you probably haven't "locked" the table array. The table array must be locked. If the table array is a1:k40 you must have it like this $A$1:$K$40. Please let me know if this is not the issue.
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