Hi all,
I have a summary sheet and about 250 different worksheets, and in column C of the summary page I have the name of each tab in the workbook.
I would like to do a lookup to the particular worksheet, and once there, find the word "total" in Row 8 (will be found no later than column N, but sometimes as early as column F), and then Hlookup off that "total" to provide the value listed 13 rows down.
Is this something that is possible? Thanks in advance for any help.
I have a summary sheet and about 250 different worksheets, and in column C of the summary page I have the name of each tab in the workbook.
I would like to do a lookup to the particular worksheet, and once there, find the word "total" in Row 8 (will be found no later than column N, but sometimes as early as column F), and then Hlookup off that "total" to provide the value listed 13 rows down.
Is this something that is possible? Thanks in advance for any help.