Cell value = sheetname to pull information from in excel formula
Solved/Closed
Tbonekiller
Posts
16
Registration date
Wednesday August 21, 2019
Status
Member
Last seen
July 20, 2022
-
Sep 29, 2021 at 12:22 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Oct 4, 2021 at 11:44 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Oct 4, 2021 at 11:44 AM
Related:
- Cell value = sheetname to pull information from in excel formula
- 1st, 2nd, 3rd position formula in excel ✓ - Office Software Forum
- How to change date format in excel - Guide
- Transfer data from one excel worksheet to another automatically - Guide
- Number to words in excel formula - Guide
- Excel formula to subtract one cell from another - Excel Forum
3 replies
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 16, 2023
545
Sep 30, 2021 at 11:18 AM
Sep 30, 2021 at 11:18 AM
Hi Tbonekiller,
Give the following formula a try:
{=MAX(IF(INDIRECT("'"&A26&"'!"&"C6:C3006")=A26,INDIRECT("'"&A26&"'!"&"A6:A3006"),))}
Best regards,
Trowa
Give the following formula a try:
{=MAX(IF(INDIRECT("'"&A26&"'!"&"C6:C3006")=A26,INDIRECT("'"&A26&"'!"&"A6:A3006"),))}
Best regards,
Trowa
Tbonekiller
Posts
16
Registration date
Wednesday August 21, 2019
Status
Member
Last seen
July 20, 2022
Sep 30, 2021 at 12:14 PM
Sep 30, 2021 at 12:14 PM
That's what I had tried and I was getting a #REF error. Didn't know if I was typing something wrong or because my sheets are using numbers (i.e. 9.50, 9.60, 18.15, etc...) if that was causing an issue. OK so it looks like only the numbers ending in 0 are giving the #REF error (9.50, 7.50, 8.50, etc...). As long as it has an actual number (ex. 11.51) then the indirect formula works otherwise I have to specify the sheetname so that it covers that place holder 0.
Any thoughts?
Any thoughts?
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 16, 2023
545
Oct 4, 2021 at 11:44 AM
Oct 4, 2021 at 11:44 AM
Hi Tbonekiller,
Change the number format of the column containing the sheet references to text by going into the cell properties. That should keep the zero at the end.
Best regards,
Trowa
Change the number format of the column containing the sheet references to text by going into the cell properties. That should keep the zero at the end.
Best regards,
Trowa