Re: $$Excel-Macros$$ Vlookup problem

[mrExcel4u]

Share your workbook plz

Thanks & regards,

www.MrExcel4U.com 


On Thu, Mar 6, 2014 at 3:55 PM, Dileep Kumar  wrote:

> Hi Manish,
>
> Will you please elobrate with example data.
>
>
> On Thu, Mar 6, 2014 at 3:52 PM, manish jaiswal 
> wrote:
>
>>
>> using vlookup and requirement is pick data from other sheet.
>> I have data in 10 column and first column is unique column.i want pick
>> only limited column like 4 6 9 column.and requirement is only one time use
>> vlookup formula and pick all data in other sheet by unique column.
>>
>> --
>> 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,
> Dileep Kumar Kaza
>
> --
> 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 problem

[Dileep Kumar]

Hi Manish,

Will you please elobrate with example data.


On Thu, Mar 6, 2014 at 3:52 PM, manish jaiswal wrote:

>
> using vlookup and requirement is pick data from other sheet.
> I have data in 10 column and first column is unique column.i want pick
> only limited column like 4 6 9 column.and requirement is only one time use
> vlookup formula and pick all data in other sheet by unique column.
>
> --
> 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,
Dileep Kumar Kaza

-- 
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$$ Vlookup problem

[manish jaiswal]

using vlookup and requirement is pick data from other sheet.
I have data in 10 column and first column is unique column.i want pick only 
limited column like 4 6 9 column.and requirement is only one time use 
vlookup formula and pick all data in other sheet by unique column.

-- 
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$$ vlookup problem

[Priti_Verma]

Hi ,

I hope this will help u 

=INDEX($A$1:$C$6,MATCH(E16,$B$1:$B$6,0),1)

And see the attach file

 

Priti verma

 

-- 
-- 
FORUM RULES (986+ members already BANNED for violation)

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

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

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

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

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

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com




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

$$Excel-Macros$$ vlookup problem

[Priti_Verma]

Hi 

I hope this formula will help u

=INDEX($A$1:$C$6,MATCH(E16,$B$1:$B$6,0),1)

And see the attach file.

Priti

 

-- 
-- 
FORUM RULES (986+ members already BANNED for violation)

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

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

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

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

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

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com




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

Re: $$Excel-Macros$$ Vlookup Problem

[Mangesh Vimay]

Thank you so much for providing such a nice solution.
Thanks again ALL.

On Tue, Jul 17, 2012 at 12:07 AM, Bé Trần Văn wrote:

> Do as you like.
>
>
>
> 2012/7/17 Venkatesh Narla 
>
>> Hi,
>> Please find the attachment and let me know.. any thing els need..
>>
>>
>> Thanks,
>> Venkatesh.
>>
>>
>> On Mon, Jul 16, 2012 at 4:33 PM, Mangesh Vimay 
>> wrote:
>>  > Hi Friends,
>> >
>> > Please solve my VLookup Query.
>> > Description is given in attached file.
>> > Thanks.
>> >
>> > --
>> > With regards,
>> >
>> > MaNgEsH
>> >
>> > --
>> > FORUM RULES (986+ members already BANNED for violation)
>> >
>> > 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will
>> > not get quick attention or may not be answered.
>> >
>> > 2) Don't post a question in the thread of another member.
>> >
>> > 3) Don't post questions regarding breaking or bypassing any security
>> > measure.
>> >
>> > 4) Acknowledge the responses you receive, good or bad.
>> >
>> > 5) Cross-promotion of, or links to, forums competitive to this forum in
>> > signatures are prohibited.
>> >
>> > NOTE : Don't ever post personal or confidential data in a workbook.
>> Forum
>> > owners and members are not responsible for any loss.
>> >
>> >
>> --
>> > To post to this group, send email to excel-macros@googlegroups.com
>> >
>> > To unsubscribe, send a blank email to
>> > excel-macros+unsubscr...@googlegroups.com
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5)  Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE  : Don't ever post personal or confidential data in a workbook.
>> Forum owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>>
>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>



-- 
With regards,

MaNgEsH

-- 
-- 
FORUM RULES (986+ members already BANNED for violation)

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

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

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

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

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

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ Vlookup Problem

[Bé Trần Văn]

Do as you like.



2012/7/17 Venkatesh Narla 

> Hi,
> Please find the attachment and let me know.. any thing els need..
>
>
> Thanks,
> Venkatesh.
>
>
> On Mon, Jul 16, 2012 at 4:33 PM, Mangesh Vimay 
> wrote:
>  > Hi Friends,
> >
> > Please solve my VLookup Query.
> > Description is given in attached file.
> > Thanks.
> >
> > --
> > With regards,
> >
> > MaNgEsH
> >
> > --
> > FORUM RULES (986+ members already BANNED for violation)
> >
> > 1) Use concise, accurate thread titles. Poor thread titles, like Please
> > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will
> > not get quick attention or may not be answered.
> >
> > 2) Don't post a question in the thread of another member.
> >
> > 3) Don't post questions regarding breaking or bypassing any security
> > measure.
> >
> > 4) Acknowledge the responses you receive, good or bad.
> >
> > 5) Cross-promotion of, or links to, forums competitive to this forum in
> > signatures are prohibited.
> >
> > NOTE : Don't ever post personal or confidential data in a workbook. Forum
> > owners and members are not responsible for any loss.
> >
> >
> --
> > To post to this group, send email to excel-macros@googlegroups.com
> >
> > To unsubscribe, send a blank email to
> > excel-macros+unsubscr...@googlegroups.com
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5)  Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE  : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>

-- 
FORUM RULES (986+ members already BANNED for violation)

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

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

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

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

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

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Vlookup Problem..xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Vlookup Problem

[Venkatesh Narla]

Hi,
Please find the attachment and let me know.. any thing els need..


Thanks,
Venkatesh.


On Mon, Jul 16, 2012 at 4:33 PM, Mangesh Vimay  wrote:
> Hi Friends,
>
> Please solve my VLookup Query.
> Description is given in attached file.
> Thanks.
>
> --
> With regards,
>
> MaNgEsH
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
> not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com

-- 
FORUM RULES (986+ members already BANNED for violation)

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

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

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

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

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

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

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

Re: $$Excel-Macros$$ Vlookup Problem

[╰» ℓαℓιт мσαнη]

Hi Mangesh,

If you want to learn how vlookup works may be below links helps you..

http://www.free-training-tutorial.com/function-vlookup.html
http://spreadsheets.about.com/od/excelfunctions/ss/90320vlookup.htm


Regards,
Lalit Mohan


On Mon, Jul 16, 2012 at 5:27 PM, Mangesh Vimay  wrote:
> Its really helpful.
> U have done full R & D here.
> Thanks lot.
>
>
> On Mon, Jul 16, 2012 at 5:03 PM, NOORAIN ANSARI 
> wrote:
>>
>> Dear Mangesh,
>>
>> You can also use..
>>
>> =LOOKUP(9E+300,1/(($B$2:$B$6=F3)*($C$2:$C$6=G3)),$A$2:$A$6)
>>
>> or
>>
>> =INDEX($A$2:$A$6,MATCH(1,(($B$2:$B$6=F3)*($C$2:$C$6=$G3)),0))
>>
>> or
>>
>> =OFFSET($A$1,MATCH(1,(($B$2:$B$6=$F3)*($C$2:$C$6=$G3)),0),0)
>>
>> with ctrl+shift+Enter
>>
>> See attached sheet.
>>
>>
>> --
>> Thanks & regards,
>> Noorain Ansari
>> www.noorainansari.com
>> www.excelmacroworld.blogspot.com
>>
>> On Mon, Jul 16, 2012 at 4:33 PM, Mangesh Vimay 
>> wrote:
>>>
>>> Hi Friends,
>>>
>>> Please solve my VLookup Query.
>>> Description is given in attached file.
>>> Thanks.
>>>
>>> --
>>> With regards,
>>>
>>> MaNgEsH
>>>
>>> --
>>> FORUM RULES (986+ members already BANNED for violation)
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
>>> not get quick attention or may not be answered.
>>>
>>> 2) Don't post a question in the thread of another member.
>>>
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>>
>>> 4) Acknowledge the responses you receive, good or bad.
>>>
>>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>>> owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> To unsubscribe, send a blank email to
>>> excel-macros+unsubscr...@googlegroups.com
>>
>>
>>
>>
>>
>>
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
>> not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>
>
>
>
> --
> With regards,
>
> MaNgEsH
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
> not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com

-- 
FORUM RULES (986+ members already BANNED for violation)

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

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

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

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

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

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups

Re: $$Excel-Macros$$ Vlookup Problem

[Mangesh Vimay]

Its really helpful.
U have done full R & D here.
Thanks lot.

On Mon, Jul 16, 2012 at 5:03 PM, NOORAIN ANSARI wrote:

> Dear Mangesh,
>
> You can also use..
>
> *=LOOKUP(9E+300,1/(($B$2:$B$6=F3)*($C$2:$C$6=G3)),$A$2:$A$6)*
>
> or
>
> *=INDEX($A$2:$A$6,MATCH(1,(($B$2:$B$6=F3)*($C$2:$C$6=$G3)),0))*
>
> or
>
> *=OFFSET($A$1,MATCH(1,(($B$2:$B$6=$F3)*($C$2:$C$6=$G3)),0),0)*
>
> with ctrl+shift+Enter
>
> See attached sheet.
>
>
> --
> Thanks & regards,
> Noorain Ansari
> www.noorainansari.com
> www.excelmacroworld.blogspot.com
>
> On Mon, Jul 16, 2012 at 4:33 PM, Mangesh Vimay wrote:
>
>> Hi Friends,
>>
>> Please solve my VLookup Query.
>> Description is given in attached file.
>> Thanks.
>>
>> --
>> With regards,
>>
>> MaNgEsH
>>
>>  --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>
>
>
>
>
>
>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>



-- 
With regards,

MaNgEsH

-- 
FORUM RULES (986+ members already BANNED for violation)

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

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

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

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

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

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ Vlookup Problem

[NOORAIN ANSARI]

Dear Mangesh,

You can also use..

*=LOOKUP(9E+300,1/(($B$2:$B$6=F3)*($C$2:$C$6=G3)),$A$2:$A$6)*

or

*=INDEX($A$2:$A$6,MATCH(1,(($B$2:$B$6=F3)*($C$2:$C$6=$G3)),0))*

or

*=OFFSET($A$1,MATCH(1,(($B$2:$B$6=$F3)*($C$2:$C$6=$G3)),0),0)*

with ctrl+shift+Enter

See attached sheet.


-- 
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com

On Mon, Jul 16, 2012 at 4:33 PM, Mangesh Vimay wrote:

> Hi Friends,
>
> Please solve my VLookup Query.
> Description is given in attached file.
> Thanks.
>
> --
> With regards,
>
> MaNgEsH
>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com

-- 
FORUM RULES (986+ members already BANNED for violation)

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

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

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

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

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

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Copy of VLookUp Problem Solved(Mangesh)-16Jul12.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Vlookup Problem

[Mangesh Vimay]

so much

On Mon, Jul 16, 2012 at 4:51 PM, Mangesh Vimay wrote:

> Thank you much Suman
>
>
> On Mon, Jul 16, 2012 at 4:48 PM, Suman  wrote:
>
>> Dear Mangesh,
>> Please find the attached file as I have learnt this one form Noorain sir
>> in this group.
>>
>> On Mon, Jul 16, 2012 at 4:33 PM, Mangesh Vimay 
>> wrote:
>>
>>> Hi Friends,
>>>
>>> Please solve my VLookup Query.
>>> Description is given in attached file.
>>> Thanks.
>>>
>>> --
>>> With regards,
>>>
>>> MaNgEsH
>>>
>>> --
>>> FORUM RULES (986+ members already BANNED for violation)
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>>
>>> 2) Don't post a question in the thread of another member.
>>>
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>>
>>> 4) Acknowledge the responses you receive, good or bad.
>>>
>>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> To unsubscribe, send a blank email to
>>> excel-macros+unsubscr...@googlegroups.com
>>
>>
>>
>>
>> --
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> *Suman Kumar*
>>
>> *Mob: +91-9810333884*
>>
>> *RIM-+91-9555629292*
>>
>>  --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>>
>
>
>
> --
> With regards,
>
> MaNgEsH
>
>


