Afternoon All,
Wondering if I could get a little help.
I'm trying to create a "Top 10" list of Outstanding Invoices, by Value. I have 12 Tabs (one per month) which have the data for the Monthly Invoices on.
I've tried the following :
=INDEX(INDIRECT("'"&Q1&"'!B:B"),MATCH(LARGE(INDIRECT("'"&Q1&"'!P:P"),1),(INDIRECT("'"&Q1&"'!P:P",0))))
Which is pulling a #REF! Error.
Basically, B:B is my list of Invoice Numbers, P:P is the Value of the Invoice. Q1 has my Month's name in it. Changing the Formula from an Indirect to just refer to the named tab (January/February/etc.) it works just fine, but as soon as I change it to an Indirect, the error occurs. I was using the Indirect so I can use a Data Validation to flick between the Month's easily.
Am I missing something or have I just overly complicated this?
Any help would be greatly appreciated.
Wondering if I could get a little help.
I'm trying to create a "Top 10" list of Outstanding Invoices, by Value. I have 12 Tabs (one per month) which have the data for the Monthly Invoices on.
I've tried the following :
=INDEX(INDIRECT("'"&Q1&"'!B:B"),MATCH(LARGE(INDIRECT("'"&Q1&"'!P:P"),1),(INDIRECT("'"&Q1&"'!P:P",0))))
Which is pulling a #REF! Error.
Basically, B:B is my list of Invoice Numbers, P:P is the Value of the Invoice. Q1 has my Month's name in it. Changing the Formula from an Indirect to just refer to the named tab (January/February/etc.) it works just fine, but as soon as I change it to an Indirect, the error occurs. I was using the Indirect so I can use a Data Validation to flick between the Month's easily.
Am I missing something or have I just overly complicated this?
Any help would be greatly appreciated.