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

1. Inventory, column A has a PILE of leading spaces before SKU.

2. Delete all values from AE2 doown.

3. If you O365 supports the MAP function you can use this:

=MAP(A2:A14,C2:C14,LAMBDA(x,y,IF(TRIM(x)="SKU",VLOOKUP(y,'Bin number source'!A:D,4,FALSE),"")))

4. If the leading spaces are not there (or are easily removed), it's always better to use clean data, the TRIM can be omitted.

=MAP(A2:A14,C2:C14,LAMBDA(x,y,IF(x="SKU",VLOOKUP(y,'Bin number source'!A:D,4,FALSE),"")))

All in one cell, no formula dragging...

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however the thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)