One to Many Formula to return first instance

[Anonymous]

Hi Experts

I have two tables A and B. In table A i have unique instance of the values (client names) in table b i have multiple instance of the client names and multiple instance of the business sector they are in, which is the same for each client...

I want to return the results of which business sector they are in - into table A and get only one instance....

[Anonymous · Accepted solution]

Hey @Anonymous

The FIRSTNONBLANK function should work nicely. It's syntax is FIRSTNONBLANK(Table[Column],1). The ",1" is important to not throw an error.

Hope this helps,

Parker

[Anonymous]

thanks Parker