View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Michael Dirksen Michael Dirksen is offline
external usenet poster
 
Posts: 1
Default assign dataset to matching dataset

Hello
Ich have two tables. The datasets of these tables should be assigned to
the matching dataset.
The identification of the dataset goes by the content of column A

That means : copy dataset1 from Table1 to Dataset xy if the content in
cell A2 matches
How can I programm this in Excel?

Thank you very much for your help!
MIchael


Table1
A B C
big 1 2
ltl 34 21
mid 4 5


Table2
A B C
mid 44 33
ltl 11 22


Endtable
A B C D E
ltl 1 2 11 22
big 34 21 44 33
mid 4 5