|
2-dimensional lookup
Master list of data
DR AB TT 1 X1 n1 2 X2 n12 3 X3 n23 4 X4 n34 5 X5 n45 1 X2 n2 2 X3 n13 3 X4 n24 4 X5 n35 5 X1 n41 1 X3 n3 2 X4 n14 3 X5 n25 4 X1 n31 5 X2 n42 1 X4 n4 2 X5 n15 3 X1 n21 4 X2 n32 5 X3 n43 1 X5 n5 2 X1 n11 3 X2 n22 4 X3 n33 5 X4 n44 My data list: AB DR TT X1 1 X1 2 X2 3 X4 3 X3 4 X2 1 X5 2 How to fill column TT based on the master list? |
2-dimensional lookup
Assume the master list id in the range A2:C26.
The data list is in the range E2:F8 Enter this formula as an array in G2 using the key combination of CTRL,SHIFT,ENTER (not just ENTER): =INDEX(C$2:C$26,MATCH(1,(A$2:A$26=F2)*(B$2:B$26=E2 ),0)) Copy down as needed. Biff "Madhu" wrote in message ... Master list of data DR AB TT 1 X1 n1 2 X2 n12 3 X3 n23 4 X4 n34 5 X5 n45 1 X2 n2 2 X3 n13 3 X4 n24 4 X5 n35 5 X1 n41 1 X3 n3 2 X4 n14 3 X5 n25 4 X1 n31 5 X2 n42 1 X4 n4 2 X5 n15 3 X1 n21 4 X2 n32 5 X3 n43 1 X5 n5 2 X1 n11 3 X2 n22 4 X3 n33 5 X4 n44 My data list: AB DR TT X1 1 X1 2 X2 3 X4 3 X3 4 X2 1 X5 2 How to fill column TT based on the master list? |
| All times are GMT +1. The time now is 10:58 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com