Hi Everyone,
I'm using this formula to get item name from another excel file when I enter the item code. Am wondering if it's possible to search in 2 files and retrieve the item name. Item code will be in any of the following file.
Product Master.xlsx
or
Archive Product Master.xlsx...