Help in Vlookup in multiple workbooks with multiple sheets

[nathanmav]

Hi everyone,

Just want to ask regarding my vlookup formula is there any other way to make it fast and easy. The formula is in the master workbook.
Here is the formula:

=IFERROR(VLOOKUP(A1,'C:\Project\Test\[Book1.xlsx]Sheet1'!$B$13:$J$35,7,FALSE),
IFERROR(VLOOKUP(A1,'C:\Project\Test\[Book1.xlsx]Sheet2'!$B$13:$J$35,7,FALSE),
IFERROR(VLOOKUP(A1,'C:\Project\Test\[Book1.xlsx]Sheet3'!$B$13:$J$35,7,FALSE),
IFERROR(VLOOKUP(A1,'C:\Project\Test\[Book1.xlsx]Sheet4'!$B$13:$J$35,7,FALSE),
IFERROR(VLOOKUP(A1,'C:\Project\Test\[Book1.xlsx]Sheet5'!$B$13:$J$37,7,FALSE),
IFERROR(VLOOKUP(A1,'C:\Project\Test\[Book1.xlsx]Sheet6'!$B$13:$J$37,7,FALSE),
IFERROR(VLOOKUP(A1,'C:\Project\Test\[Book2.xlsx]Sheet1'!$B$13:$I$25,6,FALSE),
IFERROR(VLOOKUP(A1,'C:\Project\Test\[Book2.xlsx]Sheet2'!$B$13:$I$25,6,FALSE),
IFERROR(VLOOKUP(A1,'C:\Project\Test\[Book2.xlsx]Sheet3'!$B$13:$I$25,6,FALSE),
IFERROR(VLOOKUP(A1,'C:\Project\Test\[Book2.xlsx]Sheet4'!$B$13:$I$25,6,FALSE),
IFERROR(VLOOKUP(A1,'C:\Project\Test\[Book2.xlsx]Sheet5'!$B$13:$I$25,6,FALSE),
IFERROR(VLOOKUP(A1,'C:\Project\Test\[Book3.xlsx]Sheet1'!$J$15:$Q$25,6,FALSE),
IFERROR(VLOOKUP(A1,'C:\Project\Test\[Book3.xlsx]Sheet2'!$J$15:$Q$25,6,FALSE),
IFERROR(VLOOKUP(A1,'C:\Project\Test\[Book3.xlsx]Sheet3'!$J$15:$Q$25,6,FALSE),
IFERROR(VLOOKUP(A1,'C:\Project\Test\[Book3.xlsx]Sheet4'!$J$15:$Q$25,6,FALSE),
IFERROR(VLOOKUP(A1,'C:\Project\Test\[Book3.xlsx]Sheet5'!$J$15:$Q$25,6,FALSE),
IFERROR(VLOOKUP(A1,'C:\Project\Test\[Book4.xlsx]Sheet1'!$C$13:$N$34,9,FALSE),
IFERROR(VLOOKUP(A1,'C:\Project\Test\[Book4.xlsx]Sheet1'!$C$13:$N$35,9,FALSE),
IFERROR(VLOOKUP(A1,'C:\Project\Test\[Book4.xlsx]Sheet2'!$C$13:$N$35,9,FALSE),
IFERROR(VLOOKUP(A1,'C:\Project\Test\[Book4.xlsx]Sheet3'!$C$13:$N$35,9,FALSE),
IFERROR(VLOOKUP(A1,'C:\Project\Test\[Book4.xlsx]Sheet4'!$C$13:$N$35,9,FALSE),"")))))))))))))))))))))

Thank you in advance!