Want to pick the data from another file ( like Vlookup)

[Maheshp]

Hi Team,

I have a data in one file like below.

Name	Number	BOP	Amount	Debit	Credit	Total
10X-Regel	9783527509867	BC.531460.01	0	0	0	0
10X-Regel Audio	9783527509874	BC.531460.02	0	0	0	0
1x1 der Kommunikation für Führungskräfte	9783527507115	BC.334707.01	0	0	0	0
200 and More NMR Experiments	9783527310678	BC.324560.01	0	0	0	0
2D Nanomaterials C	9783527346776	BC.530971.04	0	0	0	0
3D Bioprinting C	9783527347964	BC.539321.01	0	0	0	0
3D Images of Materials Structures	9783527312030	BC.332383.01	-82.9	0	82.9	82.9

Another File Data:- 

Number	Point
9783527509867	400
9783527509874	300
9783527507115	500
9783527310678	300

But in another file i have " Numbers and Points only", with the help of option how can we get only POINT from that particular Number like below.

Name	Number	BOP	Amount	Debit	Credit	Total	Points
10X-Regel	9783527509867	BC.531460.01	0	0	0	0	400
10X-Regel Audio	9783527509874	BC.531460.02	0	0	0	0	300
1x1 der Kommunikation für Führungskräfte	9783527507115	BC.334707.01	0	0	0	0	500
200 and More NMR Experiments	9783527310678	BC.324560.01	0	0	0	0	300

Regards,

Mahesh

[RobertOdera · Accepted solution]

Hi, @Maheshp 

Please check out the options below.

Please mark it as an acceptable solution if it works for you - cheers!

[ShankerV]

Hi @Maheshp 

A simple join tool will help you to achieve the result for you.

Many thanks

Shanker V

[RobertOdera]

You're most welcome @Maheshp