Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup Function Referencing cells, not text values
I want to use the Lookup function to reference cell values, not just
hand-entered values. For example: Column A Column B 1 23 2 45 3 65 4 78 5 93 I then want to enter a value into cell A9 and have a lookup function in cell B9 that looks like this: =LOOKUP(A9,{A1,A2,A3,A4,A5},{B1,B2,B3,B4,B5}) The lookup function works by entering in the corresponding values by hand into the cell: =LOOKUP(A9,{1,2,3,4,5},{23,45,65,78,93}) But that's not what I need! I appreciate any help. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup Function Referencing cells, not text values
Lookat VLOOKUP function:
in B9: =VLOOKUP(A9,A1:B5,2,FALSE) HTH "Justin" wrote: I want to use the Lookup function to reference cell values, not just hand-entered values. For example: Column A Column B 1 23 2 45 3 65 4 78 5 93 I then want to enter a value into cell A9 and have a lookup function in cell B9 that looks like this: =LOOKUP(A9,{A1,A2,A3,A4,A5},{B1,B2,B3,B4,B5}) The lookup function works by entering in the corresponding values by hand into the cell: =LOOKUP(A9,{1,2,3,4,5},{23,45,65,78,93}) But that's not what I need! I appreciate any help. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup Function Referencing cells, not text values
That did not work. Is the "2" in the formula referencing the second column of
values? "Toppers" wrote: Lookat VLOOKUP function: in B9: =VLOOKUP(A9,A1:B5,2,FALSE) HTH "Justin" wrote: I want to use the Lookup function to reference cell values, not just hand-entered values. For example: Column A Column B 1 23 2 45 3 65 4 78 5 93 I then want to enter a value into cell A9 and have a lookup function in cell B9 that looks like this: =LOOKUP(A9,{A1,A2,A3,A4,A5},{B1,B2,B3,B4,B5}) The lookup function works by entering in the corresponding values by hand into the cell: =LOOKUP(A9,{1,2,3,4,5},{23,45,65,78,93}) But that's not what I need! I appreciate any help. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup Function Referencing cells, not text values
You can use simply
=LOOKUP(A9,A1:B5) but it depends on the data and the results you require. This requires A1:A5 to be sorted ascending and will give a result where there is not an exact match, so, given your example if A9 contains 2.5 the above will return 45 "Justin" wrote: I want to use the Lookup function to reference cell values, not just hand-entered values. For example: Column A Column B 1 23 2 45 3 65 4 78 5 93 I then want to enter a value into cell A9 and have a lookup function in cell B9 that looks like this: =LOOKUP(A9,{A1,A2,A3,A4,A5},{B1,B2,B3,B4,B5}) The lookup function works by entering in the corresponding values by hand into the cell: =LOOKUP(A9,{1,2,3,4,5},{23,45,65,78,93}) But that's not what I need! I appreciate any help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating only non-empty cells... | Excel Worksheet Functions | |||
Text entries behaving like numbers | Excel Discussion (Misc queries) | |||
Formulas dealing with text data | Excel Worksheet Functions | |||
how do I insert a function that chooses between two text values? | Excel Worksheet Functions | |||
LOOKUP FUNCTION WITH SUMS VALUES | Excel Discussion (Misc queries) |