Hi I have a function in a cell that looks like this

=IF(ISERROR(INDEX(INDIRECT("'" & $C$1 & "'!$B$2:$B$39"),MATCH(Summary!$A$2,INDIRECT("'" & $C$1 & "'!$A$2:$A$39"),0))),"",INDEX(INDIRECT("'" & $C$1 & "'!$B$2:$B$39"),MATCH(Summary!$A$2,INDIRECT("'" & $C$1 & "'!$A$2:$A$39"),0)))
Instead of having the "Summary!$A$2" I want to index the left most cell in the same row as the cell with this function in it. The above code would be perfect for cell C2 but as I have to sort, then this function becomes useless in a different positoin

Please Help!!!