BobbyBrownPants
New Member
- Joined
- Oct 24, 2014
- Messages
- 5
Hi everyone and thanks in advance
I have a workbook with 382 sheets. 381 of the sheets are all the same format
I need to VLOOKUP from A2 in the 1st sheet to find that value in cells K7:L56 of all the other 381 sheets returning column L
I've used
REPLACE(GET.WORKBOOK(1),1,FIND("]",GET.WORKBOOK(1)),"")
to create a list of the sheet names and created a List Name of these called MySheets
I've tried using this formula
VLOOKUP(A2,INDIRECT("'"&INDEX(MySheets,MATCH(1,--(COUNTIF(INDIRECT("'"&MySheets&"'!$K$7:$L$56"),A2)>0),0))&"'!$K$7:$L$56"),2,FALSE)
and completed it using Ctrl + Shift +Enter but it hasn't worked
Can anyone help please?
Thanks again
Bobby
I have a workbook with 382 sheets. 381 of the sheets are all the same format
I need to VLOOKUP from A2 in the 1st sheet to find that value in cells K7:L56 of all the other 381 sheets returning column L
I've used
REPLACE(GET.WORKBOOK(1),1,FIND("]",GET.WORKBOOK(1)),"")
to create a list of the sheet names and created a List Name of these called MySheets
I've tried using this formula
VLOOKUP(A2,INDIRECT("'"&INDEX(MySheets,MATCH(1,--(COUNTIF(INDIRECT("'"&MySheets&"'!$K$7:$L$56"),A2)>0),0))&"'!$K$7:$L$56"),2,FALSE)
and completed it using Ctrl + Shift +Enter but it hasn't worked
Can anyone help please?
Thanks again
Bobby
