=INDEX(B2:B10,MATCH("Paper",C2:C10,0))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Chaos2blue" wrote in message
...
Thank you... it works.. but i do have another problem.

If at the same place if i key in PAPER at X.. how to make it shows 40.2 at
Y.

How do i go about doing this? can both the fomula mix together..?





"Peo Sjoblom" wrote:

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.