LOOKUP ARRY
I have 300 products range from 1lb to 200lb, each have differnt shipping price
Example:
A: has 1-160
B: has price for each items, is there a better way to figure out the
price/items?
Thanks
"smartin" wrote:
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?
Dunno. Just curious, why use arrays instead of ranges?
|