A couple of things....
First, and most importantly, INDIRECT() won't work when referencing another workbook that is closed.
Second, if you are okay with the other workbook being open, then ..... it is hard to tell if you even need VLOOKUP here. there is no column range reference in your sample, can you clarify what the VLOOKUP() would look like if you were not trying to use INDIRECT() and then what exact part is going to be Indirectly referenced and where that info is located.
Bookmarks