Thread: Needed Help..
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Chaos2blue Chaos2blue is offline
external usenet poster
 
Posts: 3
Default 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.