Re: $$Excel-Macros$$ please help me to solve this question it's very urgent

2012-08-31 Thread dguillett1
The "team" will be happier to help if you use a meaningful subject line and 
lose the URGENT!!!




Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
-Original Message- 
From: PRAVESH KUMAR

Sent: Friday, August 31, 2012 1:09 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ please help me to solve this question it's 
very urgent


Hi team,


Thanks so much for help me and give best to best Suggestions

Thanks
Pravesh Kumar


On 8/30/12, Kuldeep Singh  wrote:

Dear Preavesh,

04 solutions of you. for any query please see attachment.

=LOOKUP(H3,$C$3:$D$9)
=VLOOKUP(H3:H6,$C$3:$D$9,2,0)
=VLOOKUP(H3,$C$3:$D$9,2,0)
=IF(MATCH(G3,$B$3:$B$9,0),VLOOKUP(H3,$C$3:$D$9,2,0))

Regards,
Kuldeep Singh

On Thu, Aug 30, 2012 at 10:23 AM, Amresh Maurya
wrote:


Hi Pravesh,

Find the attached solved file.

=IF(MATCH(G3,$B$3:$B$9,0),VLOOKUP(H3,$C$3:$D$9,2,0))

Reagrds
Amresh

On Thu, Aug 30, 2012 at 10:14 AM, Priyanka Vaish <
vaishpriyanka2...@gmail.com> wrote:


Hi Pravesh,

  =VLOOKUP($H3,$C$3:$D$9,2,0)

I think this formula would solve your question.

On Thu, Aug 30, 2012 at 10:00 AM, PRAVESH KUMAR
 wrote:


Hi Team,

please help me to solve this question it's very urgent


waiting your response



--

Thanks & Regards

Pravesh Kumar

--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
will not get quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security
measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum
in
signatures are prohibited.

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not
allowed.

NOTE  : Don't ever post personal or confidential data in a workbook.
Forum owners and members are not responsible for any loss.
---
You received this message because you are subscribed to the Google
Groups "MS EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to
excel-macros+unsubscr...@googlegroups.com.




 --
Join official facebook page of this forum @
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
will not get quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security
measure.

4) Acknowledge the responses you receive, good or bad.

5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE : Don't ever post personal or confidential data in a workbook.
Forum
owners and members are not responsible for any loss.
---
You received this message because you are subscribed to the Google
Groups
"MS EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to
excel-macros+unsubscr...@googlegroups.com.





 --
Join official facebook page of this forum @
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
will not get quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security
measure.

4) Acknowledge the responses you receive, good or bad.

5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups
"MS EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to
excel-macros+unsubscr...@googlegroups.com.



--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concis

Re: $$Excel-Macros$$ please help me to solve this question it's very urgent

2012-08-31 Thread PRAVESH KUMAR
Hi amresh,

Thanks! for help me


On 8/30/12, Amresh Maurya  wrote:
> Hi Pravesh,
>
> Find the attached solved file.
>
> =IF(MATCH(G3,$B$3:$B$9,0),VLOOKUP(H3,$C$3:$D$9,2,0))
>
> Reagrds
> Amresh
>
> On Thu, Aug 30, 2012 at 10:14 AM, Priyanka Vaish <
> vaishpriyanka2...@gmail.com> wrote:
>
>> Hi Pravesh,
>>
>>   =VLOOKUP($H3,$C$3:$D$9,2,0)
>>
>> I think this formula would solve your question.
>>
>> On Thu, Aug 30, 2012 at 10:00 AM, PRAVESH KUMAR
>> wrote:
>>
>>> Hi Team,
>>>
>>> please help me to solve this question it's very urgent
>>>
>>>
>>> waiting your response
>>>
>>>
>>>
>>> --
>>>
>>> Thanks & Regards
>>>
>>> Pravesh Kumar
>>>
>>> --
>>> Join official facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES (1120+ members already BANNED for violation)
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>>
>>> 2) Don't post a question in the thread of another member.
>>>
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>>
>>> 4) Acknowledge the responses you receive, good or bad.
>>>
>>> 5)  Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> 6) Jobs posting is not allowed.
>>>
>>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>>>
>>> NOTE  : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups
>>> "MS EXCEL AND VBA MACROS" group.
>>> To post to this group, send email to excel-macros@googlegroups.com.
>>> To unsubscribe from this group, send email to
>>> excel-macros+unsubscr...@googlegroups.com.
>>>
>>>
>>>
>>  --
>> Join official facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES (1120+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> 6) Jobs posting is not allowed.
>>
>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> To unsubscribe from this group, send email to
>> excel-macros+unsubscr...@googlegroups.com.
>>
>>
>>
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
> not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5)  Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE  : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>


-- 

Thanks & Regards

Pravesh Kumar

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competit

Re: $$Excel-Macros$$ please help me to solve this question it's very urgent

2012-08-31 Thread Kuldeep Singh
Dear Pravesh,

Your most welcome.

Regards,
Kuldeep Singh

On Fri, Aug 31, 2012 at 11:39 PM, PRAVESH KUMAR wrote:

> Hi team,
>
>
> Thanks so much for help me and give best to best Suggestions
>
> Thanks
> Pravesh Kumar
>
>
> On 8/30/12, Kuldeep Singh  wrote:
> > Dear Preavesh,
> >
> > 04 solutions of you. for any query please see attachment.
> >
> > =LOOKUP(H3,$C$3:$D$9)
> > =VLOOKUP(H3:H6,$C$3:$D$9,2,0)
> > =VLOOKUP(H3,$C$3:$D$9,2,0)
> > =IF(MATCH(G3,$B$3:$B$9,0),VLOOKUP(H3,$C$3:$D$9,2,0))
> >
> > Regards,
> > Kuldeep Singh
> >
> > On Thu, Aug 30, 2012 at 10:23 AM, Amresh Maurya
> > wrote:
> >
> >> Hi Pravesh,
> >>
> >> Find the attached solved file.
> >>
> >> =IF(MATCH(G3,$B$3:$B$9,0),VLOOKUP(H3,$C$3:$D$9,2,0))
> >>
> >> Reagrds
> >> Amresh
> >>
> >> On Thu, Aug 30, 2012 at 10:14 AM, Priyanka Vaish <
> >> vaishpriyanka2...@gmail.com> wrote:
> >>
> >>> Hi Pravesh,
> >>>
> >>>   =VLOOKUP($H3,$C$3:$D$9,2,0)
> >>>
> >>> I think this formula would solve your question.
> >>>
> >>> On Thu, Aug 30, 2012 at 10:00 AM, PRAVESH KUMAR
> >>>  >>> > wrote:
> >>>
>  Hi Team,
> 
>  please help me to solve this question it's very urgent
> 
> 
>  waiting your response
> 
> 
> 
>  --
> 
>  Thanks & Regards
> 
>  Pravesh Kumar
> 
>  --
>  Join official facebook page of this forum @
>  https://www.facebook.com/discussexcel
> 
>  FORUM RULES (1120+ members already BANNED for violation)
> 
>  1) Use concise, accurate thread titles. Poor thread titles, like
> Please
>  Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
> Advice
>  will not get quick attention or may not be answered.
> 
>  2) Don't post a question in the thread of another member.
> 
>  3) Don't post questions regarding breaking or bypassing any security
>  measure.
> 
>  4) Acknowledge the responses you receive, good or bad.
> 
>  5)  Cross-promotion of, or links to, forums competitive to this forum
>  in
>  signatures are prohibited.
> 
>  6) Jobs posting is not allowed.
> 
>  7) Sharing copyrighted ebooks/pirated ebooks/their links is not
>  allowed.
> 
>  NOTE  : Don't ever post personal or confidential data in a workbook.
>  Forum owners and members are not responsible for any loss.
>  ---
>  You received this message because you are subscribed to the Google
>  Groups "MS EXCEL AND VBA MACROS" group.
>  To post to this group, send email to excel-macros@googlegroups.com.
>  To unsubscribe from this group, send email to
>  excel-macros+unsubscr...@googlegroups.com.
> 
> 
> 
> >>>  --
> >>> Join official facebook page of this forum @
> >>> https://www.facebook.com/discussexcel
> >>>
> >>> FORUM RULES (1120+ members already BANNED for violation)
> >>>
> >>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> >>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> >>> will not get quick attention or may not be answered.
> >>>
> >>> 2) Don't post a question in the thread of another member.
> >>>
> >>> 3) Don't post questions regarding breaking or bypassing any security
> >>> measure.
> >>>
> >>> 4) Acknowledge the responses you receive, good or bad.
> >>>
> >>> 5) Cross-promotion of, or links to, forums competitive to this forum in
> >>> signatures are prohibited.
> >>>
> >>> 6) Jobs posting is not allowed.
> >>>
> >>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not
> allowed.
> >>>
> >>> NOTE : Don't ever post personal or confidential data in a workbook.
> >>> Forum
> >>> owners and members are not responsible for any loss.
> >>> ---
> >>> You received this message because you are subscribed to the Google
> >>> Groups
> >>> "MS EXCEL AND VBA MACROS" group.
> >>> To post to this group, send email to excel-macros@googlegroups.com.
> >>> To unsubscribe from this group, send email to
> >>> excel-macros+unsubscr...@googlegroups.com.
> >>>
> >>>
> >>>
> >>
> >>  --
> >> Join official facebook page of this forum @
> >> https://www.facebook.com/discussexcel
> >>
> >> FORUM RULES (1120+ members already BANNED for violation)
> >>
> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> >> will not get quick attention or may not be answered.
> >>
> >> 2) Don't post a question in the thread of another member.
> >>
> >> 3) Don't post questions regarding breaking or bypassing any security
> >> measure.
> >>
> >> 4) Acknowledge the responses you receive, good or bad.
> >>
> >> 5) Cross-promotion of, or links to, forums competitive to this forum in
> >> signatures are prohibited.
> >>
> >> 6) Jobs posting is not allowed.
> >>
> >> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
> >>
> >> NOTE : Don't ever post personal or confidential data in a workbook.
> Forum
> >> o

