Originally Posted by FDibbins Try this... =INDEX($B$5:$L$10,MATCH($M$1,$A$5:$A$10,0),MATCH(J1,$B$4:$F$4,0)+IF(I1=26,6,0)) This formula works beautifully! Could you please tell me what the +IF(I1=26,6,0)) represents?
There are currently 1 users browsing this thread. (0 members and 1 guests)
View Tag Cloud
Forum Rules
Bookmarks