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