Re: $$Excel-Macros$$ Need macro or Formula

[Mukesh Kumar]

Thanks DP Sir, the code is now working perfectly.

Regards,
Mukesh Kumar


On Wed, Jul 17, 2013 at 6:40 AM, De Premor  wrote:

>  ignore my last email, i've made some change in variable declaration
> PFA
>
>
> On 17/07/2013 7:32, De Premor wrote:
>
> Hi, Mukesh Try to change this code:
>
> *For Each Rng In Data**
> **If RangeCriteria.Cells(Rng.Row, 1) = Criteria Then Buf.Add
> Rng.Value, Rng.Value**
> **Next**
> *
> to
>
> *For Each Rng In Data**
> **i = i + 1**
> **If RangeCriteria.Cells(i, 1) = Criteria Then Buf.Add Rng.Value,
> Rng.Value**
> **Next**
> *
> Rgds,
> [dp]
>
> On 16/07/2013 18:03, Mukesh Kumar wrote:
>
>   Dear Sir, thanks for your help. This file gives 99% correct result.
> Only problem in this formula is that if we gives the range in this formula
> from the very first cell then it gives correct result eg.
> concatif($B$1:$B$26,$A$1:$A$26,A1,TRUE)
>  If we gives range from 2nd cell (in case of header row) then it gives
> wrong result eg. concatif($B$1:$B$26,$A$1:$A$26,A1,TRUE). You can see this
> in attached file. Pls solve this too, so that whatever range we give, the
> result should come true.
>
>
>  Regards,
>  Mukesh Kumar
>
>
>
>
> On Tue, Jul 16, 2013 at 2:52 PM, De Premor  wrote:
>
>>  Ups sorry, my mistake
>> i've attached new file for revision
>>
>> Rgds,
>> [dp]
>>
>>
>> On 16/07/2013 15:27, Mukesh Kumar wrote:
>>
>> Thanks a lot Sir, but duplicate entries are also coming twice eg Alwar is
>> coming twice in  result. Can it also come single time.
>>
>> Regards,
>>  Mukesh Kumar
>>
>>
>> On Tue, Jul 16, 2013 at 1:48 PM, De Premor  wrote:
>>
>>> Solution Attached
>>>
>>>
>>> On 16/07/2013 14:10, Mukesh Kumar wrote:
>>>
 Hi Experts,

 I need macro /formula for query given in attached file. The result
 should come based on values given in column A.


 Regards,
 Mukesh Kumar
 --
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
 It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 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) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send
 an email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/groups/opt_out.



>>> --
>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES
>>>
>>> 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) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE  : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send
>>> an email to excel-macros+unsubscr...@googlegroups.com.
>>> To post to this group, send email to excel-macros@googlegroups.com.
>>> Visit this group at http://groups.google.com/group/excel-macros.
>>> For more options, visit https://groups.google.com/groups/opt_out.
>>>
>>>
>>>
>>  --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not

Re: $$Excel-Macros$$ Need macro or Formula

[De Premor]

Hi, Mukesh Try to change this code:

*For Each Rng In Data**
**If RangeCriteria.Cells(Rng.Row, 1) = Criteria Then Buf.Add 
Rng.Value, Rng.Value**

**Next**
*
to

*For Each Rng In Data**
**i = i + 1**
**If RangeCriteria.Cells(i, 1) = Criteria Then Buf.Add 
Rng.Value, Rng.Value**

**Next**
*
Rgds,
[dp]

On 16/07/2013 18:03, Mukesh Kumar wrote:
Dear Sir, thanks for your help. This file gives 99% correct result. 
Only problem in this formula is that if we gives the range in this 
formula from the very first cell then it gives correct result eg. 
concatif($B$1:$B$26,$A$1:$A$26,A1,TRUE)
If we gives range from 2nd cell (in case of header row) then it gives 
wrong result eg. concatif($B$1:$B$26,$A$1:$A$26,A1,TRUE). You can see 
this in attached file. Pls solve this too, so that whatever range we 
give, the result should come true.



Regards,
Mukesh Kumar




On Tue, Jul 16, 2013 at 2:52 PM, De Premor > wrote:


Ups sorry, my mistake
i've attached new file for revision

Rgds,
[dp]


On 16/07/2013 15:27, Mukesh Kumar wrote:

Thanks a lot Sir, but duplicate entries are also coming twice eg
Alwar is coming twice in  result. Can it also come single time.

Regards,
Mukesh Kumar


On Tue, Jul 16, 2013 at 1:48 PM, De Premor mailto:d...@premor.net>> wrote:

Solution Attached


On 16/07/2013 14:10, Mukesh Kumar wrote:

Hi Experts,

I need macro /formula for query given in attached file.
The result should come based on values given in column A.


Regards,
Mukesh Kumar
-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do

you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official
Facebook page of this forum @
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not
allowed.

NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails
from it, send an email to
excel-macros+unsubscr...@googlegroups.com
.
To post to this group, send email to
excel-macros@googlegroups.com
.
Visit this group at
http://groups.google.com/group/excel-macros.
For more options, visit
https://groups.google.com/groups/opt_out.



-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you

wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook
page of this forum @ https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post 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 unsubscribe from this group and stop receiving emails from
it, send an email to
excel-macros+unsubscr...@googlegroups.com
.
To post to this group, send email to
excel-macros@googlegroups.com
.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.



-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do

Re: $$Excel-Macros$$ VLOOKUP (CHOOSE) QUERY - URGENT HELP REQ.

[Kanwaljit Singh Dhunna]

Thanks Ashwin,

That was an interesting one.
I never came across any such alternative.
Thanks Again !

On Wed, Jul 17, 2013 at 12:21 AM, ashwani agnihotri <
ashwani.agniho...@gmail.com> wrote:

> hey plz go through this link for better understanding of using choose with
> vlookup..
>
> http://www.myonlinetraininghub.com/excel-vlookup-to-the-left-using-choose
>
>
> On Tue, Jul 16, 2013 at 5:20 PM, Ashish Kumar 
> wrote:
>
>>
>>
>> Dear Seniors,
>>
>> kindly find attached vlookup query, I want get output thru vlookup choose
>> function. please help me on this query and please explain me why we use
>> {1,2,3,4,} in formula.
>> Thanks in advance.
>>
>>
>>
>> Thanks
>> Ashish
>>
>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 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) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/groups/opt_out.
>>
>>
>>
>
>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 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) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>



-- 
Sincere Regards
CA Kanwaljit Singh Dhunna
+91-987 6739 911
+91-950 1031 007

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

Re: $$Excel-Macros$$ VLOOKUP (CHOOSE) QUERY - URGENT HELP REQ.

[ashwani agnihotri]

hey plz go through this link for better understanding of using choose with
vlookup..

http://www.myonlinetraininghub.com/excel-vlookup-to-the-left-using-choose


On Tue, Jul 16, 2013 at 5:20 PM, Ashish Kumar wrote:

>
>
> Dear Seniors,
>
> kindly find attached vlookup query, I want get output thru vlookup choose
> function. please help me on this query and please explain me why we use
> {1,2,3,4,} in formula.
> Thanks in advance.
>
>
>
> Thanks
> Ashish
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 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) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

Re: $$Excel-Macros$$ Need Help with Lookup function involving NFL scores

[bobscoreslv]

excel 2003 and the last 4 would be the bottom

On Tuesday, July 16, 2013 9:36:13 AM UTC-4, ashish wrote:

> which version of excel are you using and last 4 do you mean from top or 
> bottom of column ?
>
>
> On Tue, Jul 16, 2013 at 7:33 AM, > wrote:
>
>>
>>
>> Hello,
>>  
>> I am using Excel 2003. I have attached a simple workbook which has two 
>> worksheets. One worksheet is titled "Scores" and the other is "Team Info". 
>> On the team info worksheet, I have all the nfl teams listed in column A. I 
>> need to solve for the following based on the scores in the "scores" 
>> worksheet: Last 4 home scoring average, last 8 home scoring average, and 
>> season to date scoring average. I know basic functions in excel but I am 
>> sure there has to be simpler formulas. Any help would be greatly 
>> appreciated. 
>>
>> -- 
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
>> https://www.facebook.com/discussexcel
>>  
>> FORUM RULES
>>  
>> 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) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>  
>> NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an 
>> email to excel-macros...@googlegroups.com .
>> To post to this group, send email to excel-...@googlegroups.com
>> .
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/groups/opt_out.
>>  
>>  
>>
>
>
>
> -- 
> *Regards*
> * *
> *Ashish Koul*
>
>
> *Visit*
> *My Excel Blog *
> Like Us on 
> Facebook
> Join Us on Facebook 
>
>
> P Before printing, think about the environment.
>
>  
>  

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

$$Excel-Macros$$ Re: Need Help with Lookup function involving NFL scores

[bobscoreslv]

On Monday, July 15, 2013 10:03:35 PM UTC-4, bobsc...@yahoo.com wrote:
>
>
>
> Hello,
>  
> I am using Excel 2003. I have attached a simple workbook which has two 
> worksheets. One worksheet is titled "Scores" and the other is "Team Info". 
> On the team info worksheet, I have all the nfl teams listed in column A. I 
> need to solve for the following based on the scores in the "scores" 
> worksheet: Last 4 home scoring average, last 8 home scoring average, and 
> season to date scoring average. I know basic functions in excel but I am 
> sure there has to be simpler formulas. Any help would be greatly 
> appreciated. 
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

$$Excel-Macros$$ Selecting range using Area

[Chandra Shekar]

Hi,

How to know how many ranges are there in the attached workbook and how to
select last range using Area function.

Thanks in advance.

Regards,

Chandra

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.




Selecting cells.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ VLOOKUP (CHOOSE) QUERY - URGENT HELP REQ.

[Kanwaljit Singh Dhunna]

So In nutshell Choose Function was used here as per choice of the person
and not out of any compulsion or requirement !

On Tue, Jul 16, 2013 at 8:12 PM,  wrote:

> **
> Thanks Noorain Bhai and Kuldeep Bhai for the explanation.
>
>
> Sandeep Chhajer.
> Sent on my BlackBerry® from Vodafone
> --
> *From: * NOORAIN ANSARI 
> *Sender: * excel-macros@googlegroups.com
> *Date: *Tue, 16 Jul 2013 20:08:00 +0530
> *To: *excel-macros@googlegroups.com
> *ReplyTo: * excel-macros@googlegroups.com
> *Subject: *Re: $$Excel-Macros$$ VLOOKUP (CHOOSE) QUERY - URGENT HELP REQ.
>
> Dear Sandeep,
>
> Your question is correct, why we are using choose function, because it is
> possible through only vlookup Function, no need to using choose Function.
>
> But As per Question of Mr. Ashish Kumar, He want to use Choose function
> with Vlookup.
> We often use Choose function with vlookup to extract left side value,
> although it is also
> Possible through.. Index, Offset, Lookup and Indirect function.
>
>
> Hope you will understand, we used Choose function as per user requirement.
>
>
>
>
>
>
>
>
> On Tue, Jul 16, 2013 at 7:51 PM,  wrote:
>
>> **
>> Dear All,
>> My question is also the same why we are using choose funtion here! If any
>> one please explain the same then will be very thankful.
>>
>>
>> Sandeep Chhajer.
>> Sent on my BlackBerry® from Vodafone
>> --
>> *From: * Kanwaljit Singh Dhunna 
>> *Sender: * excel-macros@googlegroups.com
>> *Date: *Tue, 16 Jul 2013 19:46:02 +0530
>> *To: *
>> *ReplyTo: * excel-macros@googlegroups.com
>> *Subject: *Re: $$Excel-Macros$$ VLOOKUP (CHOOSE) QUERY - URGENT HELP REQ.
>>
>> Dear Ashish,
>>
>> Still Curious to know why do you use Choose here ?
>>
>> On Tue, Jul 16, 2013 at 7:40 PM, Ashish Kumar 
>> wrote:
>>
>>> Dear Seniors,
>>>
>>> Formula is working fine.
>>> Thanks for your help and support specially Noorain Sir, Kuldeep Sir and
>>> kanwaljit sir.
>>>
>>> Thanks
>>> Ashish
>>>
>>>
>>> On Tuesday, July 16, 2013 7:26:49 PM UTC+5:30, kanwal_no1 wrote:
>>>
 As told by Kuldeep Ji with a small change, which might be causing
 trouble for you.
 First : Select 4 Rows like : J, K, L, M & Paste this formula *=VLOOKUP(
 **$**I2,CHOOSE({1,2,3,4,5,6},$A$2:$A$7,$B$2:$
 B$7,$C$2:$C$7,$D$2:$D$7,$E$2:$E$7),{2,4,5,3,6},0) & Press Ctrl + Shift
 + Enter then select J2:M20 & **Drag formula like Ctrl + D. It's
 working fine.*

 BTW what is the issue in choosing simple Vlookup here ?

 On Tue, Jul 16, 2013 at 7:10 PM, Ashish Kumar wrote:

