Because VLOOKUP() is easy to use, I would create an artificial key in the
table by concatinating location, month, and currancy. Use a separate column.
The first entry would be:

AN11USD

You can have the user enter three separate items, but concatinate them prior
to using VLOOKUP
--
Gary''s Student


"spartanmba" wrote:

Is it possible to use a look up function for the data below? I am trying to
return the data in the percent column based upon location, month, and
currency. For example, for location KH, month 11, currency CAD the function
would retrieve 63. Thank you for your help.


Location Year Month Currency Quarter Percent
AN 2005 11 USD 3 81
AN 2005 12 CAD 3 0
AN 2005 12 EUR 3 0
AN 2005 12 MXN 3 19
AN 2005 12 USD 3 81
KH 2005 7 CAD 3 67
KH 2005 7 USD 3 33
KH 2005 8 CAD 3 61
KH 2005 8 USD 3 39
KH 2005 9 CAD 3 65
KH 2005 9 USD 3 35
KH 2005 10 CAD 3 64
KH 2005 10 USD 3 36
KH 2005 11 CAD 3 63
KH 2005 11 USD 3 37