Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sports Comp Ladder tabulating help needed | Excel Worksheet Functions | |||
Vlookup Alternative Needed | Excel Discussion (Misc queries) | |||
Little more help needed for my IF formula | Excel Discussion (Misc queries) | |||
VLOOKUP help needed! | Excel Worksheet Functions | |||
solver related some financial knowledge may be needed | Excel Discussion (Misc queries) |