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
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