Need a formula to pull site info from based on a match in the next columns

I need a formula that pulls the site number from column D to column B (yellow) based on a match from column A matching anything in columns E through F.

Trying to organise where items are at various sites but the previous table had multiple items on each site where we just want the item matched with a site (blue table) and will tie more information to each item going forward on an item-by-item basis as opposed to just lumping all items at sites. Thanks

Cheers, that's perfect.