If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
excel formula
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 |
#2
|
|||
|
|||
excel formula
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 |
Thread Tools | |
Display Modes | |
|
|