Hi Guys,
Hope all are well.
There is a macro within this workbook (on the summary sheet tab) which places all sheet names in col A, from a2 down.
I need to adapt the index match formula in cells B and C2 to be able to reference the values in col A, which are the sheet names, as I don’t want to have to type the sheet name each time!
=INDEX(Bob!$B:$B,MATCH(Summary!$B$1,Bob!$A:$A,0))
in the formula above I typed Bob! which is in cell a2 of the summary sheet but would like to be able to reference it using a formula.
Any ideas?
please see attached.
Thanks
Last edited by Blake 7; 02-01-2012 at 05:05 AM. Reason: to mark as solved
Blake 7
If your question has been answered, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
If any member's response has helped to solve your problem, please consider using the scales icon on the top right of their post to show your appreciation.
http://failblog.org/
Try this:
=INDEX(INDIRECT("'"&A2&"'!$B:$B"),MATCH(Summary!$B$1,INDIRECT("'"&A2&"'!$A:$A"),0))
The apostrophes allow for your sheet names having spaces.
Hope this helps.
Pete
Hey pete. bloody marvellous!! thanks!
Blake 7
If your question has been answered, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
If any member's response has helped to solve your problem, please consider using the scales icon on the top right of their post to show your appreciation.
http://failblog.org/
Glad to be able to help - thanks for feeding back.
Pete
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks