Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to Use Vlookup to merge 2 different worksheet
I was told that I coudl use Vlookup to create a formula to merge 2 different
Excel worsheets into one with most updated data. For instance, I created two worksheets with similiar columns but the worksheet n#2 has most recent data. How can I do that? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to Use Vlookup to merge 2 different worksheet
=vlookup() relies on that key column being the first column of the lookup
range. If you ever want to bring back something to the left of that key column, you could use =index(match()). Debra Dalgleish has some notes: http://www.contextures.com/xlFunctions02.html (for =vlookup()) and http://www.contextures.com/xlFunctions03.html (for =index(match())) HRclerical wrote: I was told that I coudl use Vlookup to create a formula to merge 2 different Excel worsheets into one with most updated data. For instance, I created two worksheets with similiar columns but the worksheet n#2 has most recent data. How can I do that? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Regarding updating 1000 values using vlookup from another worksheet | Excel Worksheet Functions | |||
How do I get ONLY new info from 1 Worksheet to another automatical | Excel Worksheet Functions | |||
Merge one row and header of a sixty-five row worksheet | Excel Discussion (Misc queries) | |||
Vlookup in a second worksheet | Excel Worksheet Functions | |||
Saving worksheet so that merge cells work in previous versions | Excel Worksheet Functions |