I am assuming you could only do a VLOOKUP from a worksheet in the same
workbook... is this correct?

(For example, if my lookup array is updated and the values change, do I need
to replace my old lookup table with the new one or can I link it from outside
the workbook?)