Hello,
Given a table similar to the following:
| location |
favorite_fruit |
| Home |
Apple |
| Office |
Apple |
I would expect to be able to use the following expressions:
=fieldvalue('favorite_fruit',fieldindex('location','Home')) or
=fieldvalue('favorite_fruit',fieldindex('location','Office'))
This works fine if the favorite_fruit values are unique, but if they're the same, fieldvalue() regards favorite_fruit as having only 1 value and thus =fieldvalue('favorite_fruit',fieldindex('location','Office')) returns null.
Is there any expression that would return the favorite_fruit value for Office regardless of non-unique values?
Thanks,
Steve
