Hi maybe a simple one for someone but im trying to use a dropdown list with all the sheet names in it as a refrence, then what ever i select in the drop down list it uses it as the sheet name in the formula, i have attached a example, using google sheets. so in the formula where it says for example Sheet2! i want that replaced with the value in the drop down list. formula is in B1.
thanks again for any help.
https://docs.google.com/spreadsheets...it?usp=sharing
Use the Indirect function.
=INDIRECT(A1 &"!A1")
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
Thanks for the reply, how would I link that in with my formula?
=TRANSPOSE(FILTER(Sheet2!B2:B,Sheet2!A2:A = A2 ) )
I need to replace sheet2! With Value in cell A1
Thank you
=TRANSPOSE(FILTER(indirect(A1&"!B2:B"),Indirect(A1&"!A2:A") = A2 ) )
Works perfect thank you very much for your help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks