Your index/match formula will return one intersection point, ie the value
where the row match & column match intersects. Maybe try re-explaining with a
small-sized sample data (what you have), and what you want to happen, take us
through your logic, show us the expected results based on that sample data.
--
Max
Singapore
---
"Rohit" wrote:
i got this formula

=INDEX($A$13:$BD$1000,MATCH($C$13,$A$13:$A$1000,0) ,MATCH(D2,$A$11:$BZ$11,0))

i want to use the same formual but this time to match more than cell.

thanks