Hi guys,
Strange one here. I have a formula which references tab "A" unless there is an error, in which case it will reference tab "B"
Is there a formula which would tell me which tab is being referenced? PR is that wishful thinking!
Cheers
Hi guys,
Strange one here. I have a formula which references tab "A" unless there is an error, in which case it will reference tab "B"
Is there a formula which would tell me which tab is being referenced? PR is that wishful thinking!
Cheers
Wouldn't have thought so unless you add some sort of text "flag" to the result. For example,Formula:Please Login or Register to view this content.
Last edited by TMS; 01-03-2019 at 07:58 AM. Reason: Add trailing bracket
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
This will return the sheet number (in the order it was created) but not the sheet name. You would need a lookup table for that in addition to this.
In Excel 2013 and newer and entered in Sheet2.
=SHEET('2019 Run Sheet'!I2)
Dave
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks