I need to be able to look up a value in a range on one Excel workbook using a
code in another workbook. Can I use Index/Match for this function; looking
for the value in one workbook and inserting it into another workbook?
Currently, I use Vlookup, which is cumbersom and awkward and prone to error.

Thank you.