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.
