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.