Index/Match Returns No Match but vLookUp works?

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.

Tags:

Answers