Index Match

Options
cpezz
cpezz ✭✭
edited 12/09/19 in Smartsheet Basics

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

Comments