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.?
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.?
Your sheet seems to be protected ? Still using XL 2007? Please add some expected results. Thx
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.
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))
No worries - we've all done it.
Thanks rory. That worked perfect. I got both the columns as expected.
Don’t have an account yet? Register yourself now and be a part of our community!