Index/Match to look up a value in one workbook and insert it into.

[Jean Marie]

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.

 

[Dave Peterson]

You can use =index(match()), but I think you may have as much trouble with that
as you have with =vlookup().

You may want to look at the formula tips that Debra Dalgleish shares:
http://www.contextures.com/xlFunctions02.html
and
http://www.contextures.com/xlFunctions03.html

Maybe it'll help.

 

[Jean Marie]

Thank you Dave,

This was very helpful.

... .. .. .. .. .. .. Kathy