Any ideas why a reference that works will in 2003 has problems in
On Sat, 19 Jul 2008 10:03:01 -0700, 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
Your formula seems to work fine here. Perhaps some issue with your data?
--ron
|