Hi

i'm a bit confused about your layout
do you have
........A............B........C
1...Party.......Item.....Rate
2...Party1......Item1....50
3...Party2......Item1....74

etc
if so
then if you put in D1 the party you're interested in and in E1 the item
the following formula will return the rate for you
=INDEX(A2:C500,MATCH(D1&E1,A2:A500&B2:B500,0),3)
note - it is an array formula so you need to enter it with control & shift &
enter not just enter

Regards
JulieD

"****al shah" wrote in message
...
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