Check condition

[Excelaser_Gmbh]

Hello,

I want to check if the scaned “labelnumber” already existing in table “receiving” column “labelnumber” and the column “material movement type” in table “receiving” in the same row than the labelnumber is out. If both is true the data is valid.

Please can you help me?

Thank you in advance,
Kai

[SantiagoU]

Hi Excelaser, apologies for not getting a response on this earlier. Were you able to figure it out? It seems you want to write a LOOLKUP() or a SELECT() expression. You could do something like AND(LOOKUP(First lookup condition)=[Number scanned], LOOKUP(Second lookup condition)=[Number scanned]

help.appsheet.com

LOOKUP()

Get column value from row in table or slice

Hope this helps.
Santiago

[Steve]

Try as the labelnumber column’s Valid If expression:

ISNOTBLANK(
  FILTER(
    "receiving",
    AND(
      ([_THISROW].[labelnumber] = [labelnumber]),
      ("out" = [material movement type])
    )
  )
)