Complicated Formula - Please Help if you can!!!

[Thansen971]

So for my current work we are getting a new system to keep track of inventory. Everything we have saved in our current inventory is saved into a workbook in Excel. I was wondering if there is a formula that can determine a few things.

so the basic formula i would want would be

IF A2 through A50000 in workbookA = B2 through B50000 in workbookB
THAN put L2 through L50000 from workbookA into G2 through G50000 in workbookB

To have it make more sense, we want to have the SKU of items from our old inventory match the SKU's in our new inventory and if they match then to take the quantity from our old inv and place that in the new quantity in the new inventory.

Please let me know if you can help, it would be a huuuuuuuuge help for me and this company. Thank you all very much!

 

[Jonmo1]

Welcome to the board.
Sounds like a job for Vlookup

Assuming when you say 'WorkbookA', you're referring to Sheets/Tabs within the same workbook

In WorkbookB, G2 and filled down

=VLOOKUP(B2,'workbookA'!A$2:L$50000,12,0)

 

[Thansen971]

Welcome to the board.
Sounds like a job for Vlookup

Assuming when you say 'WorkbookA', you're referring to Sheets/Tabs within the same workbook

In WorkbookB, G2 and filled down

=VLOOKUP(B2,'workbookA'!A$2:L$50000,12,0)

Okay so I dont really know how Excel Formulas work. Is this formula automattically assuming that the numbers are going to match? because in our situation we dont know if all of them are going to match. Also if you could break it down so a non-excel person could understand it! thanks LOL

 

[codeedoc]

No problem



SKUs are rona and homedepot lots of money flow uhuh I could be persuaded to work for $$$

Can you tell us who this company is???

Anyway back up your workbook first before messing with it. That advice was worth about 100 he he he