Do you mean perhaps:
![]()
G4: =INDEX(Sheet2!$A$2:$V3000,MATCH($G$2,Sheet2!$C$2:$C30000,0),MATCH($H$2,Sheet2!$A$1:$V$1,0))
Do you mean perhaps:
![]()
G4: =INDEX(Sheet2!$A$2:$V3000,MATCH($G$2,Sheet2!$C$2:$C30000,0),MATCH($H$2,Sheet2!$A$1:$V$1,0))
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks