Required value as per the scanned data

Closed
mebaznm14 Posts 1 Registration date Sunday March 25, 2018 Status Member Last seen March 25, 2018 - Updated on Mar 25, 2018 at 04:47 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Mar 27, 2018 at 11:23 AM
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 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Mar 27, 2018 at 11:23 AM
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
0