> Dear Seniors,
>
> Thanks for your help, but again i'hve geting same error. querry
> attached please find. and help me to crack the query.
>
>  I'hve getting wrigh output when i put the formula in Name Column, but
> when i paste the same formula in rest of fields like address, process,
> salary...!! the formula is not working and I'hve use this formula with 
> CSE.
> Please suggest me, how i am resolve this.
>
>
>
> Thanks
> Ashish
>
>
> On Tuesday, July 16, 2013 6:49:40 PM UTC+5:30, Kuldeep Singh wrote:
>
>> Hi Ashish,
>>
>> Formula is working fine. Please find the attachment.
>>
>> *Use formula with Ctrl + Shift + Enter (Select All Rows & Press Ctrl
>> + Shift + Enter).*
>>
>> Regards,
>> Kuldeep Singh
>> Assistant Manager Quality
>> Game Zone India Limited
>> Phone.: +91-9716615535
>> || naukri...@gmail.com ||
>>
>> *Please* *Consider the environment. Please don't print this e-mail
>> unless you really need to.*
>>
>> On Tue, Jul 16, 2013 at 6:42 PM, Ashish Kumar 
>> wrote:
>>
>>> Dear Seniors,
>>>
>>> Data Getting Error..please find the attached sheet for refrence.
>>>
>>>
>>> Thanks
>>> Ashish
>>>
>>>
>>> On Tuesday, July 16, 2013 5:37:03 PM UTC+5:30, NOORAIN ANSARI wrote:
>>>
 Dear Ashish,

 Please try it..

 =VLOOKUP(I2,CHOOSE(*{1,2,3,4,5,6}*,$A$2:$A$7,$B$2:$B$7,$C$2:$**C***
 *$7,$D$2:$D$7,$E$2:$E$7),*{2,4,5,3,6}*,0) with CSE


 Note : Red Color is use for Index No. of Choose Function and green
 Color is Columns Index no. of data




 On Tue, Jul 16, 2013 at 5:20 PM, Ashish Kumar >>> > wrote:

>
>
> Dear Seniors,
>
> kindly find attached vlookup query, I want get output thru vlookup
> choose function. please help me on this query and please explain me 
> why we
> use {1,2,3,4,} in formula.
> Thanks in advance.
>
>
>
> Thanks
> Ashish
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna
> be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this 
> forum @
>

Re: $$Excel-Macros$$ VLOOKUP (CHOOSE) QUERY - URGENT HELP REQ.

[chhajersandeep]

Thanks Noorain Bhai and Kuldeep Bhai for the explanation.

Sandeep Chhajer. 
Sent on my BlackBerry® from Vodafone

-Original Message-
From: NOORAIN ANSARI 
Sender: excel-macros@googlegroups.com
Date: Tue, 16 Jul 2013 20:08:00 
To: excel-macros@googlegroups.com
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ VLOOKUP (CHOOSE) QUERY - URGENT HELP REQ.

Dear Sandeep,

Your question is correct, why we are using choose function, because it is
possible through only vlookup Function, no need to using choose Function.

But As per Question of Mr. Ashish Kumar, He want to use Choose function
with Vlookup.
We often use Choose function with vlookup to extract left side value,
although it is also
Possible through.. Index, Offset, Lookup and Indirect function.


Hope you will understand, we used Choose function as per user requirement.








On Tue, Jul 16, 2013 at 7:51 PM,  wrote:

> **
> Dear All,
> My question is also the same why we are using choose funtion here! If any
> one please explain the same then will be very thankful.
>
>
> Sandeep Chhajer.
> Sent on my BlackBerry® from Vodafone
> --
> *From: * Kanwaljit Singh Dhunna 
> *Sender: * excel-macros@googlegroups.com
> *Date: *Tue, 16 Jul 2013 19:46:02 +0530
> *To: *
> *ReplyTo: * excel-macros@googlegroups.com
> *Subject: *Re: $$Excel-Macros$$ VLOOKUP (CHOOSE) QUERY - URGENT HELP REQ.
>
> Dear Ashish,
>
> Still Curious to know why do you use Choose here ?
>
> On Tue, Jul 16, 2013 at 7:40 PM, Ashish Kumar 
> wrote:
>
>> Dear Seniors,
>>
>> Formula is working fine.
>> Thanks for your help and support specially Noorain Sir, Kuldeep Sir and
>> kanwaljit sir.
>>
>> Thanks
>> Ashish
>>
>>
>> On Tuesday, July 16, 2013 7:26:49 PM UTC+5:30, kanwal_no1 wrote:
>>
>>> As told by Kuldeep Ji with a small change, which might be causing
>>> trouble for you.
>>> First : Select 4 Rows like : J, K, L, M & Paste this formula *=VLOOKUP(*
>>> *$**I2,CHOOSE({1,2,3,4,5,6},$A$2:$A$7,$B$2:$
>>> B$7,$C$2:$C$7,$D$2:$D$7,$E$2:$E$7),{2,4,5,3,6},0) & Press Ctrl + Shift
>>> + Enter then select J2:M20 & **Drag formula like Ctrl + D. It's working
>>> fine.*
>>>
>>> BTW what is the issue in choosing simple Vlookup here ?
>>>
>>> On Tue, Jul 16, 2013 at 7:10 PM, Ashish Kumar wrote:
>>>
 Dear Seniors,

 Thanks for your help, but again i'hve geting same error. querry
 attached please find. and help me to crack the query.

  I'hve getting wrigh output when i put the formula in Name Column, but
 when i paste the same formula in rest of fields like address, process,
 salary...!! the formula is not working and I'hve use this formula with CSE.
 Please suggest me, how i am resolve this.



 Thanks
 Ashish


 On Tuesday, July 16, 2013 6:49:40 PM UTC+5:30, Kuldeep Singh wrote:

> Hi Ashish,
>
> Formula is working fine. Please find the attachment.
>
> *Use formula with Ctrl + Shift + Enter (Select All Rows & Press Ctrl
> + Shift + Enter).*
>
> Regards,
> Kuldeep Singh
> Assistant Manager Quality
> Game Zone India Limited
> Phone.: +91-9716615535
> || naukri...@gmail.com ||
>
> *Please* *Consider the environment. Please don't print this e-mail
> unless you really need to.*
>
> On Tue, Jul 16, 2013 at 6:42 PM, Ashish Kumar wrote:
>
>> Dear Seniors,
>>
>> Data Getting Error..please find the attached sheet for refrence.
>>
>>
>> Thanks
>> Ashish
>>
>>
>> On Tuesday, July 16, 2013 5:37:03 PM UTC+5:30, NOORAIN ANSARI wrote:
>>
>>> Dear Ashish,
>>>
>>> Please try it..
>>>
>>> =VLOOKUP(I2,CHOOSE(*{1,2,3,4,5,6}*,$A$2:$A$7,$B$2:$B$7,$C$2:$**C
>>> $7,$D$2:$D$7,$E$2:$E$7),*{2,4,5,3,6}*,0) with CSE
>>>
>>>
>>> Note : Red Color is use for Index No. of Choose Function and green
>>> Color is Columns Index no. of data
>>>
>>>
>>>
>>>
>>> On Tue, Jul 16, 2013 at 5:20 PM, Ashish Kumar 
>>> wrote:
>>>


 Dear Seniors,

 kindly find attached vlookup query, I want get output thru vlookup
 choose function. please help me on this query and please explain me 
 why we
 use {1,2,3,4,} in formula.
 Thanks in advance.



 Thanks
 Ashish

 --
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna
 be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this 
 forum @
 https://www.facebook.com/**discussexcel

 FORUM RULES

 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 t

Re: $$Excel-Macros$$ VLOOKUP (CHOOSE) QUERY - URGENT HELP REQ.

[NOORAIN ANSARI]

Dear Sandeep,

Your question is correct, why we are using choose function, because it is
possible through only vlookup Function, no need to using choose Function.

But As per Question of Mr. Ashish Kumar, He want to use Choose function
with Vlookup.
We often use Choose function with vlookup to extract left side value,
although it is also
Possible through.. Index, Offset, Lookup and Indirect function.


Hope you will understand, we used Choose function as per user requirement.








On Tue, Jul 16, 2013 at 7:51 PM,  wrote:

> **
> Dear All,
> My question is also the same why we are using choose funtion here! If any
> one please explain the same then will be very thankful.
>
>
> Sandeep Chhajer.
> Sent on my BlackBerry® from Vodafone
> --
> *From: * Kanwaljit Singh Dhunna 
> *Sender: * excel-macros@googlegroups.com
> *Date: *Tue, 16 Jul 2013 19:46:02 +0530
> *To: *
> *ReplyTo: * excel-macros@googlegroups.com
> *Subject: *Re: $$Excel-Macros$$ VLOOKUP (CHOOSE) QUERY - URGENT HELP REQ.
>
> Dear Ashish,
>
> Still Curious to know why do you use Choose here ?
>
> On Tue, Jul 16, 2013 at 7:40 PM, Ashish Kumar 
> wrote:
>
>> Dear Seniors,
>>
>> Formula is working fine.
>> Thanks for your help and support specially Noorain Sir, Kuldeep Sir and
>> kanwaljit sir.
>>
>> Thanks
>> Ashish
>>
>>
>> On Tuesday, July 16, 2013 7:26:49 PM UTC+5:30, kanwal_no1 wrote:
>>
>>> As told by Kuldeep Ji with a small change, which might be causing
>>> trouble for you.
>>> First : Select 4 Rows like : J, K, L, M & Paste this formula *=VLOOKUP(*
>>> *$**I2,CHOOSE({1,2,3,4,5,6},$A$2:$A$7,$B$2:$
>>> B$7,$C$2:$C$7,$D$2:$D$7,$E$2:$E$7),{2,4,5,3,6},0) & Press Ctrl + Shift
>>> + Enter then select J2:M20 & **Drag formula like Ctrl + D. It's working
>>> fine.*
>>>
>>> BTW what is the issue in choosing simple Vlookup here ?
>>>
>>> On Tue, Jul 16, 2013 at 7:10 PM, Ashish Kumar wrote:
>>>
 Dear Seniors,

 Thanks for your help, but again i'hve geting same error. querry
 attached please find. and help me to crack the query.

  I'hve getting wrigh output when i put the formula in Name Column, but
 when i paste the same formula in rest of fields like address, process,
 salary...!! the formula is not working and I'hve use this formula with CSE.
 Please suggest me, how i am resolve this.



 Thanks
 Ashish


 On Tuesday, July 16, 2013 6:49:40 PM UTC+5:30, Kuldeep Singh wrote:

> Hi Ashish,
>
> Formula is working fine. Please find the attachment.
>
> *Use formula with Ctrl + Shift + Enter (Select All Rows & Press Ctrl
> + Shift + Enter).*
>
> Regards,
> Kuldeep Singh
> Assistant Manager Quality
> Game Zone India Limited
> Phone.: +91-9716615535
> || naukri...@gmail.com ||
>
> *Please* *Consider the environment. Please don't print this e-mail
> unless you really need to.*
>
> On Tue, Jul 16, 2013 at 6:42 PM, Ashish Kumar wrote:
>
>> Dear Seniors,
>>
>> Data Getting Error..please find the attached sheet for refrence.
>>
>>
>> Thanks
>> Ashish
>>
>>
>> On Tuesday, July 16, 2013 5:37:03 PM UTC+5:30, NOORAIN ANSARI wrote:
>>
>>> Dear Ashish,
>>>
>>> Please try it..
>>>
>>> =VLOOKUP(I2,CHOOSE(*{1,2,3,4,5,6}*,$A$2:$A$7,$B$2:$B$7,$C$2:$**C
>>> $7,$D$2:$D$7,$E$2:$E$7),*{2,4,5,3,6}*,0) with CSE
>>>
>>>
>>> Note : Red Color is use for Index No. of Choose Function and green
>>> Color is Columns Index no. of data
>>>
>>>
>>>
>>>
>>> On Tue, Jul 16, 2013 at 5:20 PM, Ashish Kumar 
>>> wrote:
>>>


 Dear Seniors,

 kindly find attached vlookup query, I want get output thru vlookup
 choose function. please help me on this query and please explain me 
 why we
 use {1,2,3,4,} in formula.
 Thanks in advance.



 Thanks
 Ashish

 --
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna
 be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this 
 forum @
 https://www.facebook.com/**discussexcel

 FORUM RULES

 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) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum

