LinkBack URL
About LinkBacks
If you're not opposed to INDIRECT
=INDEX(data,MATCH($A2,rawdata!$A:$A,0),1+MATCH(C$1,INDIRECT("rawdata!"&MATCH($A2,rawdata!$A:$A,0)&":"&MATCH($A2,rawdata!$A:$A,0)),0))
If you're not opposed to INDIRECT=INDEX(data,MATCH($A2,rawdata!$A:$A,0),1+MATCH(C$1,INDIRECT("rawdata!"&MATCH($A2,rawdata!$A:$A,0)&":"&MATCH($A2,rawdata!$A:$A,0)),0))
-GregIf this is helpful, pls click Star icon in lower left corner
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks