Incorrect output index-match

[mso3]

Hi friends,

I want to get a value in column 'AL' designation.
The formula is giving error n/a.
Any help will be highly appreciated.
Thanking you,

[JeteMc]

If you run "Evaluate formula" on Personal!AL9 you see that the #NA throws when it tries to match 1, from Personal!B9, with a value from Information!CR3:CR30 where it does not find a corresponding 1. I you want the cell to display something else you could wrap your formula in IFERROR something along the lines of

Please Login or Register  to view this content.

I am also changing the formula itself because there was an un-needed Index that was causing some different problems.

Let me know if you have any questions.

[mso3]

No, it's not giving correct output.

It's showing Vice President for most of the members.

Please see attached workbook for your reference.

Thank you.

[JeteMc]

That was the "different problem" that I mentioned as being caused by the un-needed Index. Here is the file using the formula from post #2.

Copy of NA error.xlsm

Let me know if this works for you.

[JohnTopley]

IFERROR(INDEX(Information!$CT$3:$CT$30,MATCH(Personal!$B9,INDEX(Information!$CR$3:$CR$30,0))),"No Match")

MATCH should have 0 as Match Type

[mso3]

Hi JeteMc,
Sorry! I didn't saw the post 2 which you have edited. I simply copy the formula from the mail I received and paste it in the file.

It's working fine in the post 2 itself which I skipped and prolong the thread.

Sorry for trouble.

Thank you for kind assistance.

Have a nice day!

[JeteMc]

Not a problem at all and thank you for the feedback. Hope that you have a nice day also.