[Help] Sorting Two Data columns/matching [Help]

Hello,

I need to match certain information up. I have attached an excel document that will help answer my question hopefully.

Its clear in the document what i need done if someone is able to post the formula needed or way to do it would be great!

Thanks,

Matt

INDEX(..MATCH(FIND(..))) can do it

Plop this into D19 in your example, and copy downwards.

=IFERROR(INDEX($C$1:$C$3,MATCH("*"&LEFT(A19,FIND(":",A19)-1)&"*",$C$1:$C$3,0)),"")

Originally Posted by daffodil11

INDEX(..MATCH(FIND(..))) can do it

Plop this into D19 in your example, and copy downwards.

=IFERROR(INDEX($C$1:$C$3,MATCH("*"&LEFT(A19,FIND(":",A19)-1)&"*",$C$1:$C$3,0)),"")

Okay thanks going to have to play around with this string as the two data lists go from A1 to A27557 and the second from B1 to B15884

How would i change the string to match that data?

Column A being fc43rf:3f Column B being: fc43rf:3f:f45f

=IFERROR(INDEX($C$1:$C$3,MATCH("*"&LEFT(A19,FIND(":",A19)-1)&"*",$C$1:$C$3,0)),"")

=IFERROR(INDEX(ENTIRE RIGHT COLUMN,MATCH("*"&LEFT(LEFT COLUMN FIRST ITEM,FIND(":",LEFT COLUMN FIRST ITEM)-1)&"*",ENTIRE RIGHT COLUMN,0)),"")

Move Column B somewhere else, say.. Column D.

Now in its place starting in B1 put:

=IFERROR(INDEX($D$1:$D$15884,MATCH("*"&LEFT(A1,FIND(":",A1)-1)&"*",$D$1:$D$15884,0)),"")

and then copy downwards


This formula will look at each item in A, find it's match wherever you have the other list, and pull the item from that list.

I was able to edit the string by myself soo it would be:

=IFERROR(INDEX($B$1:$B$15867,MATCH("*"&LEFT(A6,FIND(":",A6)-1)&"*",$B$1:$B$15867,0)),"")

This works fine! However...

How do u copy the formated data onto another sheet/workbook?

Paste Values

Highlight the data, copy, right click in the destination, and choose the little "123" icon.

Optionally, you can choose Paste Special from the same right click menu and then just choose the Value box and hit okay.

So helpful!

Thank you very much

Glad I could help.

If you believe this question is answered in a satisfactory manner, please mark the thread as SOLVED at the very top, under Thread Options