Table 1 is in sheet1: Assum table is in A1:F6, with L1-L5 in A3:A6, C1-C5 in B2:F2
Cell E2:
![]()
=INDEX(sheet1!B3:F6,MATCH(C2,sheet1!A3:A6,0),MATCH(D2,sheet1!B2:F2,0))
Table 1 is in sheet1: Assum table is in A1:F6, with L1-L5 in A3:A6, C1-C5 in B2:F2
Cell E2:
![]()
=INDEX(sheet1!B3:F6,MATCH(C2,sheet1!A3:A6,0),MATCH(D2,sheet1!B2:F2,0))
Quang PT
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks