Getting Started

How can I select the first result found in a query with multiple results?

In the example below, the 'Correct Hauler Name' column is a query that searches for values containing: {#Column Number# .CT. [Hauler]} within the [Table with a list of names].

I get Multiple values in the column, I need only the first value the query founds.

You can do a Part function and split on the ;

Formula queries return a ; delimited list, so doing the part at the first occurrence using the ; as the split will give you what you need. So in your correct hauler name: 

Part(query results value, 1, ";")

How can I select the first result found in a query with multiple results?

In the example below, the 'Correct Hauler Name' column is a query that searches for values containing: {#Column Number# .CT. [Hauler]} within the [Table with a list of names].

I get Multiple values in the column, I need only the first value the query founds.