Needed Help..

C

Chaos2blue

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.
 
P

Peo Sjoblom

=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)
 
C

Chaos2blue

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.
 
C

Chaos2blue

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..?
 
B

Bob Phillips

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

--
HTH

Bob Phillips

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