About D_Fratus

D_Fratus · 07-13-2020

So I have a sheet that has 3 main columns, “LOT#”, “Barcode”, and “Item”. I have this sheet as a supply’s out and it refers back to the supply sheet to look up items based on the LOT# or Bar code. These have expiration and some have a unique bar code...

D_Fratus · 07-13-2020

LeventK: IF( ISNOTBLANK([LOT#]), LOOKUP([_THISROW].[LOT#], “Supply Total”, “LOT#”, “Item”), LOOKUP([_THISROW].[Barcode], “Supply Total”, “Barcode”, “Item”) ) Thank you so much!! I knew it would be something simple.

My Stats

luizjunior's Bio

Badges D_Fratus Earned

Recent Activity

Initial value based on one of 2 other fields (Columns)

Re: Initial value based on one of 2 other fields (Columns)