Re: $$Excel-Macros$$ VLOOKUP (CHOOSE) QUERY - URGENT HELP REQ.

[chhajersandeep]

Dear All,
My question is also the same why we are using choose funtion here! If any one 
please explain the same then will be very thankful.

Sandeep Chhajer.
 
Sent on my BlackBerry® from Vodafone

-Original Message-
From: Kanwaljit Singh Dhunna 
Sender: excel-macros@googlegroups.com
Date: Tue, 16 Jul 2013 19:46:02 
To: 
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ VLOOKUP (CHOOSE) QUERY - URGENT HELP REQ.

Dear Ashish,

Still Curious to know why do you use Choose here ?

On Tue, Jul 16, 2013 at 7:40 PM, Ashish Kumar wrote:

> Dear Seniors,
>
> Formula is working fine.
> Thanks for your help and support specially Noorain Sir, Kuldeep Sir and
> kanwaljit sir.
>
> Thanks
> Ashish
>
>
> On Tuesday, July 16, 2013 7:26:49 PM UTC+5:30, kanwal_no1 wrote:
>
>> As told by Kuldeep Ji with a small change, which might be causing trouble
>> for you.
>> First : Select 4 Rows like : J, K, L, M & Paste this formula *=VLOOKUP(**
>> $**I2,CHOOSE({1,2,3,4,5,6},$A$2:$A$7,$B$2:$B$7,$C$2:$C$7,$D$2:$D$7,$E$2:$E$7),{2,4,5,3,6},0)
>> & Press Ctrl + Shift + Enter then select J2:M20 & **Drag formula like
>> Ctrl + D. It's working fine.*
>>
>> BTW what is the issue in choosing simple Vlookup here ?
>>
>> On Tue, Jul 16, 2013 at 7:10 PM, Ashish Kumar wrote:
>>
>>> Dear Seniors,
>>>
>>> Thanks for your help, but again i'hve geting same error. querry attached
>>> please find. and help me to crack the query.
>>>
>>>  I'hve getting wrigh output when i put the formula in Name Column, but
>>> when i paste the same formula in rest of fields like address, process,
>>> salary...!! the formula is not working and I'hve use this formula with CSE.
>>> Please suggest me, how i am resolve this.
>>>
>>>
>>>
>>> Thanks
>>> Ashish
>>>
>>>
>>> On Tuesday, July 16, 2013 6:49:40 PM UTC+5:30, Kuldeep Singh wrote:
>>>
 Hi Ashish,

 Formula is working fine. Please find the attachment.

 *Use formula with Ctrl + Shift + Enter (Select All Rows & Press Ctrl +
 Shift + Enter).*

 Regards,
 Kuldeep Singh
 Assistant Manager Quality
 Game Zone India Limited
 Phone.: +91-9716615535
 || naukri...@gmail.com ||

 *Please* *Consider the environment. Please don't print this e-mail
 unless you really need to.*

 On Tue, Jul 16, 2013 at 6:42 PM, Ashish Kumar wrote:

> Dear Seniors,
>
> Data Getting Error..please find the attached sheet for refrence.
>
>
> Thanks
> Ashish
>
>
> On Tuesday, July 16, 2013 5:37:03 PM UTC+5:30, NOORAIN ANSARI wrote:
>
>> Dear Ashish,
>>
>> Please try it..
>>
>> =VLOOKUP(I2,CHOOSE(*{1,2,3,4,5,6}*,$A$2:$A$7,$B$2:$B$7,$C$2:$**C
>> $7,$D$2:$D$7,$E$2:$E$7),*{2,4,5,3,6}*,0) with CSE
>>
>>
>> Note : Red Color is use for Index No. of Choose Function and green
>> Color is Columns Index no. of data
>>
>>
>>
>>
>> On Tue, Jul 16, 2013 at 5:20 PM, Ashish Kumar 
>> wrote:
>>
>>>
>>>
>>> Dear Seniors,
>>>
>>> kindly find attached vlookup query, I want get output thru vlookup
>>> choose function. please help me on this query and please explain me why 
>>> we
>>> use {1,2,3,4,} in formula.
>>> Thanks in advance.
>>>
>>>
>>>
>>> Thanks
>>> Ashish
>>>
>>> --
>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>> https://www.facebook.com/**discussexcel
>>>
>>> FORUM RULES
>>>
>>> 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) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it,
>>> send an email to excel-macros...@**googlegroups.**c**om.
>>> To post to this group, send email to excel-...@googlegroups.com.
>>>
>>> Visit this group at http://groups.google.com/**group
>>> /excel-macros .
>>> For more options, visit https://groups.google.com/**grou
>>> ps/opt_out .
>>>
>>>
>>>
>>
>>
>>
>>>

Re: $$Excel-Macros$$ VLOOKUP (CHOOSE) QUERY - URGENT HELP REQ.

[Kuldeep Singh]

Specially thanks for Noorain Sir (Guru Dev).

Regards,
Kuldeep Singh
Assistant Manager Quality
Game Zone India Limited
Phone.: +91-9716615535
|| naukrikuld...@gmail.com ||
*Please* *Consider the environment. Please don't print this e-mail unless
you really need to.*

On Tue, Jul 16, 2013 at 7:40 PM, Ashish Kumar wrote:

> Dear Seniors,
>
> Formula is working fine.
> Thanks for your help and support specially Noorain Sir, Kuldeep Sir and
> kanwaljit sir.
>
> Thanks
> Ashish
>
>
> On Tuesday, July 16, 2013 7:26:49 PM UTC+5:30, kanwal_no1 wrote:
>
>> As told by Kuldeep Ji with a small change, which might be causing trouble
>> for you.
>> First : Select 4 Rows like : J, K, L, M & Paste this formula *=VLOOKUP(**
>> $**I2,CHOOSE({1,2,3,4,5,6},$A$2:$A$7,$B$2:$B$7,$C$2:$C$7,$D$2:$D$7,$E$2:$E$7),{2,4,5,3,6},0)
>> & Press Ctrl + Shift + Enter then select J2:M20 & **Drag formula like
>> Ctrl + D. It's working fine.*
>>
>> BTW what is the issue in choosing simple Vlookup here ?
>>
>> On Tue, Jul 16, 2013 at 7:10 PM, Ashish Kumar wrote:
>>
>>> Dear Seniors,
>>>
>>> Thanks for your help, but again i'hve geting same error. querry attached
>>> please find. and help me to crack the query.
>>>
>>>  I'hve getting wrigh output when i put the formula in Name Column, but
>>> when i paste the same formula in rest of fields like address, process,
>>> salary...!! the formula is not working and I'hve use this formula with CSE.
>>> Please suggest me, how i am resolve this.
>>>
>>>
>>>
>>> Thanks
>>> Ashish
>>>
>>>
>>> On Tuesday, July 16, 2013 6:49:40 PM UTC+5:30, Kuldeep Singh wrote:
>>>
 Hi Ashish,

 Formula is working fine. Please find the attachment.

 *Use formula with Ctrl + Shift + Enter (Select All Rows & Press Ctrl +
 Shift + Enter).*

 Regards,
 Kuldeep Singh
 Assistant Manager Quality
 Game Zone India Limited
 Phone.: +91-9716615535
 || naukri...@gmail.com ||

 *Please* *Consider the environment. Please don't print this e-mail
 unless you really need to.*

 On Tue, Jul 16, 2013 at 6:42 PM, Ashish Kumar wrote:

> Dear Seniors,
>
> Data Getting Error..please find the attached sheet for refrence.
>
>
> Thanks
> Ashish
>
>
> On Tuesday, July 16, 2013 5:37:03 PM UTC+5:30, NOORAIN ANSARI wrote:
>
>> Dear Ashish,
>>
>> Please try it..
>>
>> =VLOOKUP(I2,CHOOSE(*{1,2,3,4,5,6}*,$A$2:$A$7,$B$2:$B$7,$C$2:$**C
>> $7,$D$2:$D$7,$E$2:$E$7),*{2,4,5,3,6}*,0) with CSE
>>
>>
>> Note : Red Color is use for Index No. of Choose Function and green
>> Color is Columns Index no. of data
>>
>>
>>
>>
>> On Tue, Jul 16, 2013 at 5:20 PM, Ashish Kumar 
>> wrote:
>>
>>>
>>>
>>> Dear Seniors,
>>>
>>> kindly find attached vlookup query, I want get output thru vlookup
>>> choose function. please help me on this query and please explain me why 
>>> we
>>> use {1,2,3,4,} in formula.
>>> Thanks in advance.
>>>
>>>
>>>
>>> Thanks
>>> Ashish
>>>
>>> --
>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>> https://www.facebook.com/**discussexcel
>>>
>>> FORUM RULES
>>>
>>> 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) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it,
>>> send an email to excel-macros...@**googlegroups.**c**om.
>>> To post to this group, send email to excel-...@googlegroups.com.
>>>
>>> Visit this group at http://groups.google.com/**group
>>> /excel-macros .
>>> For more options, visit https://groups.google.com/**grou
>>> ps/opt_out .
>>>
>>>
>>>
>>
>>
>>
>> --
>> With Regards,
>> Noorain Ansari
>> http:// 
>> noorainansari.com
>> http:// 
>> excelvbaclinic.com

Re: $$Excel-Macros$$ VLOOKUP (CHOOSE) QUERY - URGENT HELP REQ.

[Kanwaljit Singh Dhunna]

Dear Ashish,

Still Curious to know why do you use Choose here ?

On Tue, Jul 16, 2013 at 7:40 PM, Ashish Kumar wrote:

> Dear Seniors,
>
> Formula is working fine.
> Thanks for your help and support specially Noorain Sir, Kuldeep Sir and
> kanwaljit sir.
>
> Thanks
> Ashish
>
>
> On Tuesday, July 16, 2013 7:26:49 PM UTC+5:30, kanwal_no1 wrote:
>
>> As told by Kuldeep Ji with a small change, which might be causing trouble
>> for you.
>> First : Select 4 Rows like : J, K, L, M & Paste this formula *=VLOOKUP(**
>> $**I2,CHOOSE({1,2,3,4,5,6},$A$2:$A$7,$B$2:$B$7,$C$2:$C$7,$D$2:$D$7,$E$2:$E$7),{2,4,5,3,6},0)
>> & Press Ctrl + Shift + Enter then select J2:M20 & **Drag formula like
>> Ctrl + D. It's working fine.*
>>
>> BTW what is the issue in choosing simple Vlookup here ?
>>
>> On Tue, Jul 16, 2013 at 7:10 PM, Ashish Kumar wrote:
>>
>>> Dear Seniors,
>>>
>>> Thanks for your help, but again i'hve geting same error. querry attached
>>> please find. and help me to crack the query.
>>>
>>>  I'hve getting wrigh output when i put the formula in Name Column, but
>>> when i paste the same formula in rest of fields like address, process,
>>> salary...!! the formula is not working and I'hve use this formula with CSE.
>>> Please suggest me, how i am resolve this.
>>>
>>>
>>>
>>> Thanks
>>> Ashish
>>>
>>>
>>> On Tuesday, July 16, 2013 6:49:40 PM UTC+5:30, Kuldeep Singh wrote:
>>>
 Hi Ashish,

 Formula is working fine. Please find the attachment.

 *Use formula with Ctrl + Shift + Enter (Select All Rows & Press Ctrl +
 Shift + Enter).*

 Regards,
 Kuldeep Singh
 Assistant Manager Quality
 Game Zone India Limited
 Phone.: +91-9716615535
 || naukri...@gmail.com ||

 *Please* *Consider the environment. Please don't print this e-mail
 unless you really need to.*

 On Tue, Jul 16, 2013 at 6:42 PM, Ashish Kumar wrote:

