Reference/Dereference list

[MikeZ]

Hi,
I am trying to use REF/Dereference to look up an item code from a given barcode number. The lookup table consists of a key column with the barcode number and an item code column.
My app takes user input for the barcode number. This is a Ref column to the lookup table.
My problem is that when inputting the barcode, a list of all possible values is automatically presented to the user, which I do not want. And, once I set up the dereference formula, the list consists of all item codes.

Is using a LOOKUP() formula the way to go in this case?

Thanks,
Mike

[Marc_Dillon · Accepted solution]

In your case, I would setup 3 columns.

1. Text type entry field, with scanning option turned on.
2. Hidden Ref type column pointing to lookup table, with app formula of just [column 1].
3. Text type to display associated item code, with formula [column2].[item code]

[MikeZ]

Works wonderfully, thanks!