Required value as per the scanned data

Closed
mebaznm14 Posts 1 Registration date Sunday 25 March 2018 Status Member Last seen 25 March 2018 - 25 Mar 2018 à 03:13
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 27 Mar 2018 à 11:23
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.
Related:

1 response

TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 555
27 Mar 2018 à 11:23
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