Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help using lookup function
I'm having trouble using the lookup function.
I have numbers that look like this in a list, although it's only part of what I'm using: -11 2179 -10 2420 -9 2661 -8 2897 -7 3123 -6 3332 -5 3521 -4 3683 -3 3814 -2 3910 -1 3970 0 3989 1 3970 2 3910 3 3814 4 3683 5 3521 6 3332 7 3123 8 2897 9 2661 10 2420 11 2179 When I use the lookup function on another sheet of the cell, it does not look up the proper value always. My columns go from (-100, 100). Outside the values of (-10,10), the lookup works properly. These are the lookup cells: -11 2179 -10 2420 -9 2420 -8 2897 -7 3123 -6 3332 -5 3521 -4 3521 -3 3814 -2 3814 -1 3910 0 3989 1 3989 2 3910 3 3910 4 3683 5 3521 6 3521 7 3123 8 3123 9 2661 10 2420 11 2179 If you'll notice, the values that the lookup cells get are not the values of the cell they're looking up, but often one off. Any suggestions on why this might be happening? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help using lookup function
What is your lookup equation?
"Blackbird" wrote in message ... I'm having trouble using the lookup function. I have numbers that look like this in a list, although it's only part of what I'm using: -11 2179 -10 2420 -9 2661 -8 2897 -7 3123 -6 3332 -5 3521 -4 3683 -3 3814 -2 3910 -1 3970 0 3989 1 3970 2 3910 3 3814 4 3683 5 3521 6 3332 7 3123 8 2897 9 2661 10 2420 11 2179 When I use the lookup function on another sheet of the cell, it does not look up the proper value always. My columns go from (-100, 100). Outside the values of (-10,10), the lookup works properly. These are the lookup cells: -11 2179 -10 2420 -9 2420 -8 2897 -7 3123 -6 3332 -5 3521 -4 3521 -3 3814 -2 3814 -1 3910 0 3989 1 3989 2 3910 3 3910 4 3683 5 3521 6 3521 7 3123 8 3123 9 2661 10 2420 11 2179 If you'll notice, the values that the lookup cells get are not the values of the cell they're looking up, but often one off. Any suggestions on why this might be happening? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help using lookup function
For instance, the equation for the cell that is to the right of zero is
"=LOOKUP(A104, 'Issue 1'!$E$2:$E$102, 'Issue 1'!$H$2:$H$102)" "Barb Reinhardt" wrote: What is your lookup equation? "Blackbird" wrote in message ... I'm having trouble using the lookup function. I have numbers that look like this in a list, although it's only part of what I'm using: -11 2179 -10 2420 -9 2661 -8 2897 -7 3123 -6 3332 -5 3521 -4 3683 -3 3814 -2 3910 -1 3970 0 3989 1 3970 2 3910 3 3814 4 3683 5 3521 6 3332 7 3123 8 2897 9 2661 10 2420 11 2179 When I use the lookup function on another sheet of the cell, it does not look up the proper value always. My columns go from (-100, 100). Outside the values of (-10,10), the lookup works properly. These are the lookup cells: -11 2179 -10 2420 -9 2420 -8 2897 -7 3123 -6 3332 -5 3521 -4 3521 -3 3814 -2 3814 -1 3910 0 3989 1 3989 2 3910 3 3910 4 3683 5 3521 6 3521 7 3123 8 3123 9 2661 10 2420 11 2179 If you'll notice, the values that the lookup cells get are not the values of the cell they're looking up, but often one off. Any suggestions on why this might be happening? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help using lookup function
If you are looking for an exact match use vlookup or index and match combo
=VLOOKUP(A104,'Issue 1'!E2:H102,4,0) or =INDEX('Issue 1'!H2:H102,MATCH(A104,'Issue 1'!E2:E102,0)) -- Regards, Peo Sjoblom (No private emails please) "Blackbird" wrote in message ... For instance, the equation for the cell that is to the right of zero is "=LOOKUP(A104, 'Issue 1'!$E$2:$E$102, 'Issue 1'!$H$2:$H$102)" "Barb Reinhardt" wrote: What is your lookup equation? "Blackbird" wrote in message ... I'm having trouble using the lookup function. I have numbers that look like this in a list, although it's only part of what I'm using: -11 2179 -10 2420 -9 2661 -8 2897 -7 3123 -6 3332 -5 3521 -4 3683 -3 3814 -2 3910 -1 3970 0 3989 1 3970 2 3910 3 3814 4 3683 5 3521 6 3332 7 3123 8 2897 9 2661 10 2420 11 2179 When I use the lookup function on another sheet of the cell, it does not look up the proper value always. My columns go from (-100, 100). Outside the values of (-10,10), the lookup works properly. These are the lookup cells: -11 2179 -10 2420 -9 2420 -8 2897 -7 3123 -6 3332 -5 3521 -4 3521 -3 3814 -2 3814 -1 3910 0 3989 1 3989 2 3910 3 3910 4 3683 5 3521 6 3521 7 3123 8 3123 9 2661 10 2420 11 2179 If you'll notice, the values that the lookup cells get are not the values of the cell they're looking up, but often one off. Any suggestions on why this might be happening? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help using lookup function
For some reason, neither suggestion gives values all the time now.
Often, I get the #N/A error. However, there most definitely is a value among the series the corresponds, so there shouldn't be an #N/A error. "Peo Sjoblom" wrote: If you are looking for an exact match use vlookup or index and match combo =VLOOKUP(A104,'Issue 1'!E2:H102,4,0) or =INDEX('Issue 1'!H2:H102,MATCH(A104,'Issue 1'!E2:E102,0)) -- Regards, Peo Sjoblom (No private emails please) "Blackbird" wrote in message ... For instance, the equation for the cell that is to the right of zero is "=LOOKUP(A104, 'Issue 1'!$E$2:$E$102, 'Issue 1'!$H$2:$H$102)" "Barb Reinhardt" wrote: What is your lookup equation? "Blackbird" wrote in message ... I'm having trouble using the lookup function. I have numbers that look like this in a list, although it's only part of what I'm using: -11 2179 -10 2420 -9 2661 -8 2897 -7 3123 -6 3332 -5 3521 -4 3683 -3 3814 -2 3910 -1 3970 0 3989 1 3970 2 3910 3 3814 4 3683 5 3521 6 3332 7 3123 8 2897 9 2661 10 2420 11 2179 When I use the lookup function on another sheet of the cell, it does not look up the proper value always. My columns go from (-100, 100). Outside the values of (-10,10), the lookup works properly. These are the lookup cells: -11 2179 -10 2420 -9 2420 -8 2897 -7 3123 -6 3332 -5 3521 -4 3521 -3 3814 -2 3814 -1 3910 0 3989 1 3989 2 3910 3 3910 4 3683 5 3521 6 3521 7 3123 8 3123 9 2661 10 2420 11 2179 If you'll notice, the values that the lookup cells get are not the values of the cell they're looking up, but often one off. Any suggestions on why this might be happening? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help using lookup function
Did you import this? If so you might have hidden spaces trailing html
characters, I just make a quick test and copied the table for your post, pasted into excel and applied a vlookup formula typing in the lookup values and those that I tried I got a correct hit, no errors at all so I can only assume that what you think is a match is not, you can test with a cell that you know should be correct and then compare them =cell=cell2 or even check how many characters =LEN(lookup_Value_cell) =LEN(value_from Table_cell) same number? -- Regards, Peo Sjoblom (No private emails please) "Blackbird" wrote in message ... For some reason, neither suggestion gives values all the time now. Often, I get the #N/A error. However, there most definitely is a value among the series the corresponds, so there shouldn't be an #N/A error. "Peo Sjoblom" wrote: If you are looking for an exact match use vlookup or index and match combo =VLOOKUP(A104,'Issue 1'!E2:H102,4,0) or =INDEX('Issue 1'!H2:H102,MATCH(A104,'Issue 1'!E2:E102,0)) -- Regards, Peo Sjoblom (No private emails please) "Blackbird" wrote in message ... For instance, the equation for the cell that is to the right of zero is "=LOOKUP(A104, 'Issue 1'!$E$2:$E$102, 'Issue 1'!$H$2:$H$102)" "Barb Reinhardt" wrote: What is your lookup equation? "Blackbird" wrote in message ... I'm having trouble using the lookup function. I have numbers that look like this in a list, although it's only part of what I'm using: -11 2179 -10 2420 -9 2661 -8 2897 -7 3123 -6 3332 -5 3521 -4 3683 -3 3814 -2 3910 -1 3970 0 3989 1 3970 2 3910 3 3814 4 3683 5 3521 6 3332 7 3123 8 2897 9 2661 10 2420 11 2179 When I use the lookup function on another sheet of the cell, it does not look up the proper value always. My columns go from (-100, 100). Outside the values of (-10,10), the lookup works properly. These are the lookup cells: -11 2179 -10 2420 -9 2420 -8 2897 -7 3123 -6 3332 -5 3521 -4 3521 -3 3814 -2 3814 -1 3910 0 3989 1 3989 2 3910 3 3910 4 3683 5 3521 6 3521 7 3123 8 3123 9 2661 10 2420 11 2179 If you'll notice, the values that the lookup cells get are not the values of the cell they're looking up, but often one off. Any suggestions on why this might be happening? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup Function help | Excel Discussion (Misc queries) | |||
Lookup Function Problems | Excel Worksheet Functions | |||
Complicated lookup function | Excel Worksheet Functions | |||
lookup function 1 | Excel Worksheet Functions | |||
How do I use 3 cells to create the string for a lookup function? | Excel Worksheet Functions |