Vlookup
 

what is the easiest way to use a lookup from one workbook and fill data into
another workbook? it used to be a long time ago that you could simply point
to the second workbook, go to the drop down of named ranges, and point to
that named range but no longer.
suggestions please