vlookup will do at least most of it. For vlookup to work, you need to sort the list by he lookup value.
Faisal Imtiaz wrote: > Use Excel Functions.... > (lookup & reference) VLOOKUP will do what you are needing. > > Regards > > > Faisal Imtiaz > Computer Office Solutions Inc. /SnappyDSL.net > Ph: (305) 663-5518 x 232 > -----Original Message----- > From: wireless-boun...@wispa.org [mailto:wireless-boun...@wispa.org] On > Behalf Of Gino Villarini > Sent: Wednesday, December 17, 2008 8:32 AM > To: WISPA General List > Subject: [WISPA] OT Excel Help > > Hello all I have 2 tables that have some velues in common (MAc Address), how > can I have Excel compare both tables and output a TAble with the results > showing matches of ESN's and other related table info? > > thanks > > > Gino A. Villarini > g...@aeronetpr.com > Aeronet Wireless Broadband Corp. > tel 787.273.4143 fax 787.273.4145 > > > > > ---------------------------------------------------------------------------- > ---- > WISPA Wants You! Join today! > http://signup.wispa.org/ > ---------------------------------------------------------------------------- > ---- > > WISPA Wireless List: wireless@wispa.org > > Subscribe/Unsubscribe: > http://lists.wispa.org/mailman/listinfo/wireless > > Archives: http://lists.wispa.org/pipermail/wireless/ > > > > > -------------------------------------------------------------------------------- > WISPA Wants You! Join today! > http://signup.wispa.org/ > -------------------------------------------------------------------------------- > > WISPA Wireless List: wireless@wispa.org > > Subscribe/Unsubscribe: > http://lists.wispa.org/mailman/listinfo/wireless > > Archives: http://lists.wispa.org/pipermail/wireless/ > > ------------------------------------------------------------------------ > > > No virus found in this incoming message. > Checked by AVG - http://www.avg.com > Version: 8.0.176 / Virus Database: 270.9.19/1853 - Release Date: 12/17/2008 > 8:31 AM > > -- Scott Reed Sr. Systems Engineer GAB Midwest 1-800-363-1544 x4000 -------------------------------------------------------------------------------- WISPA Wants You! Join today! http://signup.wispa.org/ -------------------------------------------------------------------------------- WISPA Wireless List: wireless@wispa.org Subscribe/Unsubscribe: http://lists.wispa.org/mailman/listinfo/wireless Archives: http://lists.wispa.org/pipermail/wireless/