Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sports Comp Ladder tabulating help needed | Excel Worksheet Functions | |||
Vlookup Alternative Needed | Excel Discussion (Misc queries) | |||
Little more help needed for my IF formula | Excel Discussion (Misc queries) | |||
VLOOKUP help needed! | Excel Worksheet Functions | |||
solver related some financial knowledge may be needed | Excel Discussion (Misc queries) |