How to compare two excel file columns and fill other columns

I have two excel files. I have to compare “STATE” Column from Book_2_ to Book_1 , If it’s match then I need to fill the as “X” mark in book_2, whether it belongs to (B.tech. MBBS or MS) and same we need to fill “NAME” Columns. Please refer the excel files.Book1.xlsx (8.3 KB)
Book2.xlsx (8.2 KB)

Can someone please help