Allison has attended:
Excel Intermediate course
V-Look up
What is the easiest way to remember how to do this?
RE: V-Look up
Hello Allison,
Easy way to remember, what you are looking up must be unique (no duplicates), and the info required to return to you must be in a column to the right of the lookup column.
the VLOOKUP 4 attributes are as follows:
VLOOKUP(What are you looking for?, Where will you find it? Once found how many columns to count to the right, Exact match required)
I hope this resolves your question. If it has, please mark this question as resolved.
If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?
Have a great day.
Regards,
Mark
Microsoft Office Specialist Trainer