CODEWITHSUNDEEP
vbaexcel
Horia Rudan
Horia Rudan

Reputation: 178

Excel: 2 sheets, populate the matching cells from one sheet with the values from the other

I know this question has been asked and aswered before in other forms. But, I have no experience at all with Excel and I don't know how to adapt the other answers to my use case. If someone would be able to help me in my use case, I would be deeply grateful.

My use case: I have a dropshipping store and I need to update my stock using Excel files. My stock update file has two columns: SKU and Stock. My suppliers send me stock files with similar columns, but not all products from my supplier files are listed in my shop and the order in their files is different.

What I would like is to be able to make a workbook with two sheets:

enter image description here

enter image description here

Then, to be able to change the column "Stock" from the sheet "My Stock" with the values found in the "Supllier stock" sheet for that SKU. If a SKU is not found, ignore. For example, check "Supplier Stock" for SKU1 and update SKU1 in "My stock" with the found value.

Is this possible? It would save me a lot of time. Thank you verry much.

Edit: "Foo"and "Bar"are examples of SKUs that need to be ignored, as they have no match in "My stock"sheet.

Upvotes: 1

Views: 84

Answers (1)

Mrig
Mrig

Reputation: 11727

Enter the following formula in Cell B2 of sheet My Stock

=IFERROR(VLOOKUP(A2,'Supplier Stock'!$A$2:$B$8,2,FALSE),"")

or 

=INDEX('Supplier Stock'!$B$2:$B$8,MATCH(A2,'Supplier Stock'!$A$2:$A$8,0))

See image for reference.

enter image description here

Upvotes: 3

Related Questions