Forum home » Delegate support and help forum » Microsoft Excel Training and help » Multiple V-Lookups
|
|
|
The UK's most regular 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. |
Multiple V-Lookups
Resolved · Urgent Priority · Version 2007
Reply 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
For upcoming training course dates see: Pricing & availability
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
|