Required value as per the scanned data

[Closed]
Report
Posts
1
Registration date
Sunday March 25, 2018
Status
Member
Last seen
March 25, 2018
-
Posts
2818
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 18, 2021
-
Hi Everyone,

I use VLOOKUP on a very frequent basis for my day to day work.

I have a sheet full of data of inventory while doing my stocks audit. When I scan the bar code in column "A", then in the adjacent cells I get the details of that bar code. As per the below figure.





But my issue is, whenever I scan the bar code I want the Scan Qty (Col K) value to be numeric "1" once the values of the scanned bar codes are retrieved or else the value in scan qty (Col K) should be numeric "0" only.

Please help me with this.

1 reply

Posts
2818
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 18, 2021
486
Hi Mebaznm14,

Give the following formula a try for column K:
=IF(A2="",0,1)

If A2 is empty then result is 0, otherwise 1.

Best regards,
Trowa