> Dear Seniors,
>
> Data Getting Error..please find the attached sheet for refrence.
>
>
> Thanks
> Ashish
>
>
> On Tuesday, July 16, 2013 5:37:03 PM UTC+5:30, NOORAIN ANSARI wrote:
>
>> Dear Ashish,
>>
>> Please try it..
>>
>> =VLOOKUP(I2,CHOOSE(*{1,2,3,4,5,6}*,$A$2:$A$7,$B$2:$B$7,$C$2:$**C
>> $7,$D$2:$D$7,$E$2:$E$7),*{2,4,5,3,6}*,0) with CSE
>>
>>
>> Note : Red Color is use for Index No. of Choose Function and green
>> Color is Columns Index no. of data
>>
>>
>>
>>
>> On Tue, Jul 16, 2013 at 5:20 PM, Ashish Kumar 
>> wrote:
>>
>>>
>>>
>>> Dear Seniors,
>>>
>>> kindly find attached vlookup query, I want get output thru vlookup
>>> choose function. please help me on this query and please explain me why 
>>> we
>>> use {1,2,3,4,} in formula.
>>> Thanks in advance.
>>>
>>>
>>>
>>> Thanks
>>> Ashish
>>>
>>> --
>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>> https://www.facebook.com/**discussexcel
>>>
>>> FORUM RULES
>>>
>>> 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) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it,
>>> send an email to excel-macros...@**googlegroups.**c**om.
>>> To post to this group, send email to excel-...@googlegroups.com.
>>>
>>> Visit this group at http://groups.google.com/**group
>>> /excel-macros .
>>> For more options, visit https://groups.google.com/**grou
>>> ps/opt_out .
>>>
>>>
>>>
>>
>>
>>
>> --
>> With Regards,
>> Noorain Ansari
>> http:// 
>> noorainansari.com
>> http:// 
>> excelvbaclinic.com
>>
>>   --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
> It’s =TIME(2,DO:IT,N:OW) ! Join offi

Re: $$Excel-Macros$$ VLOOKUP (CHOOSE) QUERY - URGENT HELP REQ.

[Ashish Kumar]

Dear Seniors,

Formula is working fine.
Thanks for your help and support specially Noorain Sir, Kuldeep Sir and 
kanwaljit sir.

Thanks
Ashish

On Tuesday, July 16, 2013 7:26:49 PM UTC+5:30, kanwal_no1 wrote:
>
> As told by Kuldeep Ji with a small change, which might be causing trouble 
> for you.
> First : Select 4 Rows like : J, K, L, M & Paste this formula *=VLOOKUP(**$
> **I2,CHOOSE({1,2,3,4,5,6},$A$2:$A$7,$B$2:$B$7,$C$2:$C$7,$D$2:$D$7,$E$2:$E$7),{2,4,5,3,6},0)
>  
> & Press Ctrl + Shift + Enter then select J2:M20 & **Drag formula like 
> Ctrl + D. It's working fine.*
>
> BTW what is the issue in choosing simple Vlookup here ?
>
> On Tue, Jul 16, 2013 at 7:10 PM, Ashish Kumar 
> 
> > wrote:
>
>> Dear Seniors,
>>
>> Thanks for your help, but again i'hve geting same error. querry attached 
>> please find. and help me to crack the query.
>>
>>  I'hve getting wrigh output when i put the formula in Name Column, but 
>> when i paste the same formula in rest of fields like address, process, 
>> salary...!! the formula is not working and I'hve use this formula with CSE. 
>> Please suggest me, how i am resolve this.
>>
>>
>>
>> Thanks
>> Ashish
>>
>>
>> On Tuesday, July 16, 2013 6:49:40 PM UTC+5:30, Kuldeep Singh wrote:
>>
>>> Hi Ashish,
>>>
>>> Formula is working fine. Please find the attachment.
>>>
>>> *Use formula with Ctrl + Shift + Enter (Select All Rows & Press Ctrl + 
>>> Shift + Enter).*
>>>
>>> Regards,
>>> Kuldeep Singh
>>> Assistant Manager Quality
>>> Game Zone India Limited
>>> Phone.: +91-9716615535
>>> || naukri...@gmail.com ||
>>>
>>> *Please* *Consider the environment. Please don't print this e-mail 
>>> unless you really need to.*
>>>  
>>> On Tue, Jul 16, 2013 at 6:42 PM, Ashish Kumar wrote:
>>>
 Dear Seniors,

 Data Getting Error..please find the attached sheet for refrence.


 Thanks
 Ashish


 On Tuesday, July 16, 2013 5:37:03 PM UTC+5:30, NOORAIN ANSARI wrote:

> Dear Ashish,
>
> Please try it..
>
> =VLOOKUP(I2,CHOOSE(*{1,2,3,4,5,6}*,$A$2:$A$7,$B$2:$B$7,$C$2:$**C**
> $7,$D$2:$D$7,$E$2:$E$7),*{2,4,5,3,6}*,0) with CSE
>
>
> Note : Red Color is use for Index No. of Choose Function and green 
> Color is Columns Index no. of data
>
>
>
>
> On Tue, Jul 16, 2013 at 5:20 PM, Ashish Kumar wrote:
>
>>  
>>
>> Dear Seniors,
>>
>> kindly find attached vlookup query, I want get output thru vlookup 
>> choose function. please help me on this query and please explain me why 
>> we 
>> use {1,2,3,4,} in formula.
>> Thanks in advance.
>>
>>
>>
>> Thanks
>> Ashish
>>
>> -- 
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? 
>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
>> https://www.facebook.com/**discu**ssexcel
>>  
>> FORUM RULES
>>  
>> 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) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>  
>> NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, 
>> send an email to excel-macros...@**googlegroups.**com.
>> To post to this group, send email to excel-...@googlegroups.com.
>>
>> Visit this group at 
>> http://groups.google.com/**group**/excel-macros
>> .
>> For more options, visit 
>> https://groups.google.com/**grou**ps/opt_out
>> .
>>  
>>  
>>
>
>
>
> -- 
> With Regards,
> Noorain Ansari
> http:// 
> noorainansari.com
> http:// 
> excelvbaclinic.com
>  
>
>   -- 
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? 
 It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
 https://www.facebook.com/**discussexcel
  
 FORUM RULES
  
 1) Use concise, accurate thread titles. Poor thread titles, like 

Re: $$Excel-Macros$$ Re: Vlookup Choose Query - HELP

[Kanwaljit Singh Dhunna]

Dear Ashish,

I couldn't make out why you chose to use Choose function here. Am I missing
something ?

On Tue, Jul 16, 2013 at 7:35 PM, Kuldeep Singh wrote:

> Your Welcome Ashish.
>
> Regards,
> Kuldeep Singh
> Assistant Manager Quality
> Game Zone India Limited
> Phone.: +91-9716615535
> || naukrikuld...@gmail.com ||
> *Please* *Consider the environment. Please don't print this e-mail unless
> you really need to.*
>
>
> On Tue, Jul 16, 2013 at 7:33 PM, Ashish Kumar 
> wrote:
>
>> Dear Kuldeep Sir,
>>
>> As per your instruction, I'll put the formula and follow the steps which
>> is suggested by you, and i'll get the wright output. Thanks for your
>> response and support.
>>
>>
>> Thanks a lot sir..!!! :)
>>
>> Thanks,
>> Ashish
>>
>>
>> On 16 July 2013 19:13, Kuldeep Singh  wrote:
>>
>>> Hi Ashish,
>>>
>>> First : Select 4 Rows like : J, K, L, M & Paste this formula 
>>> *=VLOOKUP(I2,CHOOSE({1,2,3,4,5,6},$A$2:$A$7,$B$2:$B$7,$C$2:$C$7,$D$2:$D$7,$E$2:$E$7),{2,4,5,3,6},0)
>>> & Press Ctrl + Shift + Enter then select J3:M20 & **Drag formula like
>>> Ctrl + D. It's working fine.*
>>>
>>> Regards,
>>> Kuldeep Singh
>>> Assistant Manager Quality
>>> Game Zone India Limited
>>> Phone.: +91-9716615535
>>> || naukrikuld...@gmail.com ||
>>> *Please* *Consider the environment. Please don't print this e-mail
>>> unless you really need to.*
>>>
>>> On Tue, Jul 16, 2013 at 7:05 PM, Ashish Kumar >> > wrote:
>>>
 Dear Kuldeep Sir,

 Thanks for your response, but again I'hve getting same error in
 formula, I'hve getting wrigh output when i put the formula in Name Column,
 but when i paste the same formula in rest of fields like address, process,
 salary...!! the formula is not working and I'hve use this formula with CSE.
 Please suggest me, how i am resolve this.


 Thanks
 Ashish

>>>   --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 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) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>



-- 
Sincere Regards
CA Kanwaljit Singh Dhunna
+91-987 6739 911
+91-950 1031 007

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

$$Excel-Macros$$ Re: Vlookup Choose Query - HELP

[Kuldeep Singh]

Your Welcome Ashish.

Regards,
Kuldeep Singh
Assistant Manager Quality
Game Zone India Limited
Phone.: +91-9716615535
|| naukrikuld...@gmail.com ||
*Please* *Consider the environment. Please don't print this e-mail unless
you really need to.*


On Tue, Jul 16, 2013 at 7:33 PM, Ashish Kumar wrote:

> Dear Kuldeep Sir,
>
> As per your instruction, I'll put the formula and follow the steps which
> is suggested by you, and i'll get the wright output. Thanks for your
> response and support.
>
>
> Thanks a lot sir..!!! :)
>
> Thanks,
> Ashish
>
>
> On 16 July 2013 19:13, Kuldeep Singh  wrote:
>
>> Hi Ashish,
>>
>> First : Select 4 Rows like : J, K, L, M & Paste this formula 
>> *=VLOOKUP(I2,CHOOSE({1,2,3,4,5,6},$A$2:$A$7,$B$2:$B$7,$C$2:$C$7,$D$2:$D$7,$E$2:$E$7),{2,4,5,3,6},0)
>> & Press Ctrl + Shift + Enter then select J3:M20 & **Drag formula like
>> Ctrl + D. It's working fine.*
>>
>> Regards,
>> Kuldeep Singh
>> Assistant Manager Quality
>> Game Zone India Limited
>> Phone.: +91-9716615535
>> || naukrikuld...@gmail.com ||
>> *Please* *Consider the environment. Please don't print this e-mail
>> unless you really need to.*
>>
>> On Tue, Jul 16, 2013 at 7:05 PM, Ashish Kumar 
>> wrote:
>>
>>> Dear Kuldeep Sir,
>>>
>>> Thanks for your response, but again I'hve getting same error in formula,
>>> I'hve getting wrigh output when i put the formula in Name Column, but when
>>> i paste the same formula in rest of fields like address, process,
>>> salary...!! the formula is not working and I'hve use this formula with CSE.
>>> Please suggest me, how i am resolve this.
>>>
>>>
>>> Thanks
>>> Ashish
>>>
>>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

Re: $$Excel-Macros$$ VLOOKUP (CHOOSE) QUERY - URGENT HELP REQ.

[Kanwaljit Singh Dhunna]

As told by Kuldeep Ji with a small change, which might be causing trouble
for you.
First : Select 4 Rows like : J, K, L, M & Paste this formula
*=VLOOKUP(**$**I2,CHOOSE({1,2,3,4,5,6},$A$2:$A$7,$B$2:$B$7,$C$2:$C$7,$D$2:$D$7,$E$2:$E$7),{2,4,5,3,6},0)
& Press Ctrl + Shift + Enter then select J2:M20 & **Drag formula like Ctrl
+ D. It's working fine.*

BTW what is the issue in choosing simple Vlookup here ?

On Tue, Jul 16, 2013 at 7:10 PM, Ashish Kumar wrote:

> Dear Seniors,
>
> Thanks for your help, but again i'hve geting same error. querry attached
> please find. and help me to crack the query.
>
>  I'hve getting wrigh output when i put the formula in Name Column, but
> when i paste the same formula in rest of fields like address, process,
> salary...!! the formula is not working and I'hve use this formula with CSE.
> Please suggest me, how i am resolve this.
>
>
>
> Thanks
> Ashish
>
>
> On Tuesday, July 16, 2013 6:49:40 PM UTC+5:30, Kuldeep Singh wrote:
>
>> Hi Ashish,
>>
>> Formula is working fine. Please find the attachment.
>>
>> *Use formula with Ctrl + Shift + Enter (Select All Rows & Press Ctrl +
>> Shift + Enter).*
>>
>> Regards,
>> Kuldeep Singh
>> Assistant Manager Quality
>> Game Zone India Limited
>> Phone.: +91-9716615535
>> || naukri...@gmail.com ||
>>
>> *Please* *Consider the environment. Please don't print this e-mail
>> unless you really need to.*
>>
>> On Tue, Jul 16, 2013 at 6:42 PM, Ashish Kumar wrote:
>>
>>> Dear Seniors,
>>>
>>> Data Getting Error..please find the attached sheet for refrence.
>>>
>>>
>>> Thanks
>>> Ashish
>>>
>>>
>>> On Tuesday, July 16, 2013 5:37:03 PM UTC+5:30, NOORAIN ANSARI wrote:
>>>
 Dear Ashish,

 Please try it..

 =VLOOKUP(I2,CHOOSE(*{1,2,3,4,5,6}*,$A$2:$A$7,$B$2:$B$7,$C$2:$**C**
 $7,$D$2:$D$7,$E$2:$E$7),*{2,4,5,3,6}*,0) with CSE


 Note : Red Color is use for Index No. of Choose Function and green
 Color is Columns Index no. of data




 On Tue, Jul 16, 2013 at 5:20 PM, Ashish Kumar wrote:

>
>
> Dear Seniors,
>
> kindly find attached vlookup query, I want get output thru vlookup
> choose function. please help me on this query and please explain me why we
> use {1,2,3,4,} in formula.
> Thanks in advance.
>
>
>
> Thanks
> Ashish
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/**discu**ssexcel
>
> FORUM RULES
>
> 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) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send
> an email to excel-macros...@**googlegroups.**com.
> To post to this group, send email to excel-...@googlegroups.com.
>
> Visit this group at 
> http://groups.google.com/**group**/excel-macros
> .
> For more options, visit 
> https://groups.google.com/**grou**ps/opt_out
> .
>
>
>



 --
 With Regards,
 Noorain Ansari
 http:// 
 noorainansari.com
 http:// 
 excelvbaclinic.com

   --
>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>> https://www.facebook.com/**discussexcel
>>>
>>> FORUM RULES
>>>
>>> 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) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links

Re: $$Excel-Macros$$ VLOOKUP (CHOOSE) QUERY - URGENT HELP REQ.

[Kuldeep Singh]

Hi Ashish,

First : Select 4 Rows like : J, K, L, M & Paste this formula
*=VLOOKUP(I2,CHOOSE({1,2,3,4,5,6},$A$2:$A$7,$B$2:$B$7,$C$2:$C$7,$D$2:$D$7,$E$2:$E$7),{2,4,5,3,6},0)
& Press Ctrl + Shift + Enter then select J2:M20 & **Drag formula like Ctrl
+ D. It's working fine.*

Regards,
Kuldeep Singh
Assistant Manager Quality
Game Zone India Limited
Phone.: +91-9716615535
|| naukrikuld...@gmail.com ||
*Please* *Consider the environment. Please don't print this e-mail unless
you really need to.*


On Tue, Jul 16, 2013 at 7:10 PM, Ashish Kumar wrote:

> Dear Seniors,
>
> Thanks for your help, but again i'hve geting same error. querry attached
> please find. and help me to crack the query.
>
>  I'hve getting wrigh output when i put the formula in Name Column, but
> when i paste the same formula in rest of fields like address, process,
> salary...!! the formula is not working and I'hve use this formula with CSE.
> Please suggest me, how i am resolve this.
>
>
>
> Thanks
> Ashish
>
>
> On Tuesday, July 16, 2013 6:49:40 PM UTC+5:30, Kuldeep Singh wrote:
>
>> Hi Ashish,
>>
>> Formula is working fine. Please find the attachment.
>>
>> *Use formula with Ctrl + Shift + Enter (Select All Rows & Press Ctrl +
>> Shift + Enter).*
>>
>> Regards,
>> Kuldeep Singh
>> Assistant Manager Quality
>> Game Zone India Limited
>> Phone.: +91-9716615535
>> || naukri...@gmail.com ||
>>
>> *Please* *Consider the environment. Please don't print this e-mail
>> unless you really need to.*
>>
>> On Tue, Jul 16, 2013 at 6:42 PM, Ashish Kumar wrote:
>>
>>> Dear Seniors,
>>>
>>> Data Getting Error..please find the attached sheet for refrence.
>>>
>>>
>>> Thanks
>>> Ashish
>>>
>>>
>>> On Tuesday, July 16, 2013 5:37:03 PM UTC+5:30, NOORAIN ANSARI wrote:
>>>
 Dear Ashish,

 Please try it..

 =VLOOKUP(I2,CHOOSE(*{1,2,3,4,5,6}*,$A$2:$A$7,$B$2:$B$7,$C$2:$**C**
 $7,$D$2:$D$7,$E$2:$E$7),*{2,4,5,3,6}*,0) with CSE


 Note : Red Color is use for Index No. of Choose Function and green
 Color is Columns Index no. of data




 On Tue, Jul 16, 2013 at 5:20 PM, Ashish Kumar wrote:

>
>
> Dear Seniors,
>
> kindly find attached vlookup query, I want get output thru vlookup
> choose function. please help me on this query and please explain me why we
> use {1,2,3,4,} in formula.
> Thanks in advance.
>
>
>
> Thanks
> Ashish
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/**discu**ssexcel
>
> FORUM RULES
>
> 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) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send
> an email to excel-macros...@**googlegroups.**com.
> To post to this group, send email to excel-...@googlegroups.com.
>
> Visit this group at 
> http://groups.google.com/**group**/excel-macros
> .
> For more options, visit 
> https://groups.google.com/**grou**ps/opt_out
> .
>
>
>



 --
 With Regards,
 Noorain Ansari
 http:// 
 noorainansari.com
 http:// 
 excelvbaclinic.com

   --
>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>> https://www.facebook.com/**discussexcel
>>>
>>> FORUM RULES
>>>
>>> 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 ba

Re: $$Excel-Macros$$ VLOOKUP (CHOOSE) QUERY - URGENT HELP REQ.

[Ashish Kumar]

Dear Seniors,

Thanks for your help, but again i'hve geting same error. querry attached 
please find. and help me to crack the query.

 I'hve getting wrigh output when i put the formula in Name Column, but when 
i paste the same formula in rest of fields like address, process, 
salary...!! the formula is not working and I'hve use this formula with CSE. 
Please suggest me, how i am resolve this.



Thanks
Ashish

On Tuesday, July 16, 2013 6:49:40 PM UTC+5:30, Kuldeep Singh wrote:
>
> Hi Ashish,
>
> Formula is working fine. Please find the attachment.
>
> *Use formula with Ctrl + Shift + Enter (Select All Rows & Press Ctrl + 
> Shift + Enter).*
>
> Regards,
> Kuldeep Singh
> Assistant Manager Quality
> Game Zone India Limited
> Phone.: +91-9716615535
> || naukri...@gmail.com  ||
> *Please* *Consider the environment. Please don't print this e-mail unless 
> you really need to.*
>
> On Tue, Jul 16, 2013 at 6:42 PM, Ashish Kumar 
> 
> > wrote:
>
>> Dear Seniors,
>>
>> Data Getting Error..please find the attached sheet for refrence.
>>
>>
>> Thanks
>> Ashish
>>
>>
>> On Tuesday, July 16, 2013 5:37:03 PM UTC+5:30, NOORAIN ANSARI wrote:
>>
>>> Dear Ashish,
>>>
>>> Please try it..
>>>
>>> =VLOOKUP(I2,CHOOSE(*{1,2,3,4,5,6}*,$A$2:$A$7,$B$2:$B$7,$C$2:$**
>>> C$7,$D$2:$D$7,$E$2:$E$7),*{2,4,5,3,6}*,0) with CSE
>>>
>>>
>>> Note : Red Color is use for Index No. of Choose Function and green Color 
>>> is Columns Index no. of data
>>>
>>>
>>>
>>>
>>> On Tue, Jul 16, 2013 at 5:20 PM, Ashish Kumar wrote:
>>>
  

 Dear Seniors,

 kindly find attached vlookup query, I want get output thru vlookup 
 choose function. please help me on this query and please explain me why we 
 use {1,2,3,4,} in formula.
 Thanks in advance.



 Thanks
 Ashish

 -- 
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? 
 It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
 https://www.facebook.com/**discussexcel
  
 FORUM RULES
  
 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) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.
  
 NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send 
 an email to excel-macros...@**googlegroups.com.
 To post to this group, send email to excel-...@googlegroups.com.

 Visit this group at 
 http://groups.google.com/**group/excel-macros
 .
 For more options, visit 
 https://groups.google.com/**groups/opt_out
 .
  
  

>>>
>>>
>>>
>>> -- 
>>> With Regards,
>>> Noorain Ansari
>>> http:// 
>>> noorainansari.com
>>> http:// 
>>> excelvbaclinic.com
>>>  
>>>
>>>   -- 
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
>> https://www.facebook.com/discussexcel
>>  
>> FORUM RULES
>>  
>> 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) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>  
>> NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an 
>> email to excel-macros...@googlegroups.com .
>> To post to this group, send email to excel-...@googlegroups.com
>> .
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/groups/opt_out.
>>
> 

$$Excel-Macros$$ an excel macro that can take data to produce a skyline chart

[Mog Godiva-Man]

Hi experts,

Does anyone know how to write a macro to create a skyline chart very basic.
Based on date.

Thanks,
Godiva

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

Re: $$Excel-Macros$$ Need Help with Lookup function involving NFL scores

[ashish koul]

which version of excel are you using and last 4 do you mean from top or
bottom of column ?


On Tue, Jul 16, 2013 at 7:33 AM,  wrote:

>
>
> Hello,
>
> I am using Excel 2003. I have attached a simple workbook which has two
> worksheets. One worksheet is titled "Scores" and the other is "Team Info".
> On the team info worksheet, I have all the nfl teams listed in column A. I
> need to solve for the following based on the scores in the "scores"
> worksheet: Last 4 home scoring average, last 8 home scoring average, and
> season to date scoring average. I know basic functions in excel but I am
> sure there has to be simpler formulas. Any help would be greatly
> appreciated.
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 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) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>



-- 
*Regards*
* *
*Ashish Koul*


*Visit*
*My Excel Blog *
Like Us on 
Facebook
Join Us on Facebook 


P Before printing, think about the environment.

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

Re: $$Excel-Macros$$ VLOOKUP (CHOOSE) QUERY - URGENT HELP REQ.

[Kuldeep Singh]

Hi Ashish,

Formula is working fine. Please find the attachment.

*Use formula with Ctrl + Shift + Enter (Select All Rows & Press Ctrl +
Shift + Enter).*

Regards,
Kuldeep Singh
Assistant Manager Quality
Game Zone India Limited
Phone.: +91-9716615535
|| naukrikuld...@gmail.com ||
*Please* *Consider the environment. Please don't print this e-mail unless
you really need to.*

On Tue, Jul 16, 2013 at 6:42 PM, Ashish Kumar wrote:

> Dear Seniors,
>
> Data Getting Error..please find the attached sheet for refrence.
>
>
> Thanks
> Ashish
>
>
> On Tuesday, July 16, 2013 5:37:03 PM UTC+5:30, NOORAIN ANSARI wrote:
>
>> Dear Ashish,
>>
>> Please try it..
>>
>> =VLOOKUP(I2,CHOOSE(*{1,2,3,4,5,6}*,$A$2:$A$7,$B$2:$B$7,$C$2:$**
>> C$7,$D$2:$D$7,$E$2:$E$7),*{2,4,5,3,6}*,0) with CSE
>>
>>
>> Note : Red Color is use for Index No. of Choose Function and green Color
>> is Columns Index no. of data
>>
>>
>>
>>
>> On Tue, Jul 16, 2013 at 5:20 PM, Ashish Kumar wrote:
>>
>>>
>>>
>>> Dear Seniors,
>>>
>>> kindly find attached vlookup query, I want get output thru vlookup
>>> choose function. please help me on this query and please explain me why we
>>> use {1,2,3,4,} in formula.
>>> Thanks in advance.
>>>
>>>
>>>
>>> Thanks
>>> Ashish
>>>
>>> --
>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>> https://www.facebook.com/**discussexcel
>>>
>>> FORUM RULES
>>>
>>> 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) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send
>>> an email to excel-macros...@**googlegroups.com.
>>> To post to this group, send email to excel-...@googlegroups.com.
>>>
>>> Visit this group at 
>>> http://groups.google.com/**group/excel-macros
>>> .
>>> For more options, visit 
>>> https://groups.google.com/**groups/opt_out
>>> .
>>>
>>>
>>>
>>
>>
>>
>> --
>> With Regards,
>> Noorain Ansari
>> http:// 
>> noorainansari.com
>> http:// 
>> excelvbaclinic.com
>>
>>   --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 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) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

