Why sometimes I find empty cells when users add new line of data?

[vaulltz]

Say i have 3 columns of table labelled A, B, and C which serves as a barcode scanner to scan the tools that are being used for maintenance work daily. 

I have a lot of reference from different table to look up the scanned item's detail for column B and C.

1. 6 technicians use this to track their respective team's work for that day.

2. However, the scanned items have missing information in column B or C.

3. It doesn't happen regularly but I can see some sparse in the sheet, as if its like a bug.

4. I have to manually key in the data that I know of myself. But this can be a bit tedious and defeat the purpose of building this function.

5. Can anyone help me with this?

[SkrOYC]

Can you point here which are the configs of column B and C?

[vaulltz]

Hi thank you for taking the time.

I think leakages are present with this code:

LOOKUP([_THISROW].[Scanned Barcode],"Hot Sticks","Product Barcode", "Tool Description")

Is there a better formula to get the details of the related tools when scanned based on the product barcode. 

Some users experience no problem, but some users I noticed that the data is not captured at all.

Thank you

[vaulltz]

It happened again today. See the green boxes, on column 'Tool Team'? 

Some are filled, but some are empty. And that goes for other columns if you can see it.

Why this keeps happening?

I cant keep monitoring the Google Sheet for errors!

PLS HELP ME!

[Steve]

The obvious question is: are there values for the columns in the lookup table in a row with the given key?