Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup formula question | Excel Discussion (Misc queries) | |||
Lookup question | Excel Discussion (Misc queries) | |||
lookup question | Excel Worksheet Functions | |||
Lookup Question | Excel Worksheet Functions | |||
Multiple Criteria Lookup Question | Excel Discussion (Misc queries) |