LinkBack URL
About LinkBacks
You can use a formula like this
=INDEX(Sheet1!$B$1:$D$1,MATCH(E2,INDEX(Sheet1!$B$2:$D$4,MATCH(A2,Sheet1!$A$2:$A$4,0),0),0))
where "b" is in A2 and "Steve" in E2
see attached F2 copied down
You can use a formula like this
=INDEX(Sheet1!$B$1:$D$1,MATCH(E2,INDEX(Sheet1!$B$2:$D$4,MATCH(A2,Sheet1!$A$2:$A$4,0),0),0))
where "b" is in A2 and "Steve" in E2
see attached F2 copied down
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks