Large function corresponding columns

[Dark0Prince]

I'm trying to get the cells that correspond to the results in the Large function

=LARGE(CHOOSE({1,2,3},DEF!F:F,GJ!F:F,DEN!F:F,),F3)

I tried this, but couldn't get it to work.

=INDEX(INDIRECT("'"&INDEX({"DEF","GJ","DEN"},E3)&"$B:$B"),MATCH(E3,INDIRECT("'"&INDEX({"DEF","GJ","DEN"},E3)&"$B:$B"),0))

 

[Aladin Akyurek]

What do we have in F3 and E3?

 

[Dark0Prince]

I used a SUMIFS with individual large functions instead of doing this. so no longer need help with this.

 

[Aladin Akyurek]

I used a SUMIFS with individual large functions instead of doing this. so no longer need help with this.

Care to share the SumIfs solution?

 

[Dark0Prince]

Care to share the SumIfs solution?

I thought I used SumIfs, but that was a different workbook. I'm in excel so much I get lost in some of the things I work on. So to go back to your original question in E3 that is the number of position so 1 in the first row 2 in the second row ect. E3 is where I have my formula

=LARGE(CHOOSE({1,2,3},DEF!F:F,GJ!F:F,DEN!F:F,),F3)