Re: $$Excel-Macros$$ VLOOKUP (CHOOSE) QUERY - URGENT HELP REQ.

[Ashish Kumar]

Dear Seniors,

Data Getting Error..please find the attached sheet for refrence.


Thanks
Ashish

On Tuesday, July 16, 2013 5:37:03 PM UTC+5:30, NOORAIN ANSARI wrote:
>
> Dear Ashish,
>
> Please try it..
>
> =VLOOKUP(I2,CHOOSE(*{1,2,3,4,5,6}*
> ,$A$2:$A$7,$B$2:$B$7,$C$2:$C$7,$D$2:$D$7,$E$2:$E$7),*{2,4,5,3,6}*,0) with 
> CSE
>
>
> Note : Red Color is use for Index No. of Choose Function and green Color 
> is Columns Index no. of data
>
>
>
>
> On Tue, Jul 16, 2013 at 5:20 PM, Ashish Kumar 
> 
> > wrote:
>
>>
>>
>> Dear Seniors,
>>
>> kindly find attached vlookup query, I want get output thru vlookup choose 
>> function. please help me on this query and please explain me why we use 
>> {1,2,3,4,} in formula.
>> Thanks in advance.
>>
>>
>>
>> Thanks
>> Ashish
>>
>> -- 
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
>> https://www.facebook.com/discussexcel
>>  
>> FORUM RULES
>>  
>> 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) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>  
>> NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an 
>> email to excel-macros...@googlegroups.com .
>> To post to this group, send email to excel-...@googlegroups.com
>> .
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/groups/opt_out.
>>  
>>  
>>
>
>
>
> -- 
> With Regards,
> Noorain Ansari
> http:// 
> noorainansari.com
> http:// 
> excelvbaclinic.com
>  
>
> 

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.




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

Re: $$Excel-Macros$$ VLOOKUP (CHOOSE) QUERY - URGENT HELP REQ.

[Ashish Kumar]

Dear Sir,

Data geeting Error. please find attached sheet for refrence.


Thanks
Ashish



On Tuesday, July 16, 2013 5:48:14 PM UTC+5:30, sandeep chhajer wrote:
>
> Dear Noorain,
>
> Can you please elaborate the funtion!
> Thanks in advance.
>
> Sandeep Chhajer. 
> Sent on my BlackBerry® from Vodafone
> --
> *From: * NOORAIN ANSARI > 
> *Sender: * excel-...@googlegroups.com  
> *Date: *Tue, 16 Jul 2013 17:37:03 +0530
> *To: *excel-...@googlegroups.com <
> excel-macros@googlegroups.com >
> *ReplyTo: * excel-...@googlegroups.com  
> *Subject: *Re: $$Excel-Macros$$ VLOOKUP (CHOOSE) QUERY - URGENT HELP REQ.
>
> Dear Ashish,
>
> Please try it..
>
> =VLOOKUP(I2,CHOOSE(*{1,2,3,4,5,6}*
> ,$A$2:$A$7,$B$2:$B$7,$C$2:$C$7,$D$2:$D$7,$E$2:$E$7),*{2,4,5,3,6}*,0) with 
> CSE
>
>
> Note : Red Color is use for Index No. of Choose Function and green Color 
> is Columns Index no. of data
>
>
>
>
> On Tue, Jul 16, 2013 at 5:20 PM, Ashish Kumar 
> 
> > wrote:
>
>>
>>
>> Dear Seniors,
>>
>> kindly find attached vlookup query, I want get output thru vlookup choose 
>> function. please help me on this query and please explain me why we use 
>> {1,2,3,4,} in formula.
>> Thanks in advance.
>>
>>
>>
>> Thanks
>> Ashish
>>
>> -- 
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
>> https://www.facebook.com/discussexcel
>>  
>> FORUM RULES
>>  
>> 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) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>  
>> NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an 
>> email to excel-macros...@googlegroups.com .
>> To post to this group, send email to excel-...@googlegroups.com
>> .
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/groups/opt_out.
>>  
>>  
>>
>
>
>
> -- 
> With Regards,
> Noorain Ansari
> http:// 
> noorainansari.com
> http:// 
> excelvbaclinic.com
>  
>
>  -- 
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
> https://www.facebook.com/discussexcel
>  
> FORUM RULES
>  
> 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) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>  
> NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an 
> email to excel-macros...@googlegroups.com .
> To post to this group, send email to excel-...@googlegroups.com
> .
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>  
>  
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message b

Re: $$Excel-Macros$$ VLOOKUP (CHOOSE) QUERY - URGENT HELP REQ.

[chhajersandeep]

Dear Noorain,

Can you please elaborate the funtion!
Thanks in advance.

Sandeep Chhajer.  
Sent on my BlackBerry® from Vodafone

-Original Message-
From: NOORAIN ANSARI 
Sender: excel-macros@googlegroups.com
Date: Tue, 16 Jul 2013 17:37:03 
To: excel-macros@googlegroups.com
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ VLOOKUP (CHOOSE) QUERY - URGENT HELP REQ.

Dear Ashish,

Please try it..

=VLOOKUP(I2,CHOOSE(*{1,2,3,4,5,6}*
,$A$2:$A$7,$B$2:$B$7,$C$2:$C$7,$D$2:$D$7,$E$2:$E$7),*{2,4,5,3,6}*,0) with
CSE


Note : Red Color is use for Index No. of Choose Function and green Color is
Columns Index no. of data




On Tue, Jul 16, 2013 at 5:20 PM, Ashish Kumar wrote:

>
>
> Dear Seniors,
>
> kindly find attached vlookup query, I want get output thru vlookup choose
> function. please help me on this query and please explain me why we use
> {1,2,3,4,} in formula.
> Thanks in advance.
>
>
>
> Thanks
> Ashish
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 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) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>



-- 
With Regards,
Noorain Ansari
http:// 
noorainansari.com
http:// 
excelvbaclinic.com

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.



-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

Re: $$Excel-Macros$$ VLOOKUP (CHOOSE) QUERY - URGENT HELP REQ.

[NOORAIN ANSARI]

Dear Ashish,

Please try it..

=VLOOKUP(I2,CHOOSE(*{1,2,3,4,5,6}*
,$A$2:$A$7,$B$2:$B$7,$C$2:$C$7,$D$2:$D$7,$E$2:$E$7),*{2,4,5,3,6}*,0) with
CSE


Note : Red Color is use for Index No. of Choose Function and green Color is
Columns Index no. of data




On Tue, Jul 16, 2013 at 5:20 PM, Ashish Kumar wrote:

>
>
> Dear Seniors,
>
> kindly find attached vlookup query, I want get output thru vlookup choose
> function. please help me on this query and please explain me why we use
> {1,2,3,4,} in formula.
> Thanks in advance.
>
>
>
> Thanks
> Ashish
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 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) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>



-- 
With Regards,
Noorain Ansari
http:// 
noorainansari.com
http:// 
excelvbaclinic.com

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.




Vlookup Query(Solved).xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

$$Excel-Macros$$ VLOOKUP (CHOOSE) QUERY - URGENT HELP REQ.

[Ashish Kumar]

Dear Seniors,

kindly find attached vlookup query, I want get output thru vlookup choose 
function. please help me on this query and please explain me why we use 
{1,2,3,4,} in formula.
Thanks in advance.



Thanks
Ashish

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.




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

Fwd: $$Excel-Macros$$ Extract the data from one sheet to multiple sheets

[Pravin Gunjal]

Thanks a Lot Vijay Jee. Good one.

Regards/Pravin.

-- Forwarded message --
From: P.VIJAYKUMAR 
Date: Tue, Jul 16, 2013 at 2:41 PM
Subject: Re: $$Excel-Macros$$ Extract the data from one sheet to multiple
sheets
To: "excel-macros@googlegroups.com" 


Respected Pravin,

Create a sheet and remove the Totals rows.This you can selecting and
deleting them using filter.Then Create a Pivot table with Head quarter in
the Report Filter Field and all your required fields as per your required
layout.Now go to the Pivot table Options and select the Create report
filter pages option. You will get all the Sheet created as per the head
quarters with totals.But Your sheets begin with column 2 and Column 1 will
not there.I think your actual requirement will be met even without column
1,because you will get sheets generated according to the head quarters only.

Regards,
VijayKumar


On Tue, Jul 16, 2013 at 2:01 PM, Pravin Gunjal  wrote:

> Hi, I need to extract the data from one sheet to multiple sheets based on
> column "A".
>
> That means the separate sheets must be created "Head Quarter" wise with
> it's total line.  And Row No. 1 & 2 would be the common for all the sheets.
>
> Kly help.  Thanks,
>
> Regards
> Pravin Gunjal.
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 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) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>



-- 









P.VIJAY KUMAR

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an
email to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit 

Re: $$Excel-Macros$$ Query on lookup left side and second, and third values

[Muralidhar E]

Repected Vijay Kumar and Noorain Ansari.

Both of u and the team Thank u very much.

On 16 July 2013 16:46, P.VIJAYKUMAR  wrote:

>  Respected Muralidhar,
>
> See the following link and attached File.
> http://chandoo.org/wp/2010/11/02/multi-condition-lookup/
>
> Regards,
> Vijaykumar
>
>
> On Tue, Jul 16, 2013 at 4:40 PM, Muralidhar E wrote:
>
>>  Thank u
>>
>>
>>
>> On 16 July 2013 16:34, NOORAIN ANSARI  wrote:
>>
>>> Dear Muralidhar.
>>>
>>> it's the largest number that Excel can store. This "Big number" is used
>>> to look up the last number in a range.
>>>
>>>
>>> On Tue, Jul 16, 2013 at 4:09 PM, Muralidhar E 
>>> wrote:
>>>

 Thanks mr, Ansari,

  I cant understand the 9E+307 in the below formula

 =LOOKUP(9E+307,1/(C3:C9=E9),B3:B9)

 plz, help me on this with an example,it is help me more.

 Thanks in advance

 Warm Regards,

 Muralidhar

  On 16 July 2013 15:37, Muralidhar E  wrote:

>  Hi,
>
> ThanksVijay. can u present me with an example,it is better to
> understand me.
>
> Thanks in advance.
>
>  On 16 July 2013 15:07, P.VIJAYKUMAR  wrote:
>
>>  Respected Muralidhar,
>>
>> You can use Index,Match,Indirect functions for accomplishing some
>> look up tasks which are not possible by VLookup.
>>
>> Regards,
>> VijayKumar
>>
>>
>> On Tue, Jul 16, 2013 at 3:02 PM, NOORAIN ANSARI <
>> noorain.ans...@gmail.com> wrote:
>>
>>>  Dear Murlidhar,
>>>
>>> Please visit here..
>>>
>>> http://www.excelvbaclinic.com/2011/08/reverse-vlookup-example.html
>>>
>>>
>>>
>>>  On Tue, Jul 16, 2013 at 2:15 PM, Muralidhar E <
>>> emuralidha...@gmail.com> wrote:
>>>

 Dear Friends good afternoon,

 I need help reg. lookup values

 1.It is possible to vlookup the values for the left side
  2.Vlookup for the second value(occurence), third value
 Is their any other ways or functions to get the results.?

 Thanks in advance.

 --
  *Thanks & Regards,*
 **
 *Muralidhar E.*
 Think different
 Do Different
 Make different

 --
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna
 be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this 
 forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 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) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it,
 send an email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/groups/opt_out.



>>>
>>>
>>>
>>> --
>>> With Regards,
>>> Noorain Ansari
>>> http:// 
>>> noorainansari.com
>>> http:// 
>>> excelvbaclinic.com
>>>
>>>  --
>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES
>>>
>>> 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) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post confiden

Re: $$Excel-Macros$$ Query on lookup left side and second, and third values

[Muralidhar E]

Dear Vijay Kumar.

Thank u



On 16 July 2013 16:40, Muralidhar E  wrote:

>  Thank u
>
>
>
> On 16 July 2013 16:34, NOORAIN ANSARI  wrote:
>
>> Dear Muralidhar.
>>
>> it's the largest number that Excel can store. This "Big number" is used
>> to look up the last number in a range.
>>
>>
>> On Tue, Jul 16, 2013 at 4:09 PM, Muralidhar E wrote:
>>
>>>
>>> Thanks mr, Ansari,
>>>
>>>  I cant understand the 9E+307 in the below formula
>>>
>>> =LOOKUP(9E+307,1/(C3:C9=E9),B3:B9)
>>>
>>> plz, help me on this with an example,it is help me more.
>>>
>>> Thanks in advance
>>>
>>> Warm Regards,
>>>
>>> Muralidhar
>>>
>>>  On 16 July 2013 15:37, Muralidhar E  wrote:
>>>
  Hi,

 ThanksVijay. can u present me with an example,it is better to
 understand me.

 Thanks in advance.

  On 16 July 2013 15:07, P.VIJAYKUMAR  wrote:

