Microsoft Office Forums - View Single Post - [Solved] Cricket Stats Help

Thread: [Solved] Cricket Stats Help

View Single Post

Old

06-02-2016, 05:25 PM

jeffreybrown jeffreybrown is offline

jeffreybrown is offline

jeffreybrown uses Windows Vista

Windows Vista jeffreybrown uses Office 2007

jeffreybrown uses Office 2007

Office 2007

Expert

Join Date: Apr 2016

Posts: 673

jeffreybrown has a spectacular aura about

jeffreybrown has a spectacular aura about

Default

If I understand correctly, then in E17 copied down

=INDEX('Bowling Stats'!$F$4:$F$18,MATCH(ROW($A$5)-(ROW(A1)-1),'Bowling Stats'!$N$4:$N$18,0))

Reply With Quote