Re: $$Excel-Macros$$ please help me to solve this question it's very urgent

2012-08-31 Thread PRAVESH KUMAR
Hi team,


Thanks so much for help me and give best to best Suggestions

Thanks
Pravesh Kumar


On 8/30/12, Kuldeep Singh  wrote:
> Dear Preavesh,
>
> 04 solutions of you. for any query please see attachment.
>
> =LOOKUP(H3,$C$3:$D$9)
> =VLOOKUP(H3:H6,$C$3:$D$9,2,0)
> =VLOOKUP(H3,$C$3:$D$9,2,0)
> =IF(MATCH(G3,$B$3:$B$9,0),VLOOKUP(H3,$C$3:$D$9,2,0))
>
> Regards,
> Kuldeep Singh
>
> On Thu, Aug 30, 2012 at 10:23 AM, Amresh Maurya
> wrote:
>
>> Hi Pravesh,
>>
>> Find the attached solved file.
>>
>> =IF(MATCH(G3,$B$3:$B$9,0),VLOOKUP(H3,$C$3:$D$9,2,0))
>>
>> Reagrds
>> Amresh
>>
>> On Thu, Aug 30, 2012 at 10:14 AM, Priyanka Vaish <
>> vaishpriyanka2...@gmail.com> wrote:
>>
>>> Hi Pravesh,
>>>
>>>   =VLOOKUP($H3,$C$3:$D$9,2,0)
>>>
>>> I think this formula would solve your question.
>>>
>>> On Thu, Aug 30, 2012 at 10:00 AM, PRAVESH KUMAR
>>> >> > wrote:
>>>
 Hi Team,

 please help me to solve this question it's very urgent


 waiting your response



 --

 Thanks & Regards

 Pravesh Kumar

 --
 Join official facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES (1120+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5)  Cross-promotion of, or links to, forums competitive to this forum
 in
 signatures are prohibited.

 6) Jobs posting is not allowed.

 7) Sharing copyrighted ebooks/pirated ebooks/their links is not
 allowed.

 NOTE  : Don't ever post personal or confidential data in a workbook.
 Forum owners and members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google
 Groups "MS EXCEL AND VBA MACROS" group.
 To post to this group, send email to excel-macros@googlegroups.com.
 To unsubscribe from this group, send email to
 excel-macros+unsubscr...@googlegroups.com.



>>>  --
>>> Join official facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES (1120+ members already BANNED for violation)
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>>
>>> 2) Don't post a question in the thread of another member.
>>>
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>>
>>> 4) Acknowledge the responses you receive, good or bad.
>>>
>>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> 6) Jobs posting is not allowed.
>>>
>>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum
>>> owners and members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups
>>> "MS EXCEL AND VBA MACROS" group.
>>> To post to this group, send email to excel-macros@googlegroups.com.
>>> To unsubscribe from this group, send email to
>>> excel-macros+unsubscr...@googlegroups.com.
>>>
>>>
>>>
>>
>>  --
>> Join official facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES (1120+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> 6) Jobs posting is not allowed.
>>
>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> To unsubscribe from this group, send email to
>> excel-macros+unsubscr...@googlegroups.com.
>>
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM 

Re: $$Excel-Macros$$ please help me to solve this question it's very urgent

2012-08-30 Thread dguillett1

