ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I merge similar data across different excel worksheets? (https://www.excelbanter.com/excel-discussion-misc-queries/39702-how-do-i-merge-similar-data-across-different-excel-worksheets.html)

MK

How do I merge similar data across different excel worksheets?
 


Dave Peterson

If you have a unique key value that's on each sheet, you could use =vlookup() or
=index(match()).

You could look at Debra Dalgleish's site:
http://www.contextures.com/xlFunctions02.html
and
http://www.contextures.com/xlFunctions03.html

MK wrote:

--

Dave Peterson


All times are GMT +1. The time now is 01:24 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com