how do you use data from another workbook in the lookup function of another
workbook? used to be that you could just point to an open workbook, point to
the drop down named range and select the name and jump back to finish your
formula in your orig workbook.
Bookmarks