You need to sign in to do that
Don't have an account?

sflookup
How does one get it to look under a field other than name?
=sflookup(B12,C12) | account | testaccount name |
works to give them test account's ID, but i need to use a field other than name.
Documentation claims:
sflookup(tablename, name): returns the ID for the table based on a search value; it matches most fields
using an unique number in the "name"cell gives the NF