Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Vlook up for matching data in two seperate sheets
I am trying to match two seperate excel sheets into a new excel sheet. The
two sheets have a common column which is numberic. How do I append one sheeet to the other sheet, based on the common column. Thanks. |
#2
|
|||
|
|||
Do you mean you want to add the data from one worksheet to the same row of
another based on that common key. It sounds like =vlookup() or =index(match()) would work ok. Visit Debra Dalgleish's site: http://www.contextures.com/xlFunctions02.html for nice instructions. "funky via OfficeKB.com" wrote: I am trying to match two seperate excel sheets into a new excel sheet. The two sheets have a common column which is numberic. How do I append one sheeet to the other sheet, based on the common column. Thanks. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Seperate the data from the Cell | Excel Worksheet Functions | |||
Comparing sheets data | Excel Discussion (Misc queries) | |||
need funct to match data in 3 seperate spreadsheets column 1 to v. | Excel Discussion (Misc queries) | |||
Summary of data from 20 sheets | Excel Discussion (Misc queries) | |||
Help!: lead sheet data needs to fill appropriate subject sheets | Excel Worksheet Functions |