Needed Help..
What function i need to use for searching and calling up a value.
For example
A B C
-----------------------------------------
Row1 ”‚ X ”‚ 40.1 ”‚ Pen ”‚
-----------------------------------------
Row2 ”‚ ”‚ 40.2 ”‚ Paper ”‚
-----------------------------------------
Row3 ”‚ Y ”‚ 40.3 ”‚ Ruler ”‚
-----------------------------------------
The value i enter at X will be search in the column B which it will display
what it is at C and shows its result at Y.
e.g. if i enter a value 40.2 at X.. if will search and display Paper at Y.
how do i go about doing this.
|