Any ideas why a reference that works will in 2003 has problems in
The LOOKUP function works just fine, but under strict constraints. The
lookup_vector *must* be sorted in ascending order otherwise you'll get
incorrect results.
The combination of INDEX/MATCH gives more leeway in that the lookup_array
can be either sorted or unsorted.
--
Biff
Microsoft Excel MVP
"george" wrote in message
...
Hey thanks guys-
Ill give the index a try.. Out of curiosity why does the index work better
than a "lookup" ?
Cheers
george
"george" wrote:
I am using a reference shown here =LOOKUP("X",Y11:Y15,X11:X15) to find
a
number in a column to the right of an "X"
0
X 1
2
3
4
In this example the x is next to the number 1, and should return that
value-
however in 2007 excel it seems to show the value 4 when the x is next to
the
2 ( or at least some other number).
Thoughts ideas?
george
|