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.
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.
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks