# 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

• Thanks a lot for correcting my mistake

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 rory. That worked perfect. I got both the columns as expected.

## Participate now!

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