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
2880
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 2, 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 reply

TrowaD
Posts
2880
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 2, 2022
509
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