need formula for comparison

[cotlodjimmy]

Im a newbie at this so please bear with me

I have a large spreadsheet of parts for my employer. there are over 8000 rows of data.

It looks like this


<TABLE style="WIDTH: 781pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=1040 border=0><COLGROUP><COL style="WIDTH: 48pt; mso-width-source: userset; mso-width-alt: 1170" width=64><COL style="WIDTH: 57pt; mso-width-source: userset; mso-width-alt: 1389" width=76><COL style="WIDTH: 210pt; mso-width-source: userset; mso-width-alt: 5120" width=280><COL style="WIDTH: 122pt; mso-width-source: userset; mso-width-alt: 2962" width=162><COL style="WIDTH: 60pt; mso-width-source: userset; mso-width-alt: 1462" width=80><COL style="WIDTH: 53pt; mso-width-source: userset; mso-width-alt: 1280" width=70><COL style="WIDTH: 33pt; mso-width-source: userset; mso-width-alt: 804" width=44><COL style="WIDTH: 198pt; mso-width-source: userset; mso-width-alt: 4827" width=264><TBODY><TR style="HEIGHT: 15.75pt" height=21><TD class=xl90 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15.75pt; BACKGROUND-COLOR: yellow" width=64 height=21>PP #</TD><TD class=xl90 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 57pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow" width=76>Vendor #</TD><TD class=xl90 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 210pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow" width=280>Material Description</TD><TD class=xl90 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 122pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow" width=162>ZE#</TD><TD class=xl90 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 60pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow" width=80>Location</TD><TD class=xl89 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 53pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=70>Material</TD><TD class=xl89 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 33pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=44>Bin</TD><TD class=xl92 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 198pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=264>Material Description</TD></TR></TBODY></TABLE>
<TABLE style="WIDTH: 781pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=1040 border=0><COLGROUP><COL style="WIDTH: 48pt; mso-width-source: userset; mso-width-alt: 1170" width=64><COL style="WIDTH: 57pt; mso-width-source: userset; mso-width-alt: 1389" width=76><COL style="WIDTH: 210pt; mso-width-source: userset; mso-width-alt: 5120" width=280><COL style="WIDTH: 122pt; mso-width-source: userset; mso-width-alt: 2962" width=162><COL style="WIDTH: 60pt; mso-width-source: userset; mso-width-alt: 1462" width=80><COL style="WIDTH: 53pt; mso-width-source: userset; mso-width-alt: 1280" width=70><COL style="WIDTH: 33pt; mso-width-source: userset; mso-width-alt: 804" width=44><COL style="WIDTH: 198pt; mso-width-source: userset; mso-width-alt: 4827" width=264><TBODY><TR style="PAGE-BREAK-BEFORE: always; HEIGHT: 30pt" height=40><TD class=xl93 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 30pt; BACKGROUND-COLOR: yellow" width=64 height=40>12-0460</TD><TD class=xl88 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 57pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow" width=76>MDC-4MP-FW </TD><TD class=xl87 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 210pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow" width=280>MALE CONNECTOR</TD><TD class=xl91 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 122pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow" width=162>ZE0141837</TD><TD class=xl94 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 60pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow" width=80>AA34</TD><TD class=xl89 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 53pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=70>ZE0141837</TD><TD class=xl89 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 33pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=44>AA34</TD><TD class=xl89 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 198pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=264>CONNECTOR,MENCOM CORP,#MDC4MPFW,MALE CON</TD></TR></TBODY></TABLE>

I am trying to match the Vendor Number in column B with the vendor # in the text from column H.

Any suggestions otherwise this could take a lifetime.

Thanks in advance
Cotlodjimmy

 

[JamesW]

Hi,

Do your vendor numbers always contain -'s?

If so, try:

=IF(ISNUMBER(FIND(SUBSTITUTE(B2,"-",""),H2)),"found","not found")