Vlookup indirect with different workbook

[gl3nnyb0y24]

Good day. this formula works in the same workbook. =VLOOKUP($B$2,INDIRECT("'"&$A7&"'!$A:$DB"),75,FALSE) but when i use it with different workbook is not working. SUMMARY WORKBOOK Stock Code SHOES1 (input code) Description GIGASHOES (=VLOOKUP(B2,Sheet10)!A:F,2,FALSE) Color BLACK (=VLOOKUP(B2,Sheet10)!A:F,4,FALSE) <tbody> </tbody> Store Size 10 Store1 5 Store2 10 Store3 3 Store4 7 <tbody> </tbody>

<tbody>
</tbody>

STORE 1-2 WORKBOOK - STORE1 (SHEET1), STORE2 (SHEET2)

Stock Code	Description	Color	Size 10	Size 11
SHOES1	GIGASHOES	BLACK	5	3

<tbody>
</tbody>

STORE1 (SHEET1)

Stock Code	Description	Color	Size 10	Size 11
SHOES1	GIGASHOES	BLACK	10	5

<tbody>
</tbody>

STORE2 (SHEET2)



STORE 3-4 WORKBOOK - STORE3 (SHEET1), STORE4 (SHEET2)

Stock Code	Description	Color	Size 10	Size 11
SHOES1	GIGASHOES	BLACK	3	4

<tbody>
</tbody>

STORE3 (SHEET1)

Stock Code	Description	Color	Size 10	Size 11
SHOES1	GIGASHOES	BLACK	7	8

<tbody>
</tbody>

STORE4 (SHEET2)


Thanks in advance!

 

[gl3nnyb0y24]

Edited

Good day. this formula works in the same workbook. =VLOOKUP($B$2,INDIRECT("'"&$A7&"'!$A:$DB"),75,FALSE) but when i use it with different workbook is not working. SUMMARY WORKBOOK Stock Code SHOES1 (input code) Description GIGASHOES (=VLOOKUP(B2,Sheet10)!A:F,2,FALSE) Color BLACK (=VLOOKUP(B2,Sheet10)!A:F,4,FALSE) <tbody> </tbody> Store Size 10 Store1 5 =VLOOKUP($B$2,INDIRECT("'"&$A7&"'!$A:$DB"),75,FALSE) , this formula not working Store2 10 =VLOOKUP($B$2,INDIRECT("'"&$A7&"'!$A:$DB"),75,FALSE) , this formula not working Store3 3 =VLOOKUP($B$2,INDIRECT("'"&$A7&"'!$A:$DB"),75,FALSE) , this formula not working Store4 7 =VLOOKUP($B$2,INDIRECT("'"&$A7&"'!$A:$DB"),75,FALSE) , this formula not working <tbody> </tbody>

<tbody>
</tbody>

STORE 1-2 WORKBOOK - STORE1 (SHEET1), STORE2 (SHEET2)

Stock Code	Description	Color	Size 10	Size 11
SHOES1	GIGASHOES	BLACK	5	3

<tbody>
</tbody>

STORE1 (SHEET1)

Stock Code	Description	Color	Size 10	Size 11
SHOES1	GIGASHOES	BLACK	10	5

<tbody>
</tbody>

STORE2 (SHEET2)



STORE 3-4 WORKBOOK - STORE3 (SHEET1), STORE4 (SHEET2)

Stock Code	Description	Color	Size 10	Size 11
SHOES1	GIGASHOES	BLACK	3	4

<tbody>
</tbody>

STORE3 (SHEET1)

Stock Code	Description	Color	Size 10	Size 11
SHOES1	GIGASHOES	BLACK	7	8

<tbody>
</tbody>

STORE4 (SHEET2)


Thanks in advance!