Okay, in B2:
=INDEX(D2:M2,MATCH(C2,D2:M2,0)-1) copied down
in A2:
=INDEX($D$1:$M$1,MATCH(C2,D2:M2,0)-1)
or
=INDEX($D$1:$M$1,MATCH(B2,D2:M2,0))
Okay, in B2:
=INDEX(D2:M2,MATCH(C2,D2:M2,0)-1) copied down
in A2:
=INDEX($D$1:$M$1,MATCH(C2,D2:M2,0)-1)
or
=INDEX($D$1:$M$1,MATCH(B2,D2:M2,0))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks