LOOKUP ARRY
In your example it looks like you want to multiply by 10 - can't you
just do:
=A1*10
or is your example not representative?
Pete
On Aug 17, 3:17*am, Lookup formula limitation? <Lookup formula
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?
|