Correct formula

    Hello Formula experts

    I am trying to use the choose function to get a match and it is showing me an error0 Can some one please tell me what is wrong with the formula and how to correct it.?

    Correct formula.xlsx

    No. My sheet is not protected. I am using excel 2019 but I want the formula to work in old versions also. I am trying to get column B and C records from step3 sheet to Extract B2B in columns A and B. Vlookup doesn't work in the left so using choose function.

    Hello,


    You can test in cell A2

    Code
    =INDEX(Step3!B2:B18675,MATCH($G2,Step3!$D$2:$D$18675,0))

    and then copy down as well as to Column B


    Hope this will help :)

    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 :)

    Thanks Carim.

    The formula is working and giving the result for the first 4959 rows and rest of the rows it is showing 0 in both the columns A and B. Only 50% of the rows are displaying and are correct. The range in the formula too looks right. Can you please check the formula and check whether it works in that workbook.

    The first range reference needs to be absolute too:


    =INDEX(Step3!$B$2:$B$18675,MATCH($G2,Step3!$D$2:$D$18675,0))

    Rory
    Theory is when you know something, but it doesn’t work. Practice is when something works, but you don’t know why. Programmers combine theory and practice: nothing works and they don’t know why

    Like 1

    rory


    Thanks a lot for correcting my mistake =O

    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 :)

    No worries - we've all done it. :)

    Rory
    Theory is when you know something, but it doesn’t work. Practice is when something works, but you don’t know why. Programmers combine theory and practice: nothing works and they don’t know why

    Thanks 1

Participate now!

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

Register Yourself Login