Correct, adapt the formula to your cell references and try it


--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(Remove ^^ from email)


"Chaos2blue" wrote in message
...
It is basically search and display..

for e.g.

If i key in 40.1 at X.. if will search the Column B and display PEN as the
answer.
If i key in 40.2 at X.. it will display PAPER at Y as the answer
If i key in 40.3 at X.. it will display RULER at Y as the answer.

"Peo Sjoblom" wrote:

=VLOOKUP(A2,B2:C10,2,0)

where A2 is where you put 40.2

Put the formula in the cell where you want the result (Y)


--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(Remove ^^ from email)


"Chaos2blue" wrote in message
...
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.