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
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
