I recently implemented FINDROW in a table and was unable to get it to return a value, instead getting "#NAME" in the cells where I had entered the FINDROW function.
It turns out that the column header for the column I was referencing (i.e., the column header in the actual table, not the column name as I had written it in the FINDROW function), had a trailing space. This was not obvious, as trailing spaces are not apparent unless you take the time to click to edit the header, and then click at the end of the header to see that there is an empty space between the cursor and the last visible character.
I removed that space, thus ensuring that it matched how I was referring to the column in my FINDROW function. Suddenly, my FINDROW function was returning values.
Hope this helps someone else out there.
