View Single Post
  #1   Report Post  
shital shah
 
Posts: n/a
Default How to do two way lookup for more than 400 row & Coulmn?

hi to all
how do i match the party name & item to find rate of perticular party for
perticular item.
I want to do two way lookup, but there are not more than 256 column

I have data like
NameofParty in ROWs more than 500 and item1, item2, item3,...........more
than 400 in columns. which way i can find rate of party with item pls. help
me.

****al shah