Vlookup with workbook in a same folder

[mayaa_mmm]

In the below workbook A, with file name starting MarkList_12_4_2020.xlsx and sheet name as file name in stored folder (C:/Desktop/Mark)

Name	Mark	Class	Grade
John	50​	Post Graduate	A
Peter	50​	Preschool	A
Andera	100	Nursery	S

In the another Workbook B, is the fixed Existing report which is also stored in the same folder, which has extra columns

Need a VBA coding for
1.Post Graduate-Assign Austin in Reviewed by column
2. Preschool-Assign Victoria in Reveiwed by Column
3. Nursery -Assign Anglea in Reveiewed by Column

Name	Mark	Reviewed by	Class	Grade
John	50​	Austin	Post Graduate	A
Peter	50​	Victoria	Preschool	A

Output of workbook B
1. Vlookup with Workbook A with Name and update the workbook B with not available record only. (in this case Andera is new record )
John and Peter should not update again the workbook B.

Name	Mark	Reviewed by	Class	Grade
John	50​	Austin	Post Graduate	A
Peter	50​	Victoria	Preschool	A
Andera	100	Angela	Nursery	B

 

[Lukasier]

I have no idea what you want to be honest. You need to describe your problem a little more

 

[mayaa_mmm]

I have no idea what you want to be honest. You need to describe your problem a little more

Thank you for your quick reply

I need to vlookup the Workbook A for the Name column with workbook B Name column
stored in the same folder (C:/Desktop/Mark)

Workbook A (Report download from server which starts with Mark-04-02-2020.xlsx and worksheet name as Mark-04-02-2020 and Workbook B stored in both folder.

Need a Macro to do this vlookup and paste the not available Name in the Workbook B