LinkBack URL
About LinkBacks
adekinteristi 
This formula is shorter and doesn't have to be array entered.Formula:
=INDEX(INDIRECT("'"&SUBSTITUTE(LOOKUP("zzzzz",$A$1:A$1)," ","")&"'!$A$3:$G$13")&"",ROWS($4:4),MATCH(A$3,$A$3:$G$3,0))
This formula is shorter and doesn't have to be array entered.Formula:=INDEX(INDIRECT("'"&SUBSTITUTE(LOOKUP("zzzzz",$A$1:A$1)," ","")&"'!$A$3:$G$13")&"",ROWS($4:4),MATCH(A$3,$A$3:$G$3,0))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks