Inventory check control please help

  • Thread starter Thread starter cioccofiok
  • Start date Start date
C

cioccofiok

This is an example inventory sheet:

A | B | C |
D

1 Code | Serial N. | Description | False/true

2 0001 | 6835HF | MY RASOR | F
3 0002 | 79632F | MY SOAP | F
4 0003 | H8850 | MY UNDERW | F
5
6
7
8
9
10 CHECK ITEM | (input value in A10) Formula located in A11


WHICH FORMULA I HAVE TO USE IF I DIGIT A VALUE ON CELL
A10 (EXACTELY EQUAL TO ONE OF THOSE CONTAINED ON COLUMN
B) AND HAVE AS RESULT THE CHANGE OF VALUE (I.E. from F to T) IN COLUM
D ONLY IN THE ROW IN WHICH THE VALUE IS
CONTAINED ? and also i want to repeat the check until all values
present in stock change the status from "F" to "T"?

mANY THANKS TO BRAVEHEART PEOPL
 
Hi
what do you mean with 'change of value'. to get the entry in column D
is straightfoward (using VLOOKUP). But it seems, you want to get
something different?

Frank
 
Frank I wish to use a barcode scanner.
What i will like to realize is a simple check of items in inventory.
The spreedsheet should be locked for modification but one cell.In thi
cell I will Input (through the barcode or manually) the item codes
Each time a code is found it should say "found" (or something similar
on the same row. Once that item is has been retrieved i input in th
same cell (the only cell modifiable) another item code. Th
spreadsheet, leaving the previous item show "found", it shoul
retreive another item and if retreived show "found" in the same row o
the new item. Sorry if i'm not that clear
english is not my language as you can realize.
Thank you for your consideration.
Cioccofio
 
Back
Top