Using vlookup to update a cell from data in another cell based on matching two other cells

Greetings,
I apologize, my sample spreadsheet did not contain the proper data to test, it did not have matching sku's in both tabs. I have corrected it and uploaded again.

Not sure if I should post this under formulas or VBA because I don't know if a formula or VBA script will work better so I posted in General.

Basically I need to update the corresponding cell in column AE in tab 'BC Inventory' from the cell in column D in tab 'Bin number source' based on matching the 'sku' cells in the two tabs.
But I only want the cells updated that are labeled SKU in column A of the 'BC Inventory' tab.

Thank you in advance for any help.

Glenn