Re: $$Excel-Macros$$ Need Formula for Lookup Based on a Matrix of Data

2012-02-02 Thread John A. Smith
Noorain, it is no wonder you are honored as most helpful so often. Congratulations and thank you for your help. John On Thu, Jan 26, 2012 at 11:22 AM, NOORAIN ANSARI wrote: > Dear John, > > You can also use in F3... > > > =INDEX(Data!$C$2:$C$37,MATCH(1,(Data!$A$2:$A$37=E3)*(Data!$B$2

Re: $$Excel-Macros$$ Need Formula for Lookup Based on a Matrix of Data

2012-02-02 Thread John A. Smith
ail.com > > *From:* Sourabh Salgotra > *Sent:* Thursday, January 26, 2012 11:04 AM > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Need Formula for Lookup Based on a Matrix > of Data > > plz sir explain this formula i have confusion in this. how

Re: $$Excel-Macros$$ Need Formula for Lookup Based on a Matrix of Data

2012-02-02 Thread John A. Smith
com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *John A. Smith > *Sent:* Jan/Thu/2012 08:49 > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ Need Formula for Lookup Based on a Matrix of > Data > > ** ** > > Thank you for your valuable help.

RE: $$Excel-Macros$$ Need Formula for Lookup Based on a Matrix of Data

2012-01-30 Thread Rajan_Verma
$$ Need Formula for Lookup Based on a Matrix of Data Thank you for your valuable help. I need a formula that will lookup a value based on a column heading, a date column/row and a row qualifier (the word "Total"). Please see the attached spreadsheet. Thank you. John -- F

Re: $$Excel-Macros$$ Need Formula for Lookup Based on a Matrix of Data

2012-01-26 Thread dguillett1
:$1,0)) Don Guillett SalesAid Software dguille...@gmail.com From: NOORAIN ANSARI Sent: Thursday, January 26, 2012 10:22 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Need Formula for Lookup Based on a Matrix of Data Dear John, You can also use

Re: $$Excel-Macros$$ Need Formula for Lookup Based on a Matrix of Data

2012-01-26 Thread dguillett1
,MATCH($E3,Data!$A:$A),MATCH(F$2,Data!$1:$1,0)) Don Guillett SalesAid Software dguille...@gmail.com From: NOORAIN ANSARI Sent: Thursday, January 26, 2012 10:22 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Need Formula for Lookup Based on a Matrix of Data De

Re: $$Excel-Macros$$ Need Formula for Lookup Based on a Matrix of Data

2012-01-26 Thread John A. Smith
2,Data!$1:$1,0)) > > Don Guillett > SalesAid Software > dguille...@gmail.com > > *From:* NOORAIN ANSARI > *Sent:* Thursday, January 26, 2012 10:22 AM > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Need Formula for Lookup Based on a Matrix &g

Re: $$Excel-Macros$$ Need Formula for Lookup Based on a Matrix of Data

2012-01-26 Thread Sourabh Salgotra
> SalesAid Software > dguille...@gmail.com > > *From:* NOORAIN ANSARI > *Sent:* Thursday, January 26, 2012 10:22 AM > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Need Formula for Lookup Based on a Matrix > of Data > > Dear John, > > You can

Re: $$Excel-Macros$$ Need Formula for Lookup Based on a Matrix of Data

2012-01-26 Thread dguillett1
Simpler with no CSE '=INDEX(Data!$A$1:$L$37,MATCH($E3,Data!$A:$A),MATCH(F$2,Data!$1:$1,0)) Don Guillett SalesAid Software dguille...@gmail.com From: NOORAIN ANSARI Sent: Thursday, January 26, 2012 10:22 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Need Formula for L

Re: $$Excel-Macros$$ Need Formula for Lookup Based on a Matrix of Data

2012-01-26 Thread dguillett1
$ Need Formula for Lookup Based on a Matrix of Data Thank you for your valuable help. I need a formula that will lookup a value based on a column heading, a date column/row and a row qualifier (the word "Total"). Please see the attached spreadsheet. Thank you. John -- FORUM RUL

Re: $$Excel-Macros$$ Need Formula for Lookup Based on a Matrix of Data

2012-01-26 Thread NOORAIN ANSARI
Dear John, You can also use in F3... =INDEX(Data!$C$2:$C$37,MATCH(1,(Data!$A$2:$A$37=E3)*(Data!$B$2:$B$37="Total"),0)) with ctrl+Shift+enter See attached sheet. -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://

Re: $$Excel-Macros$$ Need Formula for Lookup Based on a Matrix of Data

2012-01-26 Thread Sam Mathai Chacko
Use in F3 and drag down and across =SUMPRODUCT((Data!$A$2:$A$37=$E3)*(Data!$B$2:$B$37="Total")*OFFSET(Data!$A$2:$A$37,0,MATCH(Dashboard!F$2,Data!$B$1:$L$1,0))) Regards, Sam Mathai Chacko On Thu, Jan 26, 2012 at 8:48 PM, John A. Smith wrote: > Thank you for your valuable help. > > I need a formu