Matching

Hello great people! Happy Friday . in one file I have

0123 ABC
0123 ABC
0123 ABC
0123 ABC
0123 ABC
0123 ABC
0123 ABC
0123 ABC
0123 ABC
0123 ABC
0123 ABC
0123 ABC
00584 XYZ
00584 XYZ
00584 XYZ
00584 XYZ
00584 XYZ
00584 XYZ
00584 XYZ
00584 XYZ
00584 XYZ
00584 XYZ

another file I have

00584
00584
00584
00584
00584
00584
00584
00584
00584
00584
00584
00584
00584
00584
00584
00584
00584
00584

How can I match relevant 00584 with file 1.

Appreciate your help.

Thanks

number matching.yxmd

Workflow

Accepted answers

binu_acs

@Kinetic_analytics One way of doing this

number matching.yxmd

All comments

Felipe_Ribeir0

Hi @Kinetic_analytics

Can you share the 2 inputs and how the output table should looks like?

Kinetic_analytics

@Felipe_Ribeir0 I have attached an example file for you. I want to do Vlookup basically based on the number 584

example.xlsx

binu_acs

@Kinetic_analytics One way of doing this

number matching.yxmd

Kinetic_analytics

@binu_acs Awesome! Thank you

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15879

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703