Lookup formula limitation? wrote:
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?


So if you know the shipping price of each item, why not make a master
table in Sheet1 with 300 items in column A and shipping prices in column
B. Then when you need to know the shipping price in another worksheet, use

=VLOOKUP(A1,Sheet1!$A$1:$B$301,2,FALSE)

or am I totally missing something?