| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
looking up data in another worksheet
Is there any way to lookup values from another worksheet. The lookup array
is not sorted. I have tried offset and match but they did not work when the other workbook is closed. Can anyone help? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
looking up data in another worksheet
Debra Dalgleish has lots of notes:
http://www.contextures.com/xlFunctions02.html (for =vlookup()) and http://www.contextures.com/xlFunctions03.html (for =index(match())) and http://contextures.com/xlFunctions02.html#Trouble Enyaw wrote: Is there any way to lookup values from another worksheet. The lookup array is not sorted. I have tried offset and match but they did not work when the other workbook is closed. Can anyone help? -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
looking up data in another worksheet
Many Excel functions do not work if the linked workbook is closed.
Open it. Gord Dibben MS Excel MVP On Thu, 26 Nov 2009 04:58:06 -0800, Enyaw wrote: Is there any way to lookup values from another worksheet. The lookup array is not sorted. I have tried offset and match but they did not work when the other workbook is closed. Can anyone help? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pulling data into today's worksheet from yesterday's worksheet | Excel Discussion (Misc queries) | |||
| Using a Worksheet Form to add data to a separate worksheet databas | Excel Worksheet Functions | |||
| Using a column of data from 1 worksheet to extract data from another worksheet | Excel Worksheet Functions | |||
| How do I replicate data from primary worksheet to other worksheet | Excel Discussion (Misc queries) | |||
| Automatically pasting worksheet data to new worksheet with formulas | Excel Worksheet Functions | |||
Linear Mode
