PC Asset Tracker - Get value in new sheet

Dear everyone,

I need help to get value in new sheet from different sheet. The worksheet purpose to track PC/Notebook replacement with old & new information.

Data in master list:
- Column A-L are the old asset device.
- Column M-U are the new asset information.
The keyword is asset tag number and based on it's mapped to serial number and owner details.

Data in branch sheet are values from master list (Column M-U) based asset tag number, location and owner details.

Please help for the formula. Many thanks