>  Respected Muralidhar,
>
> You can use Index,Match,Indirect functions for accomplishing some look
> up tasks which are not possible by VLookup.
>
> Regards,
> VijayKumar
>
>
> On Tue, Jul 16, 2013 at 3:02 PM, NOORAIN ANSARI <
> noorain.ans...@gmail.com> wrote:
>
>>  Dear Murlidhar,
>>
>> Please visit here..
>>
>> http://www.excelvbaclinic.com/2011/08/reverse-vlookup-example.html
>>
>>
>>
>>  On Tue, Jul 16, 2013 at 2:15 PM, Muralidhar E <
>> emuralidha...@gmail.com> wrote:
>>
>>>
>>> Dear Friends good afternoon,
>>>
>>> I need help reg. lookup values
>>>
>>> 1.It is possible to vlookup the values for the left side
>>>  2.Vlookup for the second value(occurence), third value
>>> Is their any other ways or functions to get the results.?
>>>
>>> Thanks in advance.
>>>
>>> --
>>>  *Thanks & Regards,*
>>> **
>>> *Muralidhar E.*
>>> Think different
>>> Do Different
>>> Make different
>>>
>>> --
>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES
>>>
>>> 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) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it,
>>> send an email to excel-macros+unsubscr...@googlegroups.com.
>>> To post to this group, send email to excel-macros@googlegroups.com.
>>> Visit this group at http://groups.google.com/group/excel-macros.
>>> For more options, visit https://groups.google.com/groups/opt_out.
>>>
>>>
>>>
>>
>>
>>
>> --
>> With Regards,
>> Noorain Ansari
>> http:// 
>> noorainansari.com
>> http:// 
>> excelvbaclinic.com
>>
>>  --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 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) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it,
>> send an email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegr

Re: $$Excel-Macros$$ Query on lookup left side and second, and third values

[Muralidhar E]

Thank u



On 16 July 2013 16:34, NOORAIN ANSARI  wrote:

> Dear Muralidhar.
>
> it's the largest number that Excel can store. This "Big number" is used to
> look up the last number in a range.
>
>
> On Tue, Jul 16, 2013 at 4:09 PM, Muralidhar E wrote:
>
>>
>> Thanks mr, Ansari,
>>
>>  I cant understand the 9E+307 in the below formula
>>
>> =LOOKUP(9E+307,1/(C3:C9=E9),B3:B9)
>>
>> plz, help me on this with an example,it is help me more.
>>
>> Thanks in advance
>>
>> Warm Regards,
>>
>> Muralidhar
>>
>>  On 16 July 2013 15:37, Muralidhar E  wrote:
>>
>>>  Hi,
>>>
>>> ThanksVijay. can u present me with an example,it is better to understand
>>> me.
>>>
>>> Thanks in advance.
>>>
>>>  On 16 July 2013 15:07, P.VIJAYKUMAR  wrote:
>>>
  Respected Muralidhar,

 You can use Index,Match,Indirect functions for accomplishing some look
 up tasks which are not possible by VLookup.

 Regards,
 VijayKumar


 On Tue, Jul 16, 2013 at 3:02 PM, NOORAIN ANSARI <
 noorain.ans...@gmail.com> wrote:

>  Dear Murlidhar,
>
> Please visit here..
>
> http://www.excelvbaclinic.com/2011/08/reverse-vlookup-example.html
>
>
>
>  On Tue, Jul 16, 2013 at 2:15 PM, Muralidhar E <
> emuralidha...@gmail.com> wrote:
>
>>
>> Dear Friends good afternoon,
>>
>> I need help reg. lookup values
>>
>> 1.It is possible to vlookup the values for the left side
>>  2.Vlookup for the second value(occurence), third value
>> Is their any other ways or functions to get the results.?
>>
>> Thanks in advance.
>>
>> --
>>  *Thanks & Regards,*
>> **
>> *Muralidhar E.*
>> Think different
>> Do Different
>> Make different
>>
>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 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) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it,
>> send an email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/groups/opt_out.
>>
>>
>>
>
>
>
> --
> With Regards,
> Noorain Ansari
> http:// 
> noorainansari.com
> http:// 
> excelvbaclinic.com
>
>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 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) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send
> an email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>



 --






>>

Re: $$Excel-Macros$$ Query on lookup left side and second, and third values

[P.VIJAYKUMAR]

Respected Muralidhar,

You can see the following links for Examples
http://exceluser.com/blog/465/excels-best-lookup-method-index-match.html
http://www.youtube.com/watch?v=IX2TZ3OlOlA
http://www.randomwok.com/excel/how-to-use-index-match/

Regards,
Vijaykumar


On Tue, Jul 16, 2013 at 3:37 PM, Muralidhar E wrote:

> Hi,
>
> ThanksVijay. can u present me with an example,it is better to understand
> me.
>
> Thanks in advance.
>
> On 16 July 2013 15:07, P.VIJAYKUMAR  wrote:
>
>>  Respected Muralidhar,
>>
>> You can use Index,Match,Indirect functions for accomplishing some look up
>> tasks which are not possible by VLookup.
>>
>> Regards,
>> VijayKumar
>>
>>
>> On Tue, Jul 16, 2013 at 3:02 PM, NOORAIN ANSARI > > wrote:
>>
>>>  Dear Murlidhar,
>>>
>>> Please visit here..
>>>
>>> http://www.excelvbaclinic.com/2011/08/reverse-vlookup-example.html
>>>
>>>
>>>
>>>  On Tue, Jul 16, 2013 at 2:15 PM, Muralidhar E 
>>> wrote:
>>>

 Dear Friends good afternoon,

 I need help reg. lookup values

 1.It is possible to vlookup the values for the left side
  2.Vlookup for the second value(occurence), third value
 Is their any other ways or functions to get the results.?

 Thanks in advance.

 --
  *Thanks & Regards,*
 **
 *Muralidhar E.*
 Think different
 Do Different
 Make different

 --
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
 It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 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) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send
 an email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/groups/opt_out.



>>>
>>>
>>>
>>> --
>>> With Regards,
>>> Noorain Ansari
>>> http:// 
>>> noorainansari.com
>>> http:// 
>>> excelvbaclinic.com
>>>
>>>  --
>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES
>>>
>>> 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) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send
>>> an email to excel-macros+unsubscr...@googlegroups.com.
>>> To post to this group, send email to excel-macros@googlegroups.com.
>>> Visit this group at http://groups.google.com/group/excel-macros.
>>> For more options, visit https://groups.google.com/groups/opt_out.
>>>
>>>
>>>
>>
>>
>>
>> --
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> P.VIJAY KUMAR
>>
>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 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 by

Re: $$Excel-Macros$$ Query on lookup left side and second, and third values

[NOORAIN ANSARI]

Dear Muralidhar.

it's the largest number that Excel can store. This "Big number" is used to
look up the last number in a range.


On Tue, Jul 16, 2013 at 4:09 PM, Muralidhar E wrote:

>
> Thanks mr, Ansari,
>
>  I cant understand the 9E+307 in the below formula
>
> =LOOKUP(9E+307,1/(C3:C9=E9),B3:B9)
>
> plz, help me on this with an example,it is help me more.
>
> Thanks in advance
>
> Warm Regards,
>
> Muralidhar
>
> On 16 July 2013 15:37, Muralidhar E  wrote:
>
>>  Hi,
>>
>> ThanksVijay. can u present me with an example,it is better to understand
>> me.
>>
>> Thanks in advance.
>>
>>  On 16 July 2013 15:07, P.VIJAYKUMAR  wrote:
>>
>>>  Respected Muralidhar,
>>>
>>> You can use Index,Match,Indirect functions for accomplishing some look
>>> up tasks which are not possible by VLookup.
>>>
>>> Regards,
>>> VijayKumar
>>>
>>>
>>> On Tue, Jul 16, 2013 at 3:02 PM, NOORAIN ANSARI <
>>> noorain.ans...@gmail.com> wrote:
>>>
  Dear Murlidhar,

 Please visit here..

 http://www.excelvbaclinic.com/2011/08/reverse-vlookup-example.html



  On Tue, Jul 16, 2013 at 2:15 PM, Muralidhar E >>> > wrote:

>
> Dear Friends good afternoon,
>
> I need help reg. lookup values
>
> 1.It is possible to vlookup the values for the left side
>  2.Vlookup for the second value(occurence), third value
> Is their any other ways or functions to get the results.?
>
> Thanks in advance.
>
> --
>  *Thanks & Regards,*
> **
> *Muralidhar E.*
> Think different
> Do Different
> Make different
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 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) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send
> an email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>



 --
 With Regards,
 Noorain Ansari
 http:// 
 noorainansari.com
 http:// 
 excelvbaclinic.com

  --
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
 It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 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) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send
 an email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/groups/opt_out.



>>>
>>>
>>>
>>> --
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>> P.VIJAY KUMAR
>>>
>>> --
>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RUL

Re: $$Excel-Macros$$ Query on lookup left side and second, and third values

[Muralidhar E]

Thanks mr, Ansari,

 I cant understand the 9E+307 in the below formula

=LOOKUP(9E+307,1/(C3:C9=E9),B3:B9)

plz, help me on this with an example,it is help me more.

Thanks in advance

Warm Regards,

Muralidhar

On 16 July 2013 15:37, Muralidhar E  wrote:

>  Hi,
>
> ThanksVijay. can u present me with an example,it is better to understand
> me.
>
> Thanks in advance.
>
>  On 16 July 2013 15:07, P.VIJAYKUMAR  wrote:
>
>>  Respected Muralidhar,
>>
>> You can use Index,Match,Indirect functions for accomplishing some look up
>> tasks which are not possible by VLookup.
>>
>> Regards,
>> VijayKumar
>>
>>
>> On Tue, Jul 16, 2013 at 3:02 PM, NOORAIN ANSARI > > wrote:
>>
>>>  Dear Murlidhar,
>>>
>>> Please visit here..
>>>
>>> http://www.excelvbaclinic.com/2011/08/reverse-vlookup-example.html
>>>
>>>
>>>
>>>  On Tue, Jul 16, 2013 at 2:15 PM, Muralidhar E 
>>> wrote:
>>>

 Dear Friends good afternoon,

 I need help reg. lookup values

 1.It is possible to vlookup the values for the left side
  2.Vlookup for the second value(occurence), third value
 Is their any other ways or functions to get the results.?

 Thanks in advance.

 --
  *Thanks & Regards,*
 **
 *Muralidhar E.*
 Think different
 Do Different
 Make different

 --
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
 It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 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) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send
 an email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/groups/opt_out.



>>>
>>>
>>>
>>> --
>>> With Regards,
>>> Noorain Ansari
>>> http:// 
>>> noorainansari.com
>>> http:// 
>>> excelvbaclinic.com
>>>
>>>  --
>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES
>>>
>>> 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) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send
>>> an email to excel-macros+unsubscr...@googlegroups.com.
>>> To post to this group, send email to excel-macros@googlegroups.com.
>>> Visit this group at http://groups.google.com/group/excel-macros.
>>> For more options, visit https://groups.google.com/groups/opt_out.
>>>
>>>
>>>
>>
>>
>>
>> --
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> P.VIJAY KUMAR
>>
>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 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 re

Re: $$Excel-Macros$$ Query on lookup left side and second, and third values

[Muralidhar E]

Hi,

ThanksVijay. can u present me with an example,it is better to understand me.

Thanks in advance.

On 16 July 2013 15:07, P.VIJAYKUMAR  wrote:

