Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLookup / pull data from 1 sheet to another
have backup copy of a file that find need data lost in new sheet. Is there a
way / with VLookup in another workbook, to get data that finds the same symbol from one column, to get the data from 2nd column into new workbook: will then copy-paste special values to where they go.. thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLookup / pull data from 1 sheet to another
Maybe...
Debra Dalgleish has lots of notes on =vlookup() and =index(match()) he http://www.contextures.com/xlFunctions02.html (for =vlookup()) and http://www.contextures.com/xlFunctions03.html (for =index(match())) nastech wrote: have backup copy of a file that find need data lost in new sheet. Is there a way / with VLookup in another workbook, to get data that finds the same symbol from one column, to get the data from 2nd column into new workbook: will then copy-paste special values to where they go.. thanks. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
item # in one sheet want to pull data that matches from other tab | Excel Worksheet Functions | |||
Pull data from multiple sheet | Excel Worksheet Functions | |||
Pull data from another sheet based on certain criteria | Excel Discussion (Misc queries) | |||
How do I pull certain data from several worksheets in one sheet? | Excel Worksheet Functions | |||
pull data from sheet two, then fill in the data to sheet one (part | Excel Worksheet Functions |