Sep 15 2021 02:00 PM
Hello everyone,
Is there anyone who know a way to import data to cells with vlookup depends on number of inventory stock. To be more precise I want to show examples lets say I have 2 different excel workbooks.
Table 1 shows product barcodes, stock numbers in different warehouses.
Table 2 shows product barcodes and which warehouses to order them.
I want to make vlookup in "align stocks" column but my wish is when stock run out from one certain warehouse it has to automatically shift to next warehouse which has a stock.
For example in attachment , regular vlookup only get first value from table 1 which is new york. But normally new york's stocks of 111 is finishes in 2nd one. 3rd 111 should be MOSCOW and 4th 111 should be PARIS.
Is there any way formula/macro to do this? I would be really appreciate. if someone help me out in this one. Thanks in advance.
Sep 16 2021 11:02 PM
Sep 17 2021 02:03 AM
Here is an approximate example.
With your permission, I recommend inserting a file for the next time (without sensitive data),
as well as information about the Excel version and operating system.
I would be happy to know if I could help.
NikolinoDE
Was the answer useful? Mark them as helpful!
This will help all forum participants.
Sep 17 2021 12:52 PM
Sep 17 2021 01:22 PM
@NikolinoDE Hello nikolino, thanks for the reply. My excel version is 2108 and I am using windows 10.
I explained more detailed in excel and Im putting it to attachment as you asked.
I would be really glad if there is a code or formula for this. Thanks in advance!
Sep 18 2021 07:28 AM
Here's an example
Sorry for the delay, but unfortunately my free time is limited on the weekend :)).
I would be happy to know if I could help.
NikolinoDE
Was the answer useful? Mark them as helpful!
This will help all forum participants.
Sep 19 2021 11:31 AM
Solution@NikolinoDE Hello, I actually found my exact solution that what I was looking for. I'm putting in an attachment in case if anyone will have the same issue as me. Thank you for your help and time:)
Have a nice day
Sep 19 2021 11:31 AM
Solution@NikolinoDE Hello, I actually found my exact solution that what I was looking for. I'm putting in an attachment in case if anyone will have the same issue as me. Thank you for your help and time:)
Have a nice day