Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unprotect Workbook | Excel Discussion (Misc queries) | |||
What's the simplest way to copy data from another workbook | Excel Worksheet Functions | |||
#VALUE ! errorr for links to other workbook | Excel Worksheet Functions | |||
make hidden window or workbook visible without specify the name | Excel Worksheet Functions | |||
Stubborn toolbars in Excel | Excel Discussion (Misc queries) |