ExcelBanter - excel formula

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - excel formula (https://www.excelbanter.com/new-users-excel/256339-excel-formula.html)

Hi
i have this formula
=INDEX(Consol!$A$13:$BD$1000,MATCH($C$13,Consol!$A $13:$A$1000,0),MATCH(D2,Consol!$A$11:$BZ$11,0))

i want to use same formula but this time it has to match more than one cell
and add.

Thanks

See your later post, follow-up there. This .newusers group is very well
attended to by a lot of responders around the world. If you don't get any
response, that probably means responders don't understand what you're after.
So you could try explaining/re-wording it better, paste sample data, show
before/after scenarios, etc
--
Max
Singapore
---
"Rohit" wrote:
i have this formula
=INDEX(Consol!$A$13:$BD$1000,MATCH($C$13,Consol!$A $13:$A$1000,0),MATCH(D2,Consol!$A$11:$BZ$11,0))

i want to use same formula but this time it has to match more than one cell
and add.

Thanks