Dear sir,
i am using index/match formula. in my problem i am getting the
1st occurrence result only.
Sr. No. Subject Code Subject/Paper code 1 BF 1 MATHEMATICS I 2
#NUM! #NUM! 3 #NUM! #NUM! 4 #NUM! #NUM! 5 #NUM!
#NUM! 6 #NUM! #NUM!
Hi,
Use Vlookup formula, I think it should help you.
Rgds
On Sun, Jun 3, 2012 at 1:08 PM, Sourabh Salgotra wrote:
>
> Dear sir,
>i am using index/match formula. in my problem i am getting the
> 1st occurrence result only.
> Sr. No. Subject Code Subject/Paper code 1 BF 1 MAT
: Don Guillett ; rajanverma1...@gmail.com ; noorain.ans...@gmail.com
Subject: $$Excel-Macros$$ Records found but unable to get proper result.
Dear sir,
i am using index/match formula. in my problem i am getting the 1st
occurrence result only.
Sr. No. Subject Code Subject/Paper
>
>
> Don Guillett
> Microsoft MVP Excel
> SalesAid Software
> dguille...@gmail.com
>
> *From:* Sourabh Salgotra
> *Sent:* Sunday, June 03, 2012 5:08 AM
> *To:* excel-macros@googlegroups.com
> *Cc:* Don Guillett ; rajanverma1...@gmail.com ;
> noorain.ans...@gm
I like my solution.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Sourabh Salgotra
Sent: Sunday, June 03, 2012 12:53 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Records found but unable to get proper result.
thanks for help.
plz provide
Don,
love it (great reply) :)
Pawel
From: dguillett1
To: excel-macros@googlegroups.com
Sent: Sunday, June 3, 2012 6:55 PM
Subject: Re: $$Excel-Macros$$ Records found but unable to get proper result.
I like my solution.
Don
Guillett
Microsoft MVP
--
> *From:* dguillett1
> *To:* excel-macros@googlegroups.com
> *Sent:* Sunday, June 3, 2012 6:55 PM
>
> *Subject:* Re: $$Excel-Macros$$ Records found but unable to get proper
> result.
>
> I like my solution.
>
> Don Guillett
> Microsoft MVP
> I like my solution.
>>>
>>> Don Guillett
>>> Microsoft MVP Excel
>>> SalesAid Software
>>> dguille...@gmail.com
>>>
>>> *From:* Sourabh Salgotra
>>> *Sent:* Sunday, June 03, 2012 12:53 PM
>>> *To:* excel