Need help on lookup/index/match formula or worse need to VBA

Important Notice


Please note that on 14th December 2023 users will experience an expected outage whilst we make upgrades to our network. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.

  • Hello guys,


    Newbie/Noob here, need your hand on this one:

    ABCDE
    1 H058B057C062H059
    21-Nov18,000
    32-Nov2,0003,000
    43-Nov 20,00015,000
    54-Nov 10,00015,000

    B1:E1 is my SW Code

    B2:E5 are my quantity


    need to do something like xlookup but don't know how to do it. Here's my question,

    on another sheet, if my lookup value is on the Column A, how can I get its all quantity and SW Code using a formula or a VBA? Something like this:

    Date:SW CodeQuantity
    3-NovB05720,000
    C06215,000

    3-Nov is my lookup value

    B057 & C062 / 20,000 & 15,000 are my result on lookup


    Thanks in advance!

  • Rr111


    Just noticed you had already posted .... and never answered to Alan ... :thumbdown:


    As far as I am concerned, there is no reason for me to help you out on another topic ...such as :


    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!