-- 
With regards,

MaNgEsH

-- 
FORUM RULES (986+ members already BANNED for violation)

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

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

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

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

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

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com<>

Re: $$Excel-Macros$$ Vlookup Problem

[Mangesh Vimay]

Thank you much Suman

On Mon, Jul 16, 2012 at 4:48 PM, Suman  wrote:

> Dear Mangesh,
> Please find the attached file as I have learnt this one form Noorain sir
> in this group.
>
> On Mon, Jul 16, 2012 at 4:33 PM, Mangesh Vimay wrote:
>
>> Hi Friends,
>>
>> Please solve my VLookup Query.
>> Description is given in attached file.
>> Thanks.
>>
>> --
>> With regards,
>>
>> MaNgEsH
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>
>
>
>
> --
>
>
>
>
>
>
>
>
>
> *Suman Kumar*
>
> *Mob: +91-9810333884*
>
> *RIM-+91-9555629292*
>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>



-- 
With regards,

MaNgEsH

-- 
FORUM RULES (986+ members already BANNED for violation)

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

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

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

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

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

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com<>

$$Excel-Macros$$ Vlookup Problem

[Mangesh Vimay]

Hi Friends,

Please solve my VLookup Query.
Description is given in attached file.
Thanks.

-- 
With regards,

MaNgEsH

-- 
FORUM RULES (986+ members already BANNED for violation)

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

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

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

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

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

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

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

Re: $$Excel-Macros$$ VLookup Problem

[NOORAIN ANSARI]

=OFFSET($D$1,MATCH(K2,TIME(HOUR($B$2:$B$10),MINUTE($B$2:$B$10),SECOND($B$2:$B$10)),0),0)
With ctrl+shift+enter

On Tue, Jan 31, 2012 at 11:24 AM, NOORAIN ANSARI
wrote:

> Dear Pravesh,
>
> Please use..this one..see attached sheet..
>
>
> =INDEX($D$2:$D$10,MATCH(K2,TIME(HOUR($B$2:$B$10),MINUTE($B$2:$B$10),SECOND($B$2:$B$10)),0))
>
> with ctrl+shift+Enter
>
> --
> Thanks & regards,
> Noorain Ansari
>  *http://excelmacroworld.blogspot.com/*
> *http://noorain-ansari.blogspot.com/*
>  On Tue, Jan 31, 2012 at 9:39 AM, PRAVESH KUMAR 
> wrote:
>
>> Hi Group,
>>
>> I am unable to extract AHT Column data through Vlookup.
>> Please sove my query..
>>
>> Thanks in Advance
>>
>> With Regards,
>> Pravesh
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>
>
>
>


-- 
Thanks & regards,
Noorain Ansari
 *http://excelmacroworld.blogspot.com/*
*http://noorain-ansari.blogspot.com/* 

-- 
FORUM RULES (986+ members already BANNED for violation)

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

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

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

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

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

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ VLookup Problem

[NOORAIN ANSARI]

Dear Pravesh,

Please use..this one..see attached sheet..

=INDEX($D$2:$D$10,MATCH(K2,TIME(HOUR($B$2:$B$10),MINUTE($B$2:$B$10),SECOND($B$2:$B$10)),0))

with ctrl+shift+Enter

-- 
Thanks & regards,
Noorain Ansari
 *http://excelmacroworld.blogspot.com/*
*http://noorain-ansari.blogspot.com/* 
On Tue, Jan 31, 2012 at 9:39 AM, PRAVESH KUMAR wrote:

