LOOKUP Function not working

[Zikri_Zainal]

Hi,

I’m scanning a QR Code into a Daily Tool Log table referenced with a Daily Maintenance Job ID (Work Orders Table).

For a specific job, i would like my technicians to record their tool usages.

However, instead of just scanning the QR code, I would want the table to include the details of the tools recorded from its Tool Inventory table.

I used

LOOKUP([_THISROW].[Product Barcode],“Tool Inventory”,“Product Barcode”, “Tool Description”)

However its not returning any results.

Can someone help me with this?

Btw Product Barcode is scannable.

[Zikri_Zainal]

The weirdest thing is,

LOOKUP([_THISROW].[Job ID],“Work Orders”,“Unique ID”, “Type of Work”)

This works instead. So when i’m scanning the code, the table indicates what kind of job is the tools being recorded for. So im able to see the Type of Work referenced from the Work Orders table.

[Aleksi]

In generally it would mean that it doesn’t find any values that would match… saying that your Product Barcodes don’t match.

[Zikri_Zainal]

Hi Aleksi,

I’ve however scanned only the items that exist in my inventory. How is it possible that it doesnt return any results?

[Aleksi]

Verify from your spreadsheet that the “Product Barcode” values are identical.