Who can help identify my issue with cross sheet index matching formula?

MEJ

Hello,

Wondering if anyone can help me with finding the error in my formula:

=INDEX({Destination Care Fund Statement of Need Range 1}, MATCH({Destination Care Fund Statement of Need Range 2}, [MRN], 0))

Range 1 and range 2 information populated when I clicked the column in the selected sheet from reference another sheet

I am trying to do a cross sheet reference so that the lodging amount will populate in another sheet @ row level if my MRN column matches. All changes I try just give me other errors and this formulas gives and unparseable error.

jmyzk_cloudsmart_jp

@MEJ

Please try changing [MRN] to MRN@row.

=INDEX({Destination Care Fund Statement of Need Range 1}, MATCH(MRN@row, {Destination Care Fund Statement of Need Range 2}, 0))

jmyzk_cloudsmart_jp

@MEJ

Please try changing [MRN] to MRN@row.

=INDEX({Destination Care Fund Statement of Need Range 1}, MATCH(MRN@row, {Destination Care Fund Statement of Need Range 2}, 0))

MEJ

@jmyzk_cloudsmart_jp thank you so much that made it work!!

jmyzk_cloudsmart_jp

Happy to help!😁