> Hi Group,
>
> I am unable to extract AHT Column data through Vlookup.
> Please sove my query..
>
> Thanks in Advance
>
> With Regards,
> Pravesh
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
FORUM RULES (986+ members already BANNED for violation)

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

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

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

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

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

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com


Question(Solved).xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ VLookup Problem

[PRAVESH KUMAR]

Hi Group,

I am unable to extract AHT Column data through Vlookup.
Please sove my query..

Thanks in Advance

With Regards,
Pravesh

-- 
FORUM RULES (986+ members already BANNED for violation)

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

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

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

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

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

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com


Question.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ VLOOKUP PROBLEM

[ashish koul]

can you send the sample sheet

On Fri, Oct 15, 2010 at 3:32 AM, renuka chari  wrote:

> thanks for your valuble replay
> but i dont need countif function
> i need vlookup function to maping secound duplicate values only i am
> giving small data only so we are easily find duplicate values
> but data in large no of lines then  what?
>
>
> On Oct 14, 9:06 pm, ashish koul  wrote:
> > hi
> > check the attachment see if it helps you
> >
> > you can apply customer filter  on temp column and choose greater than 1
> and
> > copy all and paste into sheet2
> >
>  > On Thu, Oct 14, 2010 at 8:06 PM, renuka chari 
> wrote:
> > > GOOD EVENIG ALL EXPERTS
> > > CAN U SLOVE MY VLOOKUP PROBLEM
> >
> > > THIS IS MY DATA IN SHEET1
> > > =
> > > VNo  CR Amt
> > > =
> > > CR-MSP-619+ 70
> > > CR-MSP-620  600
> > > CR-MSP-621  400
> > > CR-MSP-622  180
> > > CR-MSP-623  140
> > > CR-MSP-624+ 60
> > > CR-MSP-625  150
> > > CR-MSP-626  350
> > > CR-MSP-627+ 70
> > > CR-MSP-628  360
> > > CR-MSP-629  1000
> > > CR-MSP-630  80
> > > CR-MSP-631+ 60
> > > CR-MSP-632  450
> > > CR-MSP-619+ 40
> > > CR-MSP-624+ 50
> > > CR-MSP-627+ 10
> > > CR-MSP-631+ 80
> >
> > > PLUS VALUS ARE DUPLICATE VOCHERS AND DIFFERENT "CR AMT" VALUES
> > > MY QUERY IS USING VLOOKUP FUNCTION MAPING THESE VNO INTO SECOUND
> > > DUPLICATE VALUES ONLY IN OTHER SHEET
> > > =
> > > VNO CR AMT
> > > 
> > > CR-MSP-619+ 40
> > > CR-MSP-624+ 50
> > > CR-MSP-627+ 10
> > > CR-MSP-631+ 80
> >
> > > THANKS IN ADVANCE
> >
> > > --
> >
> > >
> ---­---
> > > Some important links for excel users:
> > > 1. Follow us on TWITTER for tips tricks and links :
> > >http://twitter.com/exceldailytip
> > > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310
> > > 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> > > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
> >
> > > To post to this group, send email to excel-macros@googlegroups.com
> >
> > > <><><><><><><><><><><><><><><><><><><><><><>
> > > Like our page on facebook , Just follow below link
> > >http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&;.
> ..
> >
> > --
> > *Regards*
> > * *
> > *Ashish Koul*
> > *akoul*.*blogspot*.com 
> > *akoul*.wordpress.com 
> > My Linkedin Profile 
> >
> > P Before printing, think about the environment.
> >
> >  abc.xlsx
> > 12KViewDownload
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>



-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com 
*akoul*.wordpress.com 
My Linkedin Profile 


P Before printing, think about the environment.

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

Re: $$Excel-Macros$$ VLOOKUP PROBLEM

[renuka chari]

thanks for your valuble replay
but i dont need countif function
i need vlookup function to maping secound duplicate values only i am
giving small data only so we are easily find duplicate values
but data in large no of lines then  what?


