I'm writing a vlookup that is supposed to check for a single value across multiple worksheets and return the information I specified. I already got it to work for references to multiple sheets within the workbook by specifying those sheets in the named range, SheetList. However, what I need it to do is look at multiple separate workbooks instead of multiple separate sheets within the same workbook. I know I can get it to work if I just put the workbook names in the named range that the formula uses, but I can't figure out what conventions or syntax to use to name those workbooks.
Solved by C. Y. in 19 mins