Cell value = sheetname to pull information from in excel formula
Solved
Tbonekiller
TrowaD
- Posts
- 15
- Registration date
- Wednesday August 21, 2019
- Status
- Member
- Last seen
- February 28, 2022
TrowaD
- Posts
- 2884
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- June 21, 2022
Related:
- Cell value = sheetname to pull information from in excel formula
- Excel formula if cell contains text then return value in another cell ✓ - Forum - Excel
- How to pull data from one excel sheet into another automatically - Guide
- Leaving a cell value unchanged if a condition is false excel - Forum - Office Software
- Excel formula if two cells match return value from third ✓ - Forum - Excel
- Excel formula if cell contains date ✓ - Forum - Office Software
3 replies
TrowaD
Sep 30, 2021 at 11:18 AM
- Posts
- 2884
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- June 21, 2022
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
Sep 30, 2021 at 12:14 PM
- Posts
- 15
- Registration date
- Wednesday August 21, 2019
- Status
- Member
- Last seen
- February 28, 2022
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
Oct 4, 2021 at 11:44 AM
- Posts
- 2884
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- June 21, 2022
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