On Oct 14, 9:06 pm, ashish koul  wrote:
> hi
> check the attachment see if it helps you
>
> you can apply customer filter  on temp column and choose greater than 1 and
> copy all and paste into sheet2
>
> On Thu, Oct 14, 2010 at 8:06 PM, renuka chari  wrote:
> > GOOD EVENIG ALL EXPERTS
> > CAN U SLOVE MY VLOOKUP PROBLEM
>
> > THIS IS MY DATA IN SHEET1
> > =
> > VNo              CR Amt
> > =
> > CR-MSP-619+     70
> > CR-MSP-620      600
> > CR-MSP-621      400
> > CR-MSP-622      180
> > CR-MSP-623      140
> > CR-MSP-624+     60
> > CR-MSP-625      150
> > CR-MSP-626      350
> > CR-MSP-627+     70
> > CR-MSP-628      360
> > CR-MSP-629      1000
> > CR-MSP-630      80
> > CR-MSP-631+     60
> > CR-MSP-632      450
> > CR-MSP-619+     40
> > CR-MSP-624+     50
> > CR-MSP-627+     10
> > CR-MSP-631+     80
>
> > PLUS VALUS ARE DUPLICATE VOCHERS AND DIFFERENT "CR AMT" VALUES
> > MY QUERY IS USING VLOOKUP FUNCTION MAPING THESE VNO INTO SECOUND
> > DUPLICATE VALUES ONLY IN OTHER SHEET
> > =
> > VNO                     CR AMT
> > 
> > CR-MSP-619+     40
> > CR-MSP-624+     50
> > CR-MSP-627+     10
> > CR-MSP-631+     80
>
> > THANKS IN ADVANCE
>
> > --
>
> > ---­---
> > Some important links for excel users:
> > 1. Follow us on TWITTER for tips tricks and links :
> >http://twitter.com/exceldailytip
> > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310
> > 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>
> > To post to this group, send email to excel-macros@googlegroups.com
>
> > <><><><><><><><><><><><><><><><><><><><><><>
> > Like our page on facebook , Just follow below link
> >http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&;...
>
> --
> *Regards*
> * *
> *Ashish Koul*
> *akoul*.*blogspot*.com 
> *akoul*.wordpress.com 
> My Linkedin Profile 
>
> P Before printing, think about the environment.
>
>  abc.xlsx
> 12KViewDownload

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

Re: $$Excel-Macros$$ VLOOKUP PROBLEM

[SUMIT VYAS]

Dear

Use sumif formulas

SUMIF(Sheet1!$A$2:$A$19,Sheet2!A2,Sheet1!$B$2:$B$19)
  CR-MSP-619+ 110  CR-MSP-620 600  CR-MSP-621 400  CR-MSP-622 180
CR-MSP-623 140  CR-MSP-624+ 110  CR-MSP-625 150  CR-MSP-626 350  CR-MSP-627+
80  CR-MSP-628 360  CR-MSP-629 1000  CR-MSP-630 80  CR-MSP-631+ 140
CR-MSP-632 450

On Thu, Oct 14, 2010 at 9:36 PM, ashish koul  wrote:

> hi
> check the attachment see if it helps you
>
> you can apply customer filter  on temp column and choose greater than 1 and
> copy all and paste into sheet2
>
>
> On Thu, Oct 14, 2010 at 8:06 PM, renuka chari  wrote:
>
>> GOOD EVENIG ALL EXPERTS
>> CAN U SLOVE MY VLOOKUP PROBLEM
>>
>> THIS IS MY DATA IN SHEET1
>> =
>> VNo  CR Amt
>> =
>> CR-MSP-619+ 70
>> CR-MSP-620  600
>> CR-MSP-621  400
>> CR-MSP-622  180
>> CR-MSP-623  140
>> CR-MSP-624+ 60
>> CR-MSP-625  150
>> CR-MSP-626  350
>> CR-MSP-627+ 70
>> CR-MSP-628  360
>> CR-MSP-629  1000
>> CR-MSP-630  80
>> CR-MSP-631+ 60
>> CR-MSP-632  450
>> CR-MSP-619+ 40
>> CR-MSP-624+ 50
>> CR-MSP-627+ 10
>> CR-MSP-631+ 80
>>
>> PLUS VALUS ARE DUPLICATE VOCHERS AND DIFFERENT "CR AMT" VALUES
>> MY QUERY IS USING VLOOKUP FUNCTION MAPING THESE VNO INTO SECOUND
>> DUPLICATE VALUES ONLY IN OTHER SHEET
>> =
>> VNO CR AMT
>> 
>> CR-MSP-619+ 40
>> CR-MSP-624+ 50
>> CR-MSP-627+ 10
>> CR-MSP-631+ 80
>>
>>
>>
>>
>> THANKS IN ADVANCE
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>>
>> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>>
>
>
>
> --
> *Regards*
> * *
> *Ashish Koul*
> *akoul*.*blogspot*.com 
> *akoul*.wordpress.com 
> My Linkedin Profile 
>
>
> P Before printing, think about the environment.
>
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

