98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » V Look Up
V Look Up
Resolved · Low Priority · Version 2003
Victoria has attended:
Excel Advanced course
V Look Up
Why are the values sometimes not recognised when you look up a value from another spreadsheet?
RE: v Look Up - from other spreadsheet
Dear Victoria
Thank you for attending Excel Advanced course. I hope you enjoyed the course and have also started using the topics that were covered in the course.
The answer to your question depends on how you are applying the Vlookup. If you try to copy and paste the answer of one Lookup function from one cell to another from one workbook to another please remember that the absolute referencing (the dollar signs within cells) is applied by default so sometimes it is important to remove the dollar signs to make the cells relative. This is specially relevant when you decide to copy and paste the Vlookup function to other cells.
If your question was more specific then I would request you to provide an example and I should be able to look into it.
I hope you are aware of the Relative and Absolute referencing. If you have further questions about them then you may want to ask that as a separate post or you can reply to this post.
I hope this has answered your query.
If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!
Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007
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:Formst Excel to display leading zeroesSelect the cells that you want to have displaying leading zeroes. |