LinkBack URL
About LinkBacks
Try this formula in U52 copied down
=LOOKUP("zzz",IF({1,0},"",INDEX(Data!$CW$12:$CW$75,MATCH(1,INDEX(ISNA(MATCH( Data!$CW$12:$CW$75,U$51:U51,0))*(Data!$CX$12:$CX$75=E$51),0),0))))
it doesn't need "array entering"....
Try this formula in U52 copied down
=LOOKUP("zzz",IF({1,0},"",INDEX(Data!$CW$12:$CW$75,MATCH(1,INDEX(ISNA(MATCH( Data!$CW$12:$CW$75,U$51:U51,0))*(Data!$CX$12:$CX$75=E$51),0),0))))
it doesn't need "array entering"....
Audere est facere
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks