Index Match

cpezz

I have the following formula in one of my sheets:

=INDEX({My Data Range 9}, MATCH([Column19]1, {My Data Range 10}))

It returns "no match", but I can see the match on the source sheet because it's my first entry. I know it's there - what's wrong with my formula?

 

Thanks

Paul Newcome

=INDEX({My Data Range 9}, MATCH([Column19]1, {My Data Range 10}, 0))

 

Add a zero in the final portion of your MATCH. If that does not work, if you can provide screenshots of the source and target sheets with sensitive/confidential data removed, blocked, or replaced with "dummy data", that would be rather helpful.

cpezz

Got it - thank you!

Paul Newcome

Happy to help!