98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Multiple V-Lookups
Multiple V-Lookups
Resolved · Urgent Priority · Version 2007
Thu 3 Feb 2011, 17:13Delegate Zak said...
Zak has attended:
No courses
Multiple V-Lookups
How do I do multiple vlookups. I.e how do I lookup two values which then provides the one answer.
For example if I wanted to report back the currency rate for February which is the first lookup, and then for the currency Euro which would be the second vlookup. How would I do this?
Can somebody input a template formula here please.
Thanks
Zak
Sun 6 Feb 2011, 15:51Trainer Anthony said...
RE: Multiple V-Lookups
Hi Zak, thanks for your query. Can you give me a bit more information about what you're trying to achieve. First of all, is all the information on the same worksheet? If so, why do you need two lookups to locate one value? Secondly, have you investigated the MATCH and INDEX functions. These give more structural flexibility than VLOOKUP (which can only return values to the left of the lookup value field) and might be worth investigating depending on your situation.
Anthony
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:Deleting a range of cells using the autofill handleFirstly, select the range of cells for which you would like to clear the contents. Then drag the autofill handle to the the top left corner of the selection whilst holding down the shift key. Your selected contents should then be deleted. |
