LOOKUP ARRY
What version of excel are you using?
In xl2003, your formulas can only be 1024 characters long (when measured in R1C1
reference style).
Lookup formula limitation? wrote:
I have 160 number in column A and 160 numbers in Column B.....
Lookup let me to compair only 80?
=lookpu(A1,{1,2,3,4,5.........160},{10,20,30,..... .......1600})
How come excel let me do up to 80, not 160?
--
Dave Peterson
|