Thread: LOOKUP ARRY
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Lookup formula limitation? Lookup formula limitation? is offline
external usenet poster
  
Posts: 1
Default LOOKUP ARRY
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?
Reply With QuoteReply With Quote