INDIRECT Reference to Named Range in another Workbook

[indigowave]

I have had to break apart a workbook due to size limitations. It's spreadsheet of baseball statistics, so the I have a named range for each pitcher, and within the range are rows for each performance. On my main sheet, I use a VLOOKUP(todays' date, INDIRECT(pitcher name), 30, true) formula to pull the previous pitching performance. When I moved the sheet of named ranges to its own workbook, I now get #REF errors. Is there a way around this?

Thanks,

Jeff

 

[just_jon]

Ekim nows a lot, as does Aladin -- what's up?