Dynamic use of INDIRECT with LARGE

[pnperl]

I am getting error while using Indirect function inside large function to make dynamic formula

Requirement: if I put 7 in feedback sheet, P8 should return results of row 7 in F sheet

So, i have tried replacing F!$F$6:$M$6,F!$O$6:$W$6 with indirect(="F!$F$"&N5&":$M$"&N5&",F!$O$"&N5&":$W$"&N5) in feedback sheet

Any suggestion?

P8 formula: ="FIRST BLOCK: "&ROUND(INDIRECT("F!N"&N5),0)&"; SECOND BLOCK:"&ROUND(INDIRECT("F!X"&N5),0)&CHAR(10)&"Top 3: "&CONCAT(INDIRECT("F!"&ADDRESS(3,MATCH(LARGE((F!$F$6:$M$6,F!$O$6:$W$6),1),INDIRECT("F!F"&N5&":W"&N5),0)+5,1,0),FALSE),": ",ROUND(LARGE((F!$F$6:$M$6,F!$O$6:$W$6),1),0),", ",INDIRECT("F!"&ADDRESS(3,MATCH(LARGE((F!$F$6:$M$6,F!$O$6:$W$6),2),INDIRECT("F!F"&N5&":W"&N5),0)+5,1,0),FALSE),": ",ROUND(LARGE((F!$F$6:$M$6,F!$O$6:$W$6),2),0),", ",INDIRECT("F!"&ADDRESS(3,MATCH(LARGE((F!$F$6:$M$6,F!$O$6:$W$6),3),INDIRECT("F!F"&N5&":W"&N5),0)+5,1,0),FALSE),": ",ROUND(LARGE((F!$F$6:$M$6,F!$O$6:$W$6),3),0))

[AliGW]

Please explain what the formula is meant to be doing. It's not easy to troubleshoot when we don't know what outcome you want.

Administrative Note:

Are you still using Excel 2010?

Although we value your privacy as much you do, it could be important that members have a rough idea of your location as the solutions they offer may be affected by your locale. For instance, you might in the future post questions which are related to your regional settings.

With this in mind, please update your profile to something more precise (something such as UK, Europe, USA, UAE, etc. will suffice).

Thank you for helping us to help you.

[pnperl]

The purpose of formula is to highlight Top 3 case numbers from F for each record which I enter number in cell N5

[AliGW]

Are you still using Excel 2010?

Please update your location as requested. Thanks.

[XLent]

if using O365 you might try something like:

Please Login or Register  to view this content.

no need for INDIRECT here.

[bird333]

Is 'CONCAT' a function in your version of excel? If I replace with 'CONCATENATE' the formula seems to work.