>  Respected Muralidhar,
>
> You can use Index,Match,Indirect functions for accomplishing some look up
> tasks which are not possible by VLookup.
>
> Regards,
> VijayKumar
>
>
> On Tue, Jul 16, 2013 at 3:02 PM, NOORAIN ANSARI 
> wrote:
>
>>  Dear Murlidhar,
>>
>> Please visit here..
>>
>> http://www.excelvbaclinic.com/2011/08/reverse-vlookup-example.html
>>
>>
>>
>>  On Tue, Jul 16, 2013 at 2:15 PM, Muralidhar E 
>> wrote:
>>
>>>
>>> Dear Friends good afternoon,
>>>
>>> I need help reg. lookup values
>>>
>>> 1.It is possible to vlookup the values for the left side
>>>  2.Vlookup for the second value(occurence), third value
>>> Is their any other ways or functions to get the results.?
>>>
>>> Thanks in advance.
>>>
>>> --
>>>  *Thanks & Regards,*
>>> **
>>> *Muralidhar E.*
>>> Think different
>>> Do Different
>>> Make different
>>>
>>> --
>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES
>>>
>>> 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) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send
>>> an email to excel-macros+unsubscr...@googlegroups.com.
>>> To post to this group, send email to excel-macros@googlegroups.com.
>>> Visit this group at http://groups.google.com/group/excel-macros.
>>> For more options, visit https://groups.google.com/groups/opt_out.
>>>
>>>
>>>
>>
>>
>>
>> --
>> With Regards,
>> Noorain Ansari
>> http:// 
>> noorainansari.com
>> http:// 
>> excelvbaclinic.com
>>
>>  --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 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) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/groups/opt_out.
>>
>>
>>
>
>
>
> --
>
>
>
>
>
>
>
>
>
> P.VIJAY KUMAR
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 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) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post 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 unsubscribe from this group and stop r

Re: $$Excel-Macros$$ Re: Copy and Paste to New Spreadsheet then delete Macro HELP!

[De Premor]

PFA

On 16/07/2013 11:56, yas wrote:

Ill add my spreadsheet to help.
Its meant to work as a submit button, then transfer over data, then 
clear Form 2 for someone else to add information.


On Tuesday, 16 July 2013 13:20:14 UTC+10, yas wrote:

Hi,
Im chasing help. I have two spreadsheets in which someone will
enter data in one and it will copy over the data to the next
speadsheet and then the original data will be deleted to start
again. I have done this so far that the data transfers over but
cannot get the data to clear once it has been copied.
Also if any of the below could be cleared up to make it any easier?
Thanks heaps in advance.
Sub EnterData()
'
' EnterData Macro
' Macro recorded 27/06/2013 by 94572
'
Range("D2:D8").Select
Selection.Copy
Sheets("Register").Select
Range("B4").Select
Selection.End(xlDown).Select
ActiveCell.Offset(1, 0).Range("A1").Select
Selection.PasteSpecial Paste:=xlPasteValues,
Operation:=xlNone, SkipBlanks _
:=False, Transpose:=True
End Sub

Sub Newrow()
'
Range("b4").Select
If Range("b5") <> "" Then
Selection.End(xlDown).Select
ActiveCell.Offset(1, 0).Range("A1").Select
Else: Range("b5").Select
Selection.PasteSpecial Paste:=xlPasteValues,
Operation:=xlNone, SkipBlanks _
:=False, Transpose:=True
Sheets("Form (2)").Select
Range("D2:D8").Select
Selection.Copy
Sheets("Register").Select
Range("B4").Select
Selection.End(xlDown).Select
ActiveCell.Offset(1, 0).Range("A1").Select
Selection.PasteSpecial Paste:=xlPasteValues,
Operation:=xlNone, SkipBlanks _
:=False, Transpose:=True
   End If
End Sub

--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? 
It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel


FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send 
an email to excel-macros+unsubscr...@googlegroups.com.

To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.




--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.




Sample 4 yas.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

Re: $$Excel-Macros$$ Query on lookup left side and second, and third values

[P.VIJAYKUMAR]

Respected Muralidhar,

You can use Index,Match,Indirect functions for accomplishing some look up
tasks which are not possible by VLookup.

Regards,
VijayKumar


On Tue, Jul 16, 2013 at 3:02 PM, NOORAIN ANSARI wrote:

> Dear Murlidhar,
>
> Please visit here..
>
> http://www.excelvbaclinic.com/2011/08/reverse-vlookup-example.html
>
>
>
> On Tue, Jul 16, 2013 at 2:15 PM, Muralidhar E wrote:
>
>>
>> Dear Friends good afternoon,
>>
>> I need help reg. lookup values
>>
>> 1.It is possible to vlookup the values for the left side
>>  2.Vlookup for the second value(occurence), third value
>> Is their any other ways or functions to get the results.?
>>
>> Thanks in advance.
>>
>> --
>>  *Thanks & Regards,*
>> **
>> *Muralidhar E.*
>> Think different
>> Do Different
>> Make different
>>
>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 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) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/groups/opt_out.
>>
>>
>>
>
>
>
> --
> With Regards,
> Noorain Ansari
> http:// 
> noorainansari.com
> http:// 
> excelvbaclinic.com
>
>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 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) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>



-- 









P.VIJAY KUMAR

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

Re: $$Excel-Macros$$ Query on lookup left side and second, and third values

[NOORAIN ANSARI]

Dear Murlidhar,

Please visit here..

http://www.excelvbaclinic.com/2011/08/reverse-vlookup-example.html



On Tue, Jul 16, 2013 at 2:15 PM, Muralidhar E wrote:

>
> Dear Friends good afternoon,
>
> I need help reg. lookup values
>
> 1.It is possible to vlookup the values for the left side
>  2.Vlookup for the second value(occurence), third value
> Is their any other ways or functions to get the results.?
>
> Thanks in advance.
>
> --
>  *Thanks & Regards,*
> **
> *Muralidhar E.*
> Think different
> Do Different
> Make different
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 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) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>



-- 
With Regards,
Noorain Ansari
http:// 
noorainansari.com
http:// 
excelvbaclinic.com

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

Re: $$Excel-Macros$$ Query on lookup left side and second, and third values

[priti verma]

PFA


On Tue, Jul 16, 2013 at 2:15 PM, Muralidhar E wrote:

>
> Dear Friends good afternoon,
>
> I need help reg. lookup values
>
> 1.It is possible to vlookup the values for the left side
>  2.Vlookup for the second value(occurence), third value
> Is their any other ways or functions to get the results.?
>
> Thanks in advance.
>
> --
>  *Thanks & Regards,*
> **
> *Muralidhar E.*
> Think different
> Do Different
> Make different
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 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) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.




left sided value by vlookup.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

$$Excel-Macros$$ NEED FORMUALE TO PLACE DIFFERENT TYPE OF BOTTLES IN ROWS (NO DIFFERENT BOTTLES ON SAME ROW)

[vijay yadav]

Dear All,

I have some data which is in  2 columns A & B.
A column contains actual number of different type of bottles
B contains maximum number of bottles that can be placed in the row.
I want the output in C column which gives the number of bottles that can be 
placed with help of formulae such that for any values in column A and B the 
output of column C will be always available.
Can someone help.

The sheet is attached along with this post.Please have a look at it.


I will explain my problem here with a small example.Kindly note the actual 
ranges of A is max 24 nos,B is fixed 16 nos and output is fixed 16 nos.

 A B C  54 53 53  48 53 149 48 
Column -A= I have 54 plastic bottles and 48 red glass bottle
Column B =gives maximum number of same type of bottle which can be placed 
I.e I can place 53 in first row but in second row i can place only 1 as 48 
bottles are of different type.
Column C =  the actual bottle placed i.e output with help of  formula 

Kindly note the actual ranges of A is max 24 nos,B is fixed 16 nos and 
output is fixed 16 nos.

A  B
Regards
Vijay Yadav

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.




place bottles.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Need macro or Formula

[De Premor]

Ups sorry, my mistake
i've attached new file for revision

Rgds,
[dp]

On 16/07/2013 15:27, Mukesh Kumar wrote:
Thanks a lot Sir, but duplicate entries are also coming twice eg Alwar 
is coming twice in  result. Can it also come single time.


Regards,
Mukesh Kumar


On Tue, Jul 16, 2013 at 1:48 PM, De Premor > wrote:


Solution Attached


On 16/07/2013 14:10, Mukesh Kumar wrote:

Hi Experts,

I need macro /formula for query given in attached file. The
result should come based on values given in column A.


Regards,
Mukesh Kumar
-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you

wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook
page of this forum @ https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from
it, send an email to excel-macros+unsubscr...@googlegroups.com
.
To post to this group, send email to
excel-macros@googlegroups.com
.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.



-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna

be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this
forum @ https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post 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 unsubscribe from this group and stop receiving emails from it,
send an email to excel-macros+unsubscr...@googlegroups.com
.
To post to this group, send email to excel-macros@googlegroups.com
.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.



--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? 
It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel


FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send 
an email to excel-macros+unsubscr...@googlegroups.com.

To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.




--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.faceb

Re: $$Excel-Macros$$ Extract the data from one sheet to multiple sheets

[P.VIJAYKUMAR]

Respected Pravin,

Create a sheet and remove the Totals rows.This you can selecting and
deleting them using filter.Then Create a Pivot table with Head quarter in
the Report Filter Field and all your required fields as per your required
layout.Now go to the Pivot table Options and select the Create report
filter pages option. You will get all the Sheet created as per the head
quarters with totals.But Your sheets begin with column 2 and Column 1 will
not there.I think your actual requirement will be met even without column
1,because you will get sheets generated according to the head quarters only.

Regards,
VijayKumar


On Tue, Jul 16, 2013 at 2:01 PM, Pravin Gunjal  wrote:

> Hi, I need to extract the data from one sheet to multiple sheets based on
> column "A".
>
> That means the separate sheets must be created "Head Quarter" wise with
> it's total line.  And Row No. 1 & 2 would be the common for all the sheets.
>
> Kly help.  Thanks,
>
> Regards
> Pravin Gunjal.
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 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) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>



-- 









P.VIJAY KUMAR

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

$$Excel-Macros$$ Query on lookup left side and second, and third values

[Muralidhar E]

Dear Friends good afternoon,

I need help reg. lookup values

1.It is possible to vlookup the values for the left side
 2.Vlookup for the second value(occurence), third value
Is their any other ways or functions to get the results.?

Thanks in advance.

-- 
 *Thanks & Regards,*
**
*Muralidhar E.*
Think different
Do Different
Make different

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

Re: $$Excel-Macros$$ Need macro or Formula

[Mukesh Kumar]

Thanks a lot Sir, but duplicate entries are also coming twice eg Alwar is
coming twice in  result. Can it also come single time.

Regards,
Mukesh Kumar


On Tue, Jul 16, 2013 at 1:48 PM, De Premor  wrote:

> Solution Attached
>
>
> On 16/07/2013 14:10, Mukesh Kumar wrote:
>
>> Hi Experts,
>>
>> I need macro /formula for query given in attached file. The result should
>> come based on values given in column A.
>>
>>
>> Regards,
>> Mukesh Kumar
>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/**discussexcel
>>
>> FORUM RULES
>>
>> 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) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an
>> email to 
>> excel-macros+unsubscribe@**googlegroups.com
>> .
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at 
>> http://groups.google.com/**group/excel-macros
>> .
>> For more options, visit 
>> https://groups.google.com/**groups/opt_out
>> .
>>
>>
>>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/**discussexcel
>
> FORUM RULES
>
> 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) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE  : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an
> email to 
> excel-macros+unsubscribe@**googlegroups.com
> .
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at 
> http://groups.google.com/**group/excel-macros
> .
> For more options, visit 
> https://groups.google.com/**groups/opt_out
> .
>
>
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

Re: $$Excel-Macros$$ Need macro or Formula

[De Premor]

Solution Attached

On 16/07/2013 14:10, Mukesh Kumar wrote:

Hi Experts,

I need macro /formula for query given in attached file. The result 
should come based on values given in column A.



Regards,
Mukesh Kumar
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? 
It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel


FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send 
an email to excel-macros+unsubscr...@googlegroups.com.

To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.




--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.




ConcatIf.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

$$Excel-Macros$$ how to write provide new id card for office

[Nandkumar kakvipure]

Hello Guys,

Please help Me how to write this :(

Thanks In Advance

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

Re: $$Excel-Macros$$ Help need on attached Excel

[vikas khen]

Hi Team,

Expecting replay on this mail as It will very helpful for me

Regards


On Thu, Jul 11, 2013 at 1:43 PM, vikas khen  wrote:

> Hi Experts,
>
> I have found below attached Excel tracker on group it's Fantastic  it's
> amazing! but i need to understand how it's Attendance calculate is
> working? but its not showing results. is there  any setting to activate the
> Calculator? if YES then kindly give the details of the same.
>
> *Regards *
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 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) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

$$Excel-Macros$$ Need macro or Formula

[Mukesh Kumar]

Hi Experts,

I need macro /formula for query given in attached file. The result should
come based on values given in column A.


Regards,
Mukesh Kumar

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.




Query.xls
Description: MS-Excel spreadsheet