so i want match from $C$13:$C$15 and return value as agregated. eg if it
match C13 where is $100, C14=$100 and C15=$100, therefore the return value
should be $300.

basically i want to sum the match cells (C13:C15)

hope it help

"Max" wrote:

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