|
Needed Help..
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. |
Needed Help..
=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. |
Needed Help..
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. |
Needed Help..
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. |
Needed Help..
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. |
Needed Help..
=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. |
| All times are GMT +1. The time now is 03:26 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com