Enter a extra sheet (where you need to run Vlookup) with all needed cells
pointing to your external source (=file and cell) and run your VLOOKUP an
this extra (now internal) sheet

"reno" wrote:

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.