How to Use Vlookup to merge 2 different worksheet

[Guest]

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]

=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()))