• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Reference the content of a cell to retrieve a tab name

Good evening SirJB7

OP lucky to be in the edit period....:p But why not just use the site upload for such a small file.


.
 
Hi, b(ut)ob(ut)hc!
Because if the user did so, how could I have been able to write my previous post?
Regards!
 
Hi, snaylor!

Next time please post here the issue description, keeping it into your workbook too if you consider it propertly.
This will help users who read this to decide whether they'd be able or want to analyze it further, without having to download/open any file.

And about your question, change B5 formula to this:
=SI.ERROR(DESREF(INDIRECTO($A5&"!$A$4:$C$15");COINCIDIR(B$3;INDIRECTO($A5&"!$A$4:$A$15");0)-1;1;1;1);"") -----> in english: =IFERROR(OFFSET(INDIRECT($A5&"!$A$4:$C$15"),MATCH(B$3,INDIRECT($A5&"!$A$4:$A$15"),0)-1,1,1,1),"")
and adjust all other across similarly and then copy down as required.

Regards!
 
Last edited:
File is uploaded.

In the formulas, I want the tab names to directly reference the descriptions in column A so that as more descriptions are added in the future, the user can simply copy the formula down and not be required to change the references in the formulas.
 

Attachments

Hi, snaylor!
I yet saw the previously uploaded file, thank you. What I didn't see was the issue description... without downloading and opening the file.
Regards!
 
Hi, snayulor!
Glad you solved it. Thanks for your feedback and for your kind words too. And welcome back whenever needed or wanted.
Regards!
 
Hi snalylor,

You got a beautiful solution from SirJB7. Here another formula for your problem, considering the data table for all product is same.

=IFERROR(INDEX(INDIRECT($A5&"!$A$4:$C$15"),MATCH(B$3,INDIRECT($A5&"!$a$4:$a$15"),0),MATCH(B$4,INDIRECT($A5&"!$a$3:$c$3"),0)),"")

Regards,
 
@Somendra Misra
Hi!
Then I won a Carlsberg? Sorry, they always come in pairs at the pubs. Two Carlsbergs then. Or in six-packs at stores. Hence better at a store. ;)
Regards!
 
@Somendra Misra
Hi!

Here you have:
http://www.redusers.com/noticias/wp-content/uploads/2012/01/subehackeadarporanonymous.jpg
It comes preloaded with 15 AR$ (a buck and a bit) and you have an overdraft of another 10 AR$. Enough for 7 or 9 tickets in buses, 5 in subways and 25 in trains.

More info:
https://www.sube.gob.ar/QueEsSUBE.aspx

Waiting for you.

Regards!

PS: If need air tickets, Chandoo will issue them for you... for free of course... just get a chair at a hand to wait for the postmail service arrival. Someday it'll sound to you this phrase: "It's in the mail...!". Ask @Hui about that. ;)
 
You must log in or register to reply here.
Back
Top