Re: $$Excel-Macros$$ VLOOKUP PROBLEM

[ashish koul]

hi
check the attachment see if it helps you

you can apply customer filter  on temp column and choose greater than 1 and
copy all and paste into sheet2

On Thu, Oct 14, 2010 at 8:06 PM, renuka chari  wrote:

> GOOD EVENIG ALL EXPERTS
> CAN U SLOVE MY VLOOKUP PROBLEM
>
> THIS IS MY DATA IN SHEET1
> =
> VNo  CR Amt
> =
> CR-MSP-619+ 70
> CR-MSP-620  600
> CR-MSP-621  400
> CR-MSP-622  180
> CR-MSP-623  140
> CR-MSP-624+ 60
> CR-MSP-625  150
> CR-MSP-626  350
> CR-MSP-627+ 70
> CR-MSP-628  360
> CR-MSP-629  1000
> CR-MSP-630  80
> CR-MSP-631+ 60
> CR-MSP-632  450
> CR-MSP-619+ 40
> CR-MSP-624+ 50
> CR-MSP-627+ 10
> CR-MSP-631+ 80
>
> PLUS VALUS ARE DUPLICATE VOCHERS AND DIFFERENT "CR AMT" VALUES
> MY QUERY IS USING VLOOKUP FUNCTION MAPING THESE VNO INTO SECOUND
> DUPLICATE VALUES ONLY IN OTHER SHEET
> =
> VNO CR AMT
> 
> CR-MSP-619+ 40
> CR-MSP-624+ 50
> CR-MSP-627+ 10
> CR-MSP-631+ 80
>
>
>
>
> THANKS IN ADVANCE
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>



-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com 
*akoul*.wordpress.com 
My Linkedin Profile 


P Before printing, think about the environment.

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts


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

$$Excel-Macros$$ VLOOKUP PROBLEM

[renuka chari]

GOOD EVENIG ALL EXPERTS
CAN U SLOVE MY VLOOKUP PROBLEM

THIS IS MY DATA IN SHEET1
=
VNo  CR Amt
=
CR-MSP-619+ 70
CR-MSP-620  600
CR-MSP-621  400
CR-MSP-622  180
CR-MSP-623  140
CR-MSP-624+ 60
CR-MSP-625  150
CR-MSP-626  350
CR-MSP-627+ 70
CR-MSP-628  360
CR-MSP-629  1000
CR-MSP-630  80
CR-MSP-631+ 60
CR-MSP-632  450
CR-MSP-619+ 40
CR-MSP-624+ 50
CR-MSP-627+ 10
CR-MSP-631+ 80

PLUS VALUS ARE DUPLICATE VOCHERS AND DIFFERENT "CR AMT" VALUES
MY QUERY IS USING VLOOKUP FUNCTION MAPING THESE VNO INTO SECOUND
DUPLICATE VALUES ONLY IN OTHER SHEET
=
VNO CR AMT

CR-MSP-619+ 40
CR-MSP-624+ 50
CR-MSP-627+ 10
CR-MSP-631+ 80




THANKS IN ADVANCE

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts