inventory check helpers blessed

[cioccofiok]

This is an example inventory sheet:

A | B | C
D

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

2 XYZ2 | 6835HF | MY RASOR |
3 XYW1 | 79632F | MY SOAP |
4 YSW2 | H8850 | MY UNDERW |



10 CHECK ITEM | *


* WHICH FORMULA I HAVE TO USE IF I INPUT A VALUE ON CELL
C10 (EXACTELY EQUAL TO ONE OF THOSE CONTAINED ON COLUMN
B) AND HAVE AS RESULT THE CHANGE OF VALUE (I.E. F or T; 1 or
2) IN COLUMN D ONLY IN THE ROW IN WHICH THE VALUE IS
CONTAINED ?

mANY THANKS TO BRAVEHEART PEOPL

 

[Frank Kabel]

Hi
if you want to get the value from column D for a specific value in
column B try
=VLOOKUP(B10,B17,3,0)
where B10 is your input value

Frank