+ Reply to Thread
Results 1 to 13 of 13

How to do a Vlookup in a conditional situation

  1. #1
    Registered User
    Join Date
    09-18-2021
    Location
    istanbul
    MS-Off Ver
    MS365
    Posts
    7

    How to do a Vlookup in a conditional situation

    Hello y'all,

    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 and which warehouses to order them.

    Table 2 shows product barcodes, stock numbers in different warehouses.

    I want to use vlookup in "Which warehouse should I order the product from?" 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.

    I explained more detailed in excel file in the attachment.

    I would be really appreciate if someone help me about this I haven't find anything as solution so I am thinking its not doable in excel maybe I need some sort of programming.

    Thanks!
    Attached Files Attached Files

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider (Windows 11 64-bit)
    Posts
    53,027

    Re: How to do a Vlookup in a conditional situation

    Welcome to the forum.

    2108 is a release number, and your version is MS365. Please update your forum profile. Thanks.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

  3. #3
    Registered User
    Join Date
    09-18-2021
    Location
    istanbul
    MS-Off Ver
    MS365
    Posts
    7

    Re: How to do a Vlookup in a conditional situation

    Thank you

    Oh I see I didnt know it, I just updated

  4. #4
    Valued Forum Contributor
    Join Date
    09-30-2019
    Location
    Chiangmai, Thailand
    MS-Off Ver
    Office 2016
    Posts
    635

    Re: How to do a Vlookup in a conditional situation

    Maybe

    B2
    Please Login or Register  to view this content.
    Regard.

    Note : above formula can't deal with order with volume more than one for each.
    My English is very poor, so please be patient >_<"

  5. #5
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2013
    Posts
    8,267

    Re: How to do a Vlookup in a conditional situation

    It can be done with helper column, do you open to use helper column?
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.

  6. #6
    Registered User
    Join Date
    09-18-2021
    Location
    istanbul
    MS-Off Ver
    MS365
    Posts
    7

    Re: How to do a Vlookup in a conditional situation

    menem, thanks for the reply but when I type the formula in cell it says, "there is a problem with this formula)

  7. #7
    Registered User
    Join Date
    09-18-2021
    Location
    istanbul
    MS-Off Ver
    MS365
    Posts
    7

    Re: How to do a Vlookup in a conditional situation

    samba_ravi, thanks for the reply. I think that but unfortunely helper column doesnt help me

  8. #8
    Forum Expert
    Join Date
    05-05-2015
    Location
    Waterlooville,England
    MS-Off Ver
    Office 2010
    Posts
    20,657

    Re: How to do a Vlookup in a conditional situation

    Why can you not use a helper column ?

  9. #9
    Registered User
    Join Date
    09-18-2021
    Location
    istanbul
    MS-Off Ver
    MS365
    Posts
    7

    Re: How to do a Vlookup in a conditional situation

    JohnTopley, thanks for the reply. As far as I know helper column needs other data to combine with 2+ columns. So in my case I have only one product barcode and needs to take number of stocks from different workbook. I have tried before and couldn't find a way. But if you got a solution with it, I would be happy to hear

  10. #10
    Valued Forum Contributor
    Join Date
    09-30-2019
    Location
    Chiangmai, Thailand
    MS-Off Ver
    Office 2016
    Posts
    635

    Re: How to do a Vlookup in a conditional situation

    Quote Originally Posted by newbiemaster View Post
    menem, thanks for the reply but when I type the formula in cell it says, "there is a problem with this formula)
    Please verify in the file.



    Regards.
    Attached Files Attached Files

  11. #11
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2013
    Posts
    8,267

    Re: How to do a Vlookup in a conditional situation

    Try below array formula in B2, copy and paste towards down
    see the attached file
    it have 2 solutions - 1 with helper columns and another with direct forlula
    Attached Files Attached Files

  12. #12
    Registered User
    Join Date
    09-18-2021
    Location
    istanbul
    MS-Off Ver
    MS365
    Posts
    7

    Re: How to do a Vlookup in a conditional situation

    menem, after opening your excel I tried the same formula and it worked! Thats awesome, I will try with big data excel later, it seems it will work. I really appreciate your help, you save me

  13. #13
    Registered User
    Join Date
    09-18-2021
    Location
    istanbul
    MS-Off Ver
    MS365
    Posts
    7

    Re: How to do a Vlookup in a conditional situation

    samba_ravi, This is also what I was looking for exactly, I appreciated your time and help as well. Really thank you!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Vlookup on this situation.
    By Kanzen in forum Excel General
    Replies: 13
    Last Post: 10-19-2018, 01:55 AM
  2. Can vlookup help in this situation?
    By samratpahwa in forum Excel General
    Replies: 3
    Last Post: 08-22-2018, 01:46 PM
  3. Need help with a VLOOKUP Type of Situation...Again
    By Daveguy in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-23-2016, 10:34 AM
  4. Need help with a VLOOKUP Type of Situation
    By Daveguy in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-06-2016, 12:42 PM
  5. [SOLVED] Conditional formatting for not equal to situation
    By ROHAN999 in forum Excel General
    Replies: 5
    Last Post: 07-06-2013, 03:46 AM
  6. Replies: 1
    Last Post: 07-20-2012, 05:50 PM
  7. Help with a Vlookup/max type situation
    By cwn7499 in forum Excel General
    Replies: 5
    Last Post: 02-15-2009, 11:19 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1