How to Lookup a value on one wookbook, and results in second wookbook

[rskip]

I have 2 wookbooks.
In the first work book i have 3 columns, (as in pic1), columns have name, ranking, and points totals.
In the second work book I have the same columns, however the names are NOT in the same order.
I want to look up the name from the second workbook and find the points total for that person from the first work book.
Iam lost
Thanks

 

[pure vito]

Hey this is my first attempt at answering a question here I'm usually asking them,

You could use a Vlookup right?

It would look something like this but you haven't shared the workbook names or columns so I can't attempt to make this fit your workbook,

You would add this formula to the 3rd column of your second workbook,

=VLOOKUP(A2,'H:New Model BEV & ICE\25MY BEV\[DHL BIW BOH.xlsm]Workbook1'!$A:$C,3,0)

Although this doesn't fix your Issue I hope it somehow helps

 

[rskip]

Thank you