Copy Truncated to non Truncated

[light]

Hi

Names in workbook A, sheet 1 column B are truncated to a max of 11 characters which include spaces, (from dbase3). Those names will match names in workbook B sheet 1 Column A. Names in workbook B are not truncated.

Need a macro, or formula that will match truncated names in workbook A to full names in workbook B. If a match, copy value in same row from that name, column O, to corresponding name in workbook B sheet 1 Column H.

In the attached file, the first section represents workbook A with its truncated names. The 2nd sections represents workbook B with the non truncated names. Note they are not in the same order. And the 3rd section shows what I want to happen.

Thanks

[Pete_UK]

Put this formula in P3:

=IFERROR(MATCH(B3&"*",$A$15:$A$24,0),"")

then copy down to P12.

Then you can use this formula in H15:

=IFERROR(INDEX($O$3:$O$12,MATCH(ROWS($1:1),$P$3:$P$12,0)),"")

and copy that down as required.

Hope this helps.

Pete

[light]

Thanks Pete. But as mentioned, the data is in different workbooks,not on the same sheet. I only put them on the same sheet in the example to try to illustrate what the data looks like. Also there is much more data than what I showed.

[bakerman2]

Try this one.

Please Login or Register  to view this content.

[jindon]

Hi

Names in workbook A, sheet 1 column B are truncated to a max of 11 characters which include spaces, (from dbase3). Those names will match names in workbook B sheet 1 Column A. Names in workbook B are not truncated.

Need a macro, or formula that will match truncated names in workbook A to full names in workbook B. If a match, copy value in same row from that name, column O, to corresponding name in workbook B sheet 1 Column H.

Thanks

Try
You need to change FolderNameHere to correct folder path.

Please Login or Register  to view this content.