Matching

[Kinetic_analytics]

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

[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

[binuacs · Accepted solution]

@Kinetic_analytics One way of doing this

[Kinetic_analytics]

@binuacs Awesome! Thank you :)