Hi all
I have two workbooks and need workbook 1 to look into workbook 2 and return contents in 8th column when A2 is matched,
But Workbook 2 has multiple sheets.
I have done the formula but it only searches the one named sheet and works fine.
My formula
=VLOOKUP(B2,'F:\BOP\New folder (2)\[Order Review Spreadsheet.xlsx]October 2021'!$A$1:$I$1000,8,0)
Is it possible without a very long formula to search all sheets in another workbook, fine the match and return to workbook1?
Thanks in advance.
I have two workbooks and need workbook 1 to look into workbook 2 and return contents in 8th column when A2 is matched,
But Workbook 2 has multiple sheets.
I have done the formula but it only searches the one named sheet and works fine.
My formula
=VLOOKUP(B2,'F:\BOP\New folder (2)\[Order Review Spreadsheet.xlsx]October 2021'!$A$1:$I$1000,8,0)
Is it possible without a very long formula to search all sheets in another workbook, fine the match and return to workbook1?
Thanks in advance.