value mapping and assign names based on the cell value-vba

[mayaa_mmm]

In sheet 1 of the workbook, have table like below

Class	Creater	Assigne
Python	Johny	Sheela
Cloud	Dan	Angela
Microsoft	Manny	Andrea
Embedded	Mala	scotty
Pearl	Dan	Angela
Flash	Johny	Sheela

In Sheet 1 of the another workbook B , in a same folder have table like below,

I want to assign the names for the ID based on the creater. Creater values and assigne value will be in sheet 1 of the workbook A. Based on the Workbook A inputs, Creater coulumn in B worksheet, will map values from A workbook and assign names.

In case mapping not found , we should assign as not found

I like to have in VBA for running he huge record

ID	Assigne(0utput)	Creater
ID1	Sheela	Johny
ID2	Anglea	Dan
ID3	Andrea	Manny
ID4	Scotty	Mala
ID5	Anglea	Dan
ID6	Sheela	Johny
ID7	Not Found	Iris