Lookup question.
 

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

Hi,

Your Data range - A1:F16

In H1 - Location
H2 - KH
I1 - Month
I2 - 11
J1 - Currency
J2 - CAD
K1 - Percent

In K2,

=DGET(A1:F16,6,H1:J2)

HTH


--
Krishnakumar


------------------------------------------------------------------------
Krishnakumar's Profile: http://www.excelforum.com/member.php...o&userid=20138
View this thread: http://www.excelforum.com/showthread...hreadid=467212