Show product name when scanning Bar Code

Hello,

I have a Products table with: Product name, Barcode (Key), supplier, etc.
Then I have a Sales table: with Product Name, Barcode, Date, etc.

In the SALES table I placed Barcode as Ref and Product Name as Text.
What can I do for the Product Name to be automatically Identified based on the Barcode.
I currently have the Product Name as text, with no formula or initial value. But it leaves the cell blank instead of generating the name of the product.

Thank you

4 Likes

Very useful, thank you!

2 Likes