In 2007 and later versions
Else you'll probably have to stuck with your original formula![]()
=IFERROR(INDEX(Points!$A$5:Points!$A$43, MATCH(1,Points!$AX$5:Points!$AX$43,0)),"")
In 2007 and later versions
Else you'll probably have to stuck with your original formula![]()
=IFERROR(INDEX(Points!$A$5:Points!$A$43, MATCH(1,Points!$AX$5:Points!$AX$43,0)),"")
Life's a spreadsheet, Excel!
Say thanks, Click *
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks