lookup between two excel files

[dbashyam]

Hi,

I have two files with the following data:

File1:

Name                                Severity
userDefined                           3
dhmNoticeDegradedIO             3

File2:

Name                                  Severity
userDefined                          Warning
dhmNoticeDegradedIO             Warning
dhmNoticePFAEvent                 Critical
emergencyTrap                       Critical
alertTrap                                Major

I want to compare these two File1 and File2 and

Update File1 with the Severity of File2 in a separate field

So basically I am looking the output like this either in file1 itself or in a separate file.

 <table height="136" border="0" cellpadding="0" cellspacing="0" width="396"><colgroup><col style="mso-width-source:userset;mso-width-alt:5595;width:115pt" width="153">  <col style="width:48pt" width="64">  <col style="mso-width-source:userset;mso-width-alt:3218;width:66pt" width="88">  </colgroup><tbody><tr style="height:15.0pt" height="20">   <td class="xl65" style="height:15.0pt;width:115pt" height="20" width="153">Name</td>   <td class="xl65" style="border-left:none;width:48pt" width="64">Severity 
</td>   <td class="xl65" style="border-left:none;width:66pt" width="88">Trap Severity</td>  </tr>  <tr style="height:15.0pt" height="20">   <td class="xl66" style="height:15.0pt;border-top:none" height="20">userDefined</td>   <td class="xl67" style="border-top:none;border-left:none">3</td>   <td class="xl66" style="border-top:none;border-left:none">Warning</td>  </tr>  <tr style="height:15.0pt" height="20">   <td class="xl66" style="height:15.0pt;border-top:none" height="20">dhmNoticeDegradedIO</td>   <td class="xl67" style="border-top:none;border-left:none">3</td>   <td class="xl66" style="border-top:none;border-left:none">Warning</td>  </tr>  <tr style="height:15.0pt" height="20">   <td class="xl66" style="height:15.0pt;border-top:none" height="20">dhmNoticePFAEvent</td>   <td class="xl66" style="border-top:none;border-left:none">NA</td>   <td class="xl66" style="border-top:none;border-left:none">Critical</td>  </tr>  <tr style="height:15.0pt" height="20">   <td class="xl66" style="height:15.0pt;border-top:none" height="20">emergencyTrap</td>   <td class="xl66" style="border-top:none;border-left:none">NA</td>   <td class="xl66" style="border-top:none;border-left:none">Critical</td>  </tr>  <tr style="height:15.0pt" height="20">   <td class="xl66" style="height:15.0pt;border-top:none" height="20">alertTrap</td>   <td class="xl66" style="border-top:none;border-left:none">NA</td>   <td class="xl66" style="border-top:none;border-left:none">Major</td>  </tr> </tbody></table>

Any help on this please?

Thanks
Dinesh