ExcelBanter - PARTIAL TEXT MATCH SEARCHING FOR THE FIRST 6 CHARACTERS?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - PARTIAL TEXT MATCH SEARCHING FOR THE FIRST 6 CHARACTERS? (https://www.excelbanter.com/excel-worksheet-functions/163203-partial-text-match-searching-first-6-characters.html)

PARTIAL TEXT MATCH SEARCHING FOR THE FIRST 6 CHARACTERS?

Hi. I have two sheets I need to find matches from sheet1 against
sheet2 looking for the first 6 characters only.

example:

sheet1 sheet2 MATCH RESULTS
ABCCOM ABCCOM ABCCOM
ABCINCORPORATED XYZCOMPANY XYZCOMPANY
XYZCOMPANY MISCOMPANY
XYZINCORP XXXCOMPANY

can anyone help?

PARTIAL TEXT MATCH SEARCHING FOR THE FIRST 6 CHARACTERS?

Hi KLZA
Try:

ABCCOM ABCCOM ABCCOM
ABCINCORPORATED XYZCOMPANY XYZCOMPANY
XYZCOMPANY MISCOMPANY
XYZINCORP XXXCOMPANY

In XL2000 italian Formula in C2:C5
=SE(VAL.ERRORE(CERCA.VERT(SINISTRA(B2;6)&"*";$A$2: $A$5;1;FALSO));"";CERCA.VERT(SINISTRA(B2;6)&"*";$A $2:$A$5;1;FALSO))

In English; please ceck the functions translation
=IF(ISERROR(VLOOKUP(LEFT(B2,6)&"*",$A$2:$A$5,1,FAL SE)),"",VLOOKUP(LEFT(B2,6)&"*",$A$2:$A$5,1,FALSE)) "

regards
Eliano

"KLZA" wrote:

Hi. I have two sheets I need to find matches from sheet1 against
sheet2 looking for the first 6 characters only.

example:

sheet1 sheet2 MATCH RESULTS
ABCCOM ABCCOM ABCCOM
ABCINCORPORATED XYZCOMPANY XYZCOMPANY
XYZCOMPANY MISCOMPANY
XYZINCORP XXXCOMPANY

can anyone help?