Index/Match Returns No Match but vLookUp works?

Stephen Wiant

I have an index/match formula that is returning a No Match and when I try the Vlookup it is working.

=INDEX({BE Job Intake Range 1}, MATCH([Project ID]@row, {BE Job Intake Range 2}), 0)

The colunm in the lookup table is a formula result combining the values of two fields. Seems to work fine when I use the vloopup but not the index/match and I cannot figure out why.

Thanks in advance for the assist.

Andrée Starå

Index/Match Returns No Match but vLookUp works?

Stephen Wiant

Jul 31, 2024

I have an index/match formula that is returning a No Match and when I try the Vlookup it is working.

=INDEX({BE Job Intake Range 1}, MATCH([Project ID]@row, {BE Job Intake Range 2}), 0)

The colunm in the lookup table is a formula result combining the values of two fields. Seems to work fine when I use the vloopup but not the index/match and I cannot figure out why.

Thanks in advance for the assist.

---

View Post

Hi,

I hope you're well and safe!

Can you share some screenshots? (Please delete/replace any confidential/sensitive information before sharing) That would make it easier to help.

I hope that helps!

Be safe, and have a fantastic day!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅ Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Aweseome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!

heyjay

Index/Match Returns No Match but vLookUp works?

Stephen Wiant

Jul 31, 2024

I have an index/match formula that is returning a No Match and when I try the Vlookup it is working.

=INDEX({BE Job Intake Range 1}, MATCH([Project ID]@row, {BE Job Intake Range 2}), 0)

The colunm in the lookup table is a formula result combining the values of two fields. Seems to work fine when I use the vloopup but not the index/match and I cannot figure out why.

Thanks in advance for the assist.

---

View Post

Can you please try this.

=INDEX({BE Job Intake Range 1}, MATCH([Project ID]@row, {BE Job Intake Range 2}, 0)

You have an extra parenthesis before the ,0.

Stephen Wiant

@heyjay that appears to have solved the problem. Very odd that wasn't spotted but thank you VERY much.