Index Match

duncbro

I have used an index match in several columns of a grid. However, this one column is giving me trouble.

Can anyone review and let me know what I am overlooking?

=INDEX({Fiscal Listing FY22 (4/11) Range 1}, MATCH(Funding@row, {Fiscal Listing FY22 (4/11) Range 2}, 0))

Jason Tarpinian

Without too much more data, can't say exactly what is happening, your syntax looks correct. Are your ranges the same size? Make sure they are the same sheet, or at least referencing the same size ranges.

duncbro

Yes, the ranges are the same sizes. The issue was with the column property.

Thank you!