compare and merge 2 sheets if columns same
 

Hello, Can someone please tell me how I can take data from 2 differen
spreedsheets and if 2 of the columns are the same in each sheet merg
data into a new sheet. Example

sheet 1
col a col b col c col d
name phone address note

sheet 2
col a col b
name phone

if the data is the same for the first 2 colums in both sheets I woul
like to have all data from sheet 1 put into a new sheet with just lik
data.

Thanks, Dan

--
danale
-----------------------------------------------------------------------
danalee's Profile: http://www.excelforum.com/member.php...fo&userid=1524
View this thread: http://www.excelforum.com/showthread.php?threadid=26872