Matching cells and transferring data between files

R

risman

New Member
Joined
Mar 8, 2009
Messages
1
[FONT=&quot]I have 2 files, each with a common ID number in Column A, that are set up as per below. For the rows in File 1 that have a Provider ID1 in Column A that is the same as Provider ID1 in Column A of File 2, and that show UNKNOWN in Column B of File 1, I want to be able to add columns for Provider ID2 (Column B of File 2, which you’ll notice is in the row below Provider ID1), the Office Number (Column C, File 2), and replace UNKNOWN in Column B of File 1 with all of the Name and Address information in Column D, File 2 (which sometimes spans 3 rows, sometimes 4). I am using Excel 2007. Is there a way to do this?[/FONT]
<table class="MsoNormalTable" style="width: 320.25pt; margin-left: 4.65pt; border-collapse: collapse;" width="427" border="0" cellpadding="0" cellspacing="0"> <tbody><tr style="height: 15pt;"> <td style="padding: 0in 5.4pt; width: 48.7pt; height: 15pt;" valign="bottom" width="65" nowrap="nowrap"> File 1<o:p></o:p>
</td> <td colspan="2" style="padding: 0in 5.4pt; width: 67.5pt; height: 15pt;" valign="bottom" width="90" nowrap="nowrap">
</td> <td colspan="3" style="padding: 0in 5.4pt; width: 108.8pt; height: 15pt;" valign="bottom" width="145" nowrap="nowrap">
</td> <td style="padding: 0in 5.4pt; width: 49.2pt; height: 15pt;" valign="bottom" width="66" nowrap="nowrap">
</td> <td style="padding: 0in 5.4pt; width: 44.2pt; height: 15pt;" valign="bottom" width="59" nowrap="nowrap">
</td> <td style="border: medium none ; padding: 0in;" width="2">
</td> </tr> <tr style="height: 15pt;"> <td style="border-style: solid none none solid; border-color: black -moz-use-text-color -moz-use-text-color black; border-width: 1pt medium medium 1pt; padding: 0in 5.4pt; width: 48.7pt; height: 15pt;" valign="bottom" width="65" nowrap="nowrap">
A<o:p></o:p>​
</td> <td colspan="2" style="border-style: solid none none solid; border-color: black -moz-use-text-color -moz-use-text-color black; border-width: 1pt medium medium 1pt; padding: 0in 5.4pt; width: 67.5pt; height: 15pt;" valign="bottom" width="90" nowrap="nowrap">
B<o:p></o:p>​
</td> <td colspan="3" style="border-style: solid none none solid; border-color: black -moz-use-text-color -moz-use-text-color black; border-width: 1pt medium medium 1pt; padding: 0in 5.4pt; width: 108.8pt; height: 15pt;" valign="bottom" width="145" nowrap="nowrap">
C<o:p></o:p>​
</td> <td style="border-style: solid none none solid; border-color: black -moz-use-text-color -moz-use-text-color black; border-width: 1pt medium medium 1pt; padding: 0in 5.4pt; width: 49.2pt; height: 15pt;" valign="bottom" width="66" nowrap="nowrap">
D<o:p></o:p>​
</td> <td style="border-style: solid solid none; border-color: black black -moz-use-text-color; border-width: 1pt 1pt medium; padding: 0in 5.4pt; width: 44.2pt; height: 15pt;" valign="bottom" width="59" nowrap="nowrap">
E<o:p></o:p>​
</td> <td style="border: medium none ; padding: 0in;" width="2">
</td> </tr> <tr style="height: 15pt;"> <td style="border-style: solid none none solid; border-color: black -moz-use-text-color -moz-use-text-color black; border-width: 1pt medium medium 1pt; padding: 0in 5.4pt; width: 48.7pt; height: 15pt;" valign="bottom" width="65" nowrap="nowrap">
Provider ID1<o:p></o:p>​
</td> <td colspan="2" style="border-style: solid none none solid; border-color: black -moz-use-text-color -moz-use-text-color black; border-width: 1pt medium medium 1pt; padding: 0in 5.4pt; width: 67.5pt; height: 15pt;" valign="bottom" width="90" nowrap="nowrap">
Name<o:p></o:p>​
</td> <td colspan="3" style="border-style: solid none none solid; border-color: black -moz-use-text-color -moz-use-text-color black; border-width: 1pt medium medium 1pt; padding: 0in 5.4pt; width: 108.8pt; height: 15pt;" valign="bottom" width="145" nowrap="nowrap">
Address<o:p></o:p>​
</td> <td style="border-style: solid none none solid; border-color: black -moz-use-text-color -moz-use-text-color black; border-width: 1pt medium medium 1pt; padding: 0in 5.4pt; width: 49.2pt; height: 15pt;" valign="bottom" width="66" nowrap="nowrap">
Program Code<o:p></o:p>​
</td> <td style="border-style: solid solid none; border-color: black black -moz-use-text-color; border-width: 1pt 1pt medium; padding: 0in 5.4pt; width: 44.2pt; height: 15pt;" valign="bottom" width="59" nowrap="nowrap">
Total<o:p></o:p>​
</td> <td style="border: medium none ; padding: 0in;" width="2">
</td> </tr> <tr style="height: 15pt;"> <td style="border-style: solid none none solid; border-color: black -moz-use-text-color -moz-use-text-color black; border-width: 1pt medium medium 1pt; padding: 0in 5.4pt; width: 48.7pt; height: 15pt;" valign="bottom" width="65" nowrap="nowrap"> G90179 <o:p></o:p>
</td> <td colspan="2" style="border-style: solid none none solid; border-color: black -moz-use-text-color -moz-use-text-color black; border-width: 1pt medium medium 1pt; padding: 0in 5.4pt; width: 67.5pt; height: 15pt;" valign="bottom" width="90" nowrap="nowrap"> UNKNOWN <o:p></o:p>
</td> <td colspan="3" style="border-style: solid none none solid; border-color: black -moz-use-text-color -moz-use-text-color black; border-width: 1pt medium medium 1pt; padding: 0in 5.4pt; width: 108.8pt; height: 15pt;" valign="bottom" width="145" nowrap="nowrap"> (blank)<o:p></o:p>
</td> <td style="border-style: solid none none solid; border-color: black -moz-use-text-color -moz-use-text-color black; border-width: 1pt medium medium 1pt; padding: 0in 5.4pt; width: 49.2pt; height: 15pt;" valign="bottom" width="66" nowrap="nowrap"> 00<o:p></o:p>
</td> <td style="border-style: solid solid none; border-color: black black -moz-use-text-color; border-width: 1pt 1pt medium; padding: 0in 5.4pt; width: 44.2pt; height: 15pt;" valign="bottom" width="59" nowrap="nowrap">
17833<o:p></o:p>​
</td> <td style="border: medium none ; padding: 0in;" width="2">
</td> </tr> <tr style="height: 15pt;"> <td style="border-style: solid none none solid; border-color: black -moz-use-text-color -moz-use-text-color black; border-width: 1pt medium medium 1pt; padding: 0in 5.4pt; width: 48.7pt; height: 15pt;" valign="bottom" width="65" nowrap="nowrap"> B24464 <o:p></o:p>
</td> <td colspan="2" style="border-style: solid none none solid; border-color: black -moz-use-text-color -moz-use-text-color black; border-width: 1pt medium medium 1pt; padding: 0in 5.4pt; width: 67.5pt; height: 15pt;" valign="bottom" width="90" nowrap="nowrap"> UNKNOWN <o:p></o:p>
</td> <td colspan="3" style="border-style: solid none none solid; border-color: black -moz-use-text-color -moz-use-text-color black; border-width: 1pt medium medium 1pt; padding: 0in 5.4pt; width: 108.8pt; height: 15pt;" valign="bottom" width="145" nowrap="nowrap"> (blank)<o:p></o:p>
</td> <td style="border-style: solid none none solid; border-color: black -moz-use-text-color -moz-use-text-color black; border-width: 1pt medium medium 1pt; padding: 0in 5.4pt; width: 49.2pt; height: 15pt;" valign="bottom" width="66" nowrap="nowrap"> 00<o:p></o:p>
</td> <td style="border-style: solid solid none; border-color: black black -moz-use-text-color; border-width: 1pt 1pt medium; padding: 0in 5.4pt; width: 44.2pt; height: 15pt;" valign="bottom" width="59" nowrap="nowrap">
16705<o:p></o:p>​
</td> <td style="border: medium none ; padding: 0in;" width="2">
</td> </tr> <tr style="height: 15pt;"> <td style="border-style: solid none none solid; border-color: black -moz-use-text-color -moz-use-text-color black; border-width: 1pt medium medium 1pt; padding: 0in 5.4pt; width: 48.7pt; height: 15pt;" valign="bottom" width="65" nowrap="nowrap"> G90875 <o:p></o:p>
</td> <td colspan="2" style="border-style: solid none none solid; border-color: black -moz-use-text-color -moz-use-text-color black; border-width: 1pt medium medium 1pt; padding: 0in 5.4pt; width: 67.5pt; height: 15pt;" valign="bottom" width="90" nowrap="nowrap"> UNKNOWN <o:p></o:p>
</td> <td colspan="3" style="border-style: solid none none solid; border-color: black -moz-use-text-color -moz-use-text-color black; border-width: 1pt medium medium 1pt; padding: 0in 5.4pt; width: 108.8pt; height: 15pt;" valign="bottom" width="145" nowrap="nowrap"> (blank)<o:p></o:p>
</td> <td style="border-style: solid none none solid; border-color: black -moz-use-text-color -moz-use-text-color black; border-width: 1pt medium medium 1pt; padding: 0in 5.4pt; width: 49.2pt; height: 15pt;" valign="bottom" width="66" nowrap="nowrap"> 00<o:p></o:p>
</td> <td style="border-style: solid solid none; border-color: black black -moz-use-text-color; border-width: 1pt 1pt medium; padding: 0in 5.4pt; width: 44.2pt; height: 15pt;" valign="bottom" width="59" nowrap="nowrap">
7776<o:p></o:p>​
</td> <td style="border: medium none ; padding: 0in;" width="2">
</td> </tr> <tr style="height: 15pt;"> <td style="border-style: solid none none solid; border-color: black -moz-use-text-color -moz-use-text-color black; border-width: 1pt medium medium 1pt; padding: 0in 5.4pt; width: 48.7pt; height: 15pt;" valign="bottom" width="65" nowrap="nowrap"> G92150 <o:p></o:p>
</td> <td colspan="2" style="border-style: solid none none solid; border-color: black -moz-use-text-color -moz-use-text-color black; border-width: 1pt medium medium 1pt; padding: 0in 5.4pt; width: 67.5pt; height: 15pt;" valign="bottom" width="90" nowrap="nowrap"> UNKNOWN <o:p></o:p>
</td> <td colspan="3" style="border-style: solid none none solid; border-color: black -moz-use-text-color -moz-use-text-color black; border-width: 1pt medium medium 1pt; padding: 0in 5.4pt; width: 108.8pt; height: 15pt;" valign="bottom" width="145" nowrap="nowrap"> (blank)<o:p></o:p>
</td> <td style="border-style: solid none none solid; border-color: black -moz-use-text-color -moz-use-text-color black; border-width: 1pt medium medium 1pt; padding: 0in 5.4pt; width: 49.2pt; height: 15pt;" valign="bottom" width="66" nowrap="nowrap"> 00<o:p></o:p>
</td> <td style="border-style: solid solid none; border-color: black black -moz-use-text-color; border-width: 1pt 1pt medium; padding: 0in 5.4pt; width: 44.2pt; height: 15pt;" valign="bottom" width="59" nowrap="nowrap">
7754<o:p></o:p>​
</td> <td style="border: medium none ; padding: 0in;" width="2">
</td> </tr> <tr style="height: 15pt;"> <td style="border: 1pt solid windowtext; padding: 0in 5.4pt; width: 48.7pt; height: 15pt;" valign="bottom" width="65" nowrap="nowrap"> G93677 <o:p></o:p>
</td> <td colspan="2" style="border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0in 5.4pt; width: 67.5pt; height: 15pt;" valign="bottom" width="90" nowrap="nowrap"> UNKNOWN <o:p></o:p>
</td> <td colspan="3" style="border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0in 5.4pt; width: 108.8pt; height: 15pt;" valign="bottom" width="145" nowrap="nowrap"> (blank)<o:p></o:p>
</td> <td style="border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0in 5.4pt; width: 49.2pt; height: 15pt;" valign="bottom" width="66" nowrap="nowrap"> 00<o:p></o:p>
</td> <td style="border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0in 5.4pt; width: 44.2pt; height: 15pt;" valign="bottom" width="59" nowrap="nowrap">
7290<o:p></o:p>​
</td> <td style="border: medium none ; padding: 0in;" width="2">
</td> </tr> <tr style="height: 15pt;"> <td colspan="2" style="padding: 0in 5.4pt; width: 50.25pt; height: 15pt;" valign="bottom" width="67" nowrap="nowrap"> <o:p> </o:p>
File 2<o:p></o:p>
</td> <td colspan="2" style="padding: 0in 5.4pt; width: 66.6pt; height: 15pt;" valign="bottom" width="89" nowrap="nowrap">
</td> <td style="padding: 0in 5.4pt; width: 47.6pt; height: 15pt;" valign="bottom" width="63" nowrap="nowrap">
</td> <td colspan="4" style="padding: 0in 5.4pt; width: 155.8pt; height: 15pt;" valign="bottom" width="208" nowrap="nowrap">
</td> </tr> <tr style="height: 15pt;"> <td colspan="2" style="border: 1pt solid windowtext; padding: 0in 5.4pt; width: 50.25pt; height: 15pt;" valign="bottom" width="67" nowrap="nowrap">
A<o:p></o:p>​
</td> <td colspan="2" style="border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0in 5.4pt; width: 66.6pt; height: 15pt;" valign="bottom" width="89" nowrap="nowrap">
B<o:p></o:p>​
</td> <td style="border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0in 5.4pt; width: 47.6pt; height: 15pt;" valign="bottom" width="63" nowrap="nowrap">
C<o:p></o:p>​
</td> <td colspan="4" style="border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0in 5.4pt; width: 155.8pt; height: 15pt;" valign="bottom" width="208" nowrap="nowrap">
D<o:p></o:p>​
</td> </tr> <tr style="height: 15pt;"> <td colspan="2" style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 50.25pt; height: 15pt;" valign="bottom" width="67" nowrap="nowrap">
Provider ID1<o:p></o:p>​
</td> <td colspan="2" style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 66.6pt; height: 15pt;" valign="bottom" width="89" nowrap="nowrap">
Provider ID2<o:p></o:p>​
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 47.6pt; height: 15pt;" valign="bottom" width="63" nowrap="nowrap">
Office Number<o:p></o:p>​
</td> <td colspan="4" style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 155.8pt; height: 15pt;" valign="bottom" width="208" nowrap="nowrap">
Name & Address<o:p></o:p>​
</td> </tr> <tr style="height: 15pt;"> <td colspan="2" style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 50.25pt; height: 15pt;" valign="bottom" width="67" nowrap="nowrap"> B00011<o:p></o:p>
</td> <td colspan="2" style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 66.6pt; height: 15pt;" valign="bottom" width="89" nowrap="nowrap"> <o:p></o:p>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 47.6pt; height: 15pt;" valign="bottom" width="63" nowrap="nowrap"> <o:p></o:p>
</td> <td colspan="4" style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 155.8pt; height: 15pt;" valign="bottom" width="208" nowrap="nowrap"> CHONG, TONY<o:p></o:p>
</td> </tr> <tr style="height: 15pt;"> <td colspan="2" style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 50.25pt; height: 15pt;" valign="bottom" width="67" nowrap="nowrap"> <o:p></o:p>
</td> <td colspan="2" style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 66.6pt; height: 15pt;" valign="bottom" width="89" nowrap="nowrap">
1619158367<o:p></o:p>​
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 47.6pt; height: 15pt;" valign="bottom" width="63" nowrap="nowrap">
1<o:p></o:p>​
</td> <td colspan="4" style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 155.8pt; height: 15pt;" valign="bottom" width="208" nowrap="nowrap"> 99999 SHERMAN WAY<o:p></o:p>
</td> </tr> <tr style="height: 15pt;"> <td colspan="2" style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 50.25pt; height: 15pt;" valign="bottom" width="67" nowrap="nowrap"> <o:p></o:p>
</td> <td colspan="2" style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 66.6pt; height: 15pt;" valign="bottom" width="89" nowrap="nowrap"> <o:p></o:p>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 47.6pt; height: 15pt;" valign="bottom" width="63" nowrap="nowrap"> <o:p></o:p>
</td> <td colspan="4" style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 155.8pt; height: 15pt;" valign="bottom" width="208" nowrap="nowrap"> STE 260<o:p></o:p>
</td> </tr> <tr style="height: 15pt;"> <td colspan="2" style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 50.25pt; height: 15pt;" valign="bottom" width="67" nowrap="nowrap"> <o:p></o:p>
</td> <td colspan="2" style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 66.6pt; height: 15pt;" valign="bottom" width="89" nowrap="nowrap"> <o:p></o:p>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 47.6pt; height: 15pt;" valign="bottom" width="63" nowrap="nowrap"> <o:p></o:p>
</td> <td colspan="4" style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 155.8pt; height: 15pt;" valign="bottom" width="208" nowrap="nowrap"> VAN NUYS CA 91405-2285<o:p></o:p>
</td> </tr> <tr style="height: 15pt;"> <td colspan="2" style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 50.25pt; height: 15pt;" valign="bottom" width="67" nowrap="nowrap"> <o:p></o:p>
</td> <td colspan="2" style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 66.6pt; height: 15pt;" valign="bottom" width="89" nowrap="nowrap"> <o:p></o:p>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 47.6pt; height: 15pt;" valign="bottom" width="63" nowrap="nowrap"> <o:p></o:p>
</td> <td colspan="4" style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 155.8pt; height: 15pt;" valign="bottom" width="208" nowrap="nowrap"> <o:p></o:p>
</td> </tr> <tr style="height: 15pt;"> <td colspan="2" style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 50.25pt; height: 15pt;" valign="bottom" width="67" nowrap="nowrap"> B09346<o:p></o:p>
</td> <td colspan="2" style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 66.6pt; height: 15pt;" valign="bottom" width="89" nowrap="nowrap"> <o:p></o:p>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 47.6pt; height: 15pt;" valign="bottom" width="63" nowrap="nowrap"> <o:p></o:p>
</td> <td colspan="4" style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 155.8pt; height: 15pt;" valign="bottom" width="208" nowrap="nowrap"> GIDDIN, CHARLES M<o:p></o:p>
</td> </tr> <tr style="height: 15pt;"> <td colspan="2" style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 50.25pt; height: 15pt;" valign="bottom" width="67" nowrap="nowrap"> <o:p></o:p>
</td> <td colspan="2" style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 66.6pt; height: 15pt;" valign="bottom" width="89" nowrap="nowrap">
5348447367<o:p></o:p>​
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 47.6pt; height: 15pt;" valign="bottom" width="63" nowrap="nowrap">
1<o:p></o:p>​
</td> <td colspan="4" style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 155.8pt; height: 15pt;" valign="bottom" width="208" nowrap="nowrap"> 888 LANDIS AVE<o:p></o:p>
</td> </tr> <tr style="height: 15pt;"> <td colspan="2" style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 50.25pt; height: 15pt;" valign="bottom" width="67" nowrap="nowrap"> <o:p></o:p>
</td> <td colspan="2" style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 66.6pt; height: 15pt;" valign="bottom" width="89" nowrap="nowrap"> <o:p></o:p>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 47.6pt; height: 15pt;" valign="bottom" width="63" nowrap="nowrap"> <o:p></o:p>
</td> <td colspan="4" style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 155.8pt; height: 15pt;" valign="bottom" width="208" nowrap="nowrap"> CHULA VISTA CA 91910-2609<o:p></o:p>
</td> </tr> <tr style="height: 15pt;"> <td colspan="2" style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 50.25pt; height: 15pt;" valign="bottom" width="67" nowrap="nowrap"> <o:p></o:p>
</td> <td colspan="2" style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 66.6pt; height: 15pt;" valign="bottom" width="89" nowrap="nowrap"> <o:p></o:p>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 47.6pt; height: 15pt;" valign="bottom" width="63" nowrap="nowrap"> <o:p></o:p>
</td> <td colspan="4" style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 155.8pt; height: 15pt;" valign="bottom" width="208" nowrap="nowrap"> <o:p></o:p>
</td> </tr> <tr style="height: 15pt;"> <td colspan="2" style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 50.25pt; height: 15pt;" valign="bottom" width="67" nowrap="nowrap"> B10176<o:p></o:p>
</td> <td colspan="2" style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 66.6pt; height: 15pt;" valign="bottom" width="89" nowrap="nowrap"> <o:p></o:p>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 47.6pt; height: 15pt;" valign="bottom" width="63" nowrap="nowrap"> <o:p></o:p>
</td> <td colspan="4" style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 155.8pt; height: 15pt;" valign="bottom" width="208" nowrap="nowrap"> RiCE, HERMAN H<o:p></o:p>
</td> </tr> <tr style="height: 15pt;"> <td colspan="2" style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 50.25pt; height: 15pt;" valign="bottom" width="67" nowrap="nowrap"> <o:p></o:p>
</td> <td colspan="2" style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 66.6pt; height: 15pt;" valign="bottom" width="89" nowrap="nowrap"> <o:p></o:p>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 47.6pt; height: 15pt;" valign="bottom" width="63" nowrap="nowrap">
2<o:p></o:p>​
</td> <td colspan="4" style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 155.8pt; height: 15pt;" valign="bottom" width="208" nowrap="nowrap"> A-1 OFFICE<o:p></o:p>
</td> </tr> <tr style="height: 15pt;"> <td colspan="2" style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 50.25pt; height: 15pt;" valign="bottom" width="67" nowrap="nowrap"> <o:p></o:p>
</td> <td colspan="2" style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 66.6pt; height: 15pt;" valign="bottom" width="89" nowrap="nowrap"> <o:p></o:p>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 47.6pt; height: 15pt;" valign="bottom" width="63" nowrap="nowrap"> <o:p></o:p>
</td> <td colspan="4" style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 155.8pt; height: 15pt;" valign="bottom" width="208" nowrap="nowrap"> 12345 SEGO PALM DR #B9<o:p></o:p>
</td> </tr> <tr style="height: 15pt;"> <td colspan="2" style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 50.25pt; height: 15pt;" valign="bottom" width="67" nowrap="nowrap"> <o:p></o:p>
</td> <td colspan="2" style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 66.6pt; height: 15pt;" valign="bottom" width="89" nowrap="nowrap"> <o:p></o:p>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 47.6pt; height: 15pt;" valign="bottom" width="63" nowrap="nowrap"> <o:p></o:p>
</td> <td colspan="4" style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 155.8pt; height: 15pt;" valign="bottom" width="208" nowrap="nowrap"> CATHEDRAL CITY CA 92234-6653<o:p></o:p>
</td> </tr> <tr style="height: 15pt;"> <td colspan="2" style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 50.25pt; height: 15pt;" valign="bottom" width="67" nowrap="nowrap"> <o:p></o:p>
</td> <td colspan="2" style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 66.6pt; height: 15pt;" valign="bottom" width="89" nowrap="nowrap"> <o:p></o:p>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 47.6pt; height: 15pt;" valign="bottom" width="63" nowrap="nowrap"> <o:p></o:p>
</td> <td colspan="4" style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 155.8pt; height: 15pt;" valign="bottom" width="208" nowrap="nowrap"> <o:p></o:p>
</td> </tr> <tr style="height: 15pt;"> <td colspan="2" style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 50.25pt; height: 15pt;" valign="bottom" width="67" nowrap="nowrap"> B10455<o:p></o:p>
</td> <td colspan="2" style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 66.6pt; height: 15pt;" valign="bottom" width="89" nowrap="nowrap"> <o:p></o:p>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 47.6pt; height: 15pt;" valign="bottom" width="63" nowrap="nowrap"> <o:p></o:p>
</td> <td colspan="4" style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 155.8pt; height: 15pt;" valign="bottom" width="208" nowrap="nowrap"> KEZER, CHRIS R<o:p></o:p>
</td> </tr> <tr style="height: 15pt;"> <td colspan="2" style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 50.25pt; height: 15pt;" valign="bottom" width="67" nowrap="nowrap"> <o:p></o:p>
</td> <td colspan="2" style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 66.6pt; height: 15pt;" valign="bottom" width="89" nowrap="nowrap"> <o:p></o:p>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 47.6pt; height: 15pt;" valign="bottom" width="63" nowrap="nowrap">
1<o:p></o:p>​
</td> <td colspan="4" style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 155.8pt; height: 15pt;" valign="bottom" width="208" nowrap="nowrap"> 777 W LODI AVE<o:p></o:p>
</td> </tr> <tr style="height: 15pt;"> <td colspan="2" style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 50.25pt; height: 15pt;" valign="bottom" width="67" nowrap="nowrap"> <o:p></o:p>
</td> <td colspan="2" style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 66.6pt; height: 15pt;" valign="bottom" width="89" nowrap="nowrap"> <o:p></o:p>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 47.6pt; height: 15pt;" valign="bottom" width="63" nowrap="nowrap"> <o:p></o:p>
</td> <td colspan="4" style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 155.8pt; height: 15pt;" valign="bottom" width="208" nowrap="nowrap"> LODI CA 95240-3302<o:p></o:p>
</td> </tr> <tr style="height: 15pt;"> <td colspan="2" style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 50.25pt; height: 15pt;" valign="bottom" width="67" nowrap="nowrap"> <o:p></o:p>
</td> <td colspan="2" style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 66.6pt; height: 15pt;" valign="bottom" width="89" nowrap="nowrap"> <o:p></o:p>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 47.6pt; height: 15pt;" valign="bottom" width="63" nowrap="nowrap"> <o:p></o:p>
</td> <td colspan="4" style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 155.8pt; height: 15pt;" valign="bottom" width="208" nowrap="nowrap"> <o:p></o:p>
</td> </tr> <tr style="height: 15pt;"> <td colspan="2" style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 50.25pt; height: 15pt;" valign="bottom" width="67" nowrap="nowrap"> B10733<o:p></o:p>
</td> <td colspan="2" style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 66.6pt; height: 15pt;" valign="bottom" width="89" nowrap="nowrap"> <o:p></o:p>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 47.6pt; height: 15pt;" valign="bottom" width="63" nowrap="nowrap"> <o:p></o:p>
</td> <td colspan="4" style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 155.8pt; height: 15pt;" valign="bottom" width="208" nowrap="nowrap"> ISCAR, EDWARD K<o:p></o:p>
</td> </tr> <tr style="height: 15pt;"> <td colspan="2" style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 50.25pt; height: 15pt;" valign="bottom" width="67" nowrap="nowrap"> <o:p></o:p>
</td> <td colspan="2" style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 66.6pt; height: 15pt;" valign="bottom" width="89" nowrap="nowrap"> <o:p></o:p>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 47.6pt; height: 15pt;" valign="bottom" width="63" nowrap="nowrap">
1<o:p></o:p>​
</td> <td colspan="4" style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 155.8pt; height: 15pt;" valign="bottom" width="208" nowrap="nowrap"> 1111 K ST #206<o:p></o:p>
</td> </tr> <tr style="height: 15pt;"> <td colspan="2" style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 50.25pt; height: 15pt;" valign="bottom" width="67" nowrap="nowrap"> <o:p></o:p>
</td> <td colspan="2" style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 66.6pt; height: 15pt;" valign="bottom" width="89" nowrap="nowrap"> <o:p></o:p>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 47.6pt; height: 15pt;" valign="bottom" width="63" nowrap="nowrap"> <o:p></o:p>
</td> <td colspan="4" style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 155.8pt; height: 15pt;" valign="bottom" width="208" nowrap="nowrap"> SACRAMENTO CA 95816-5114<o:p></o:p>
</td> </tr> <!--[if !supportMisalignedColumns]--> <tr height="0"> <td style="border: medium none ;" width="66">
</td> <td style="border: medium none ;" width="2">
</td> <td style="border: medium none ;" width="88">
</td> <td style="border: medium none ;" width="1">
</td> <td style="border: medium none ;" width="65">
</td> <td style="border: medium none ;" width="81">
</td> <td style="border: medium none ;" width="66">
</td> <td style="border: medium none ;" width="59">
</td> <td style="border: medium none ;" width="2">
</td> </tr> <!--[endif]--> </tbody></table> <o:p> </o:p>
 

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college
Sort by date Sort by votes
Hi, I'm pretty new at this myself, but I did have a project similar to your's and was given a little help using an Index statement. What I did was take my file #2 and did a "Copy & Move" to my file 1 so I would be working with two tabs in the same workbook instead of two separate files. I needed to compare 2008 terms (Column B,Row 2, Sheet 2) to 2009 Terms (Column B,Row 2, Sheet 1) and return a value of either "Updated" if it matched, and "No Change" if it didn't to Column C. My unique identifier was a vendor number in column A of both sheets.

In column D, I put this code:
=INDEX(SHEET2!$B$2:$B$300,MATCH(SHEET1!$A$2:$A$600,SHEET2!$A$2:$A$600,0)),""

Good luck.
 
Upvote 0
You must log in or register to reply here.

Similar threads

A
  • Question
VBA - Automatically Break the Line in HTML format.
Replies
7
Views
445
Attrazion
A
G
  • Question
Using Excel formula to create HTML code text referencing specific cells
Replies
0
Views
449
gvsumich
G
E
  • Question
VBA for Web Scraping help
Replies
0
Views
262
epactheactor
E
C
  • Solved
Excel 2016 32bit VBA Pulling info from Website to Sheet
Replies
2
Views
688
CrashOD
C
A
  • Solved
Calendar issue
Replies
1
Views
365
AndyEd
A

Forum statistics

Threads
1,203,059
Messages
6,053,292
Members
444,650
Latest member
bookendinSA

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top