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

Need an account? Sign Up

Have an account? Sign In