I see you have answers but why is YOUR request more URGENT than any other?
Also, use a meaningful subject line and explain your question in the email 
and in the file.

etc.



Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
-Original Message- 
From: PRAVESH KUMAR

Sent: Wednesday, August 29, 2012 11:30 PM
To: excel-macros ; excelvbaclinic
Subject: $$Excel-Macros$$ please help me to solve this question it's very 
urgent


Hi Team,

please help me to solve this question it's very urgent


waiting your response



--

Thanks & Regards

Pravesh Kumar

--
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel


FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please 
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will 
not get quick attention or may not be answered.


2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security 
measure.


4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited.


6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups 
"MS EXCEL AND VBA MACROS" group.

To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.



--
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 


6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group.

To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.




Re: $$Excel-Macros$$ please help me to solve this question it's very urgent

2012-08-29 Thread अनिल नारायण गवली
Dear Pravesh,

Enclosed herewith your query solu

Regards,
Gawli Anil
On Thu, Aug 30, 2012 at 10:26 AM, Kuldeep Singh wrote:

>
> Dear Preavesh,
>
> 04 solutions of you. for any query please see attachment.
>
> =LOOKUP(H3,$C$3:$D$9)
> =VLOOKUP(H3:H6,$C$3:$D$9,2,0)
> =VLOOKUP(H3,$C$3:$D$9,2,0)
> =IF(MATCH(G3,$B$3:$B$9,0),VLOOKUP(H3,$C$3:$D$9,2,0))
>
> Regards,
> Kuldeep Singh
>
>
> On Thu, Aug 30, 2012 at 10:23 AM, Amresh Maurya 
> wrote:
>
>> Hi Pravesh,
>>
>> Find the attached solved file.
>>
>> =IF(MATCH(G3,$B$3:$B$9,0),VLOOKUP(H3,$C$3:$D$9,2,0))
>>
>> Reagrds
>> Amresh
>>
>>  On Thu, Aug 30, 2012 at 10:14 AM, Priyanka Vaish <
>> vaishpriyanka2...@gmail.com> wrote:
>>
>>> Hi Pravesh,
>>>
>>>   =VLOOKUP($H3,$C$3:$D$9,2,0)
>>>
>>> I think this formula would solve your question.
>>>
>>> On Thu, Aug 30, 2012 at 10:00 AM, PRAVESH KUMAR <
>>> praveshkash...@gmail.com> wrote:
>>>
 Hi Team,

 please help me to solve this question it's very urgent


 waiting your response



 --

 Thanks & Regards

 Pravesh Kumar

 --
 Join official facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES (1120+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5)  Cross-promotion of, or links to, forums competitive to this forum
 in signatures are prohibited.

 6) Jobs posting is not allowed.

 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

 NOTE  : Don't ever post personal or confidential data in a workbook.
 Forum owners and members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google
 Groups "MS EXCEL AND VBA MACROS" group.
 To post to this group, send email to excel-macros@googlegroups.com.
 To unsubscribe from this group, send email to
 excel-macros+unsubscr...@googlegroups.com.



>>> --
>>> Join official facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES (1120+ members already BANNED for violation)
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>>
>>> 2) Don't post a question in the thread of another member.
>>>
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>>
>>> 4) Acknowledge the responses you receive, good or bad.
>>>
>>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> 6) Jobs posting is not allowed.
>>>
>>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To post to this group, send email to excel-macros@googlegroups.com.
>>> To unsubscribe from this group, send email to
>>> excel-macros+unsubscr...@googlegroups.com.
>>>
>>>
>>>
>>
>>  --
>> Join official facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES (1120+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> 6) Jobs posting is not allowed.
>>
>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> To unsubscribe from this group, send email to
>> excel-macros+unsubscr...@googlegroups.com.
>>
>  --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> F

Re: $$Excel-Macros$$ please help me to solve this question it's very urgent

2012-08-29 Thread Kuldeep Singh
Dear Preavesh,

04 solutions of you. for any query please see attachment.

=LOOKUP(H3,$C$3:$D$9)
=VLOOKUP(H3:H6,$C$3:$D$9,2,0)
=VLOOKUP(H3,$C$3:$D$9,2,0)
=IF(MATCH(G3,$B$3:$B$9,0),VLOOKUP(H3,$C$3:$D$9,2,0))

Regards,
Kuldeep Singh

On Thu, Aug 30, 2012 at 10:23 AM, Amresh Maurya wrote:

> Hi Pravesh,
>
> Find the attached solved file.
>
> =IF(MATCH(G3,$B$3:$B$9,0),VLOOKUP(H3,$C$3:$D$9,2,0))
>
> Reagrds
> Amresh
>
> On Thu, Aug 30, 2012 at 10:14 AM, Priyanka Vaish <
> vaishpriyanka2...@gmail.com> wrote:
>
>> Hi Pravesh,
>>
>>   =VLOOKUP($H3,$C$3:$D$9,2,0)
>>
>> I think this formula would solve your question.
>>
>> On Thu, Aug 30, 2012 at 10:00 AM, PRAVESH KUMAR > > wrote:
>>
>>> Hi Team,
>>>
>>> please help me to solve this question it's very urgent
>>>
>>>
>>> waiting your response
>>>
>>>
>>>
>>> --
>>>
>>> Thanks & Regards
>>>
>>> Pravesh Kumar
>>>
>>> --
>>> Join official facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES (1120+ members already BANNED for violation)
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>>
>>> 2) Don't post a question in the thread of another member.
>>>
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>>
>>> 4) Acknowledge the responses you receive, good or bad.
>>>
>>> 5)  Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> 6) Jobs posting is not allowed.
>>>
>>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>>>
>>> NOTE  : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To post to this group, send email to excel-macros@googlegroups.com.
>>> To unsubscribe from this group, send email to
>>> excel-macros+unsubscr...@googlegroups.com.
>>>
>>>
>>>
>>  --
>> Join official facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES (1120+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> 6) Jobs posting is not allowed.
>>
>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> To unsubscribe from this group, send email to
>> excel-macros+unsubscr...@googlegroups.com.
>>
>>
>>
>
>  --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post 

Re: $$Excel-Macros$$ please help me to solve this question it's very urgent

2012-08-29 Thread Amresh Maurya
Hi Pravesh,

Find the attached solved file.

=IF(MATCH(G3,$B$3:$B$9,0),VLOOKUP(H3,$C$3:$D$9,2,0))

Reagrds
Amresh

On Thu, Aug 30, 2012 at 10:14 AM, Priyanka Vaish <
vaishpriyanka2...@gmail.com> wrote:

> Hi Pravesh,
>
>   =VLOOKUP($H3,$C$3:$D$9,2,0)
>
> I think this formula would solve your question.
>
> On Thu, Aug 30, 2012 at 10:00 AM, PRAVESH KUMAR 
> wrote:
>
>> Hi Team,
>>
>> please help me to solve this question it's very urgent
>>
>>
>> waiting your response
>>
>>
>>
>> --
>>
>> Thanks & Regards
>>
>> Pravesh Kumar
>>
>> --
>> Join official facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES (1120+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5)  Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> 6) Jobs posting is not allowed.
>>
>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>>
>> NOTE  : Don't ever post personal or confidential data in a workbook.
>> Forum owners and members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> To unsubscribe from this group, send email to
>> excel-macros+unsubscr...@googlegroups.com.
>>
>>
>>
>  --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.




Question- sOLVED.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet


Re: $$Excel-Macros$$ please help me to solve this question it's very urgent

2012-08-29 Thread Priyanka Vaish
Hi Pravesh,

  =VLOOKUP($H3,$C$3:$D$9,2,0)

I think this formula would solve your question.

On Thu, Aug 30, 2012 at 10:00 AM, PRAVESH KUMAR wrote:

> Hi Team,
>
> please help me to solve this question it's very urgent
>
>
> waiting your response
>
>
>
> --
>
> Thanks & Regards
>
> Pravesh Kumar
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5)  Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE  : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.




Re: $$Excel-Macros$$ please help me to solve this question it's very urgent

2012-08-29 Thread Ashish Bhalara
Mr. Pravesh

See the attached file and kindly refer the forum rules, the subject line
must be clear regarding your query

Ashish

On Thu, Aug 30, 2012 at 10:00 AM, PRAVESH KUMAR wrote:

> Hi Team,
>
> please help me to solve this question it's very urgent
>
>
> waiting your response
>
>
>
> --
>
> Thanks & Regards
>
> Pravesh Kumar
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5)  Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE  : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>


-- 
Thanks & regards.

Ashish Bhalara
9624111822
P*Please do not print this email unless it is absolutely necessary. Spread
environmental üawareness.♣♣♣*

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.




Question-Solve.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet


$$Excel-Macros$$ please help me to solve this question it's very urgent

2012-08-29 Thread PRAVESH KUMAR
Hi Team,

please help me to solve this question it's very urgent


waiting your response



-- 

Thanks & Regards

Pravesh Kumar

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.




Question-.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet