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