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

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.

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 wrote:

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

Thank you Dave,

This was very helpful.

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

"Dave Peterson" wrote:

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 wrote:

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