$$Excel-Macros$$ Vlookup

[Jack]

Hi I need to create a link to other workbooks on c: called week 25
week 26 etc  based on a number in a cell ie ='c:week' & "A4"  - A4
being the week number to add to file path. Can this be done ?

--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---

$$Excel-Macros$$ vLOOKUP

[Manoj Kukrej]

hI
Can we look for fist column in **1**))>>  vlookup(e3,r4:y4,1,0)

Regards

manoj


From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On 
Behalf Of Dilip Pandey
Sent: Thursday, July 16, 2009 12:47 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: Creating empty rows b/w filed rows without ASAP

Hi Maehsh,

Your requirement is attached herewith.

Thanks,
DILipandey (Back from Holidays)
--
DILIP KUMAR PANDEY
  MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062



On Thu, Jul
16, 2009 at 8:53 AM, Mahesh 
mailto:mahender.bi...@gmail.com>> wrote:
Hi Dilip,

thanx for your prompt reply but it not working.

Can you send my the xls sheet.

Rgds,
Mahesh

On Wed, Jul 15, 2009 at 7:30 PM, Dilip Pandey 
mailto:dilipan...@gmail.com>> wrote:
Hi Mahesh,

Open the code and repeat the following line twice (i.e. one more time) as it is 
already there in the code:-

Selection.EntireRow.insert


Thanks
DILipandey (Back from Holidays)

--
DILIP KUMAR PANDEY
  MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062

On Wed, Jul 15, 2009 at 5:49 AM, Mahesh 
mailto:mahender.bi...@gmail.com>> wrote:
Thanx,

What chage should i do to insert two rows at ones.

Thanx again

On Wed, Jul 15, 2009 at 4:27 PM, Dilip Pandey 
mailto:dilipan...@gmail.com>> wrote:
Hi Mahesh,

Please find the attached file with Macro.  Thanks

Dilipandey (Back from Holidays)
--
DILIP KUMAR PANDEY
  MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062

On Wed, Jul 15, 2009 at 9:04 AM, Mahesh 
mailto:mahender.bi...@gmail.com>> wrote:
Hi folks,

Gud Morning

I want insert empty row between the rows containing data with the hepl of macro.

Please also suggested how to use it in Excel 2007.

Thanks in advance...

--
With Love,
Mahesh Bisht







--
With Love,
Mahesh Bisht








--
With Love,
Mahesh Bisht




--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 5,000 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Vlookup

[Ashwin Gopinath]

Thanks for the Reply,

But for the range it is not working. Please help me to fix it.



Regards,

Ashwin

--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 5,200 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Vlookup

[muralidhar e]

Dear all group members,

I want to get the L T no, by using vlookup formula, by repeated batches.
file was attached plz suggest me how to do this by using lookup formula for
repeated.Iam using MS-Office 2007.

Warm Regards,

Muralidhar E.

-- 
--
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


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

$$Excel-Macros$$ Vlookup

[Aamir Shahzad]

Dear Experts,

I want to pick the multi values like vlookup formula. Is there any way?
Sheet attached. Can we prepare the any function e.g. (mylookup) which save
in excel & when ever I use that function it picks the desired values like
attached sheet.

Regards,

Aamir Shahzad

-- 
--
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/discussexcel


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

$$Excel-Macros$$ VLOOKUP Query

[Shrinivas Shevde]

Dear All
I am using vlookup and facing following problem
File attached
thanks in advance

-- 
Shrini

-- 
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/d/optout.


New Microsoft Excel Worksheet (6).xlsx
Description: MS-Excel 2007 spreadsheet

$$Excel-Macros$$ vlookup formula

[Izhar]

can anyone teach me the formula in the attach file
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 https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


vlookup question.xlsx
Description: MS-Excel 2007 spreadsheet

$$Excel-Macros$$ Vlookup Help

[rishi]

Hi  All,

 

I have a couple of problems :

1.

I wanted to know if there is some short cut for using vlookup multiple times
.

For eg,

I have a table with Name , Phone no ,address..etc in a workbook.

I have a few names from the master list in the second sheet .

Now I want to use vlookup to pull all the details from the first sheet i.e
phone no , address , etc .

I don't want to write individual vlookup for each column .

Wanted to know if there is any short cut .

 

2.

 

With similar sheet ,

If the names in the second sheet have some minor spelling mistakes,is it
possible to still pull out data from the first sheet .

For eg.

Shree Ram in the first sheet could be Sri Ram in the second 

OR

Ram Ltd could be Ram Ltd. In the second sheet .

 

Using vlookup in such a case is not working.so is there any other way
someone can suggest ?

 

Thanks in advance .

 

Rishi


--~--~-~--~~~---~--~~
Visit the blog to download Excel tutorials at 
http://www.excel-macros.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/excel-macros?hl=en

Visit & Join Our Orkut Community at 
http://www.orkut.com/Community.aspx?cmm=22913620

Visit the blog to download Excel tutorials at 
http://www.excel-macros.blogspot.com

To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com

To see the Daily Excel Tips, Go to:
http://exceldailytip.blogspot.com
-~--~~~~--~~--~--~---

$$Excel-Macros$$ VLookup formula

[suresh k]

Hi

I have one query.
I have data in two different sheets. Below are example for you.


*Data in sheet 1:*
Name   Data  Date  No.
Su   12  1/1/99   123
gu 22 2/2/99   124
gg 33 3/3/00125


*Data in shee 2:*
Name   Data  Date  No.
Su   12  1/1/99   123
ff 22 2/2/99   124
gg 33 3/3/00125


Now I need formula where i need to compare only first 2 columns (Name &
Data) and i need to findout how many line items are same.
Please let me know if any one can help me on this.

--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 5,000 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---

$$Excel-Macros$$ vlookup help

[osiso]

i would like to add an example of what im trying to do. please let me
know how to add a file.

--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 5,200 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Vlookup Value

[Ashwin Gopinath]

--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 5,200 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---



Vlookup.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Vlookup-Dates

[Sachin Gohil]

Dear All,
I did a vlookup of dates, but Im getting #N/A. The reason is every date in 
excel is tored as serial no. Tried using Date/Date value but it doesnt work..

  
_
New Windows 7: Find the right PC for you. Learn more.
http://windows.microsoft.com/shop-- 
--
Some important links for excel users:
1. Follow us in TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
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
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

$$Excel-Macros$$ VLOOKUP function

[Alan]

   I am using Excel 2007 and having a strange problem with the VLOOKUP
function.  I have never used it before, but I have looked at examples
on the Internet.  However, I cannot figure it out.

  I placed the following formula in Cell B2:

=VLOOKUP($A2,$D$2:$E$9,$E:$E,FALSE)

and then copied it to B3 and B4, which respectively show up as:

=VLOOKUP($A3,$D$2:$E$9,$E:$E,FALSE)
=VLOOKUP($A4,$D$2:$E$9,$E:$E,FALSE)

My lookup table is located at D2:E9, with what I am looking up in
column D, and the value for the lookup in column E.

I placed the second entry in the table in cells A2, A3, and A4.
The VLOOKUP functions in cells B2, B3, and B4 show the following
results:

B2: #VALUE!
B3: , same as in A3
B4: the correct lookup value.

   This does not make any sense to me, based on the examples I have
seen.

What am I doing wrong?  Thanks, Alan


-- 
--
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

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

Re: $$Excel-Macros$$ Vlookup

[Rajasekhar Praharaju]

Hello Muralidhar,

Instead of Vlookup you can use Pivot table it depicts good results.

Please find Attached is the solved sheet..

Let me know if you are looking for the same or anything else.

Thanks,
Raj

On Thu, Nov 11, 2010 at 11:02 AM, muralidhar e wrote:

> Dear all group members,
>
> I want to get the L T no, by using vlookup formula, by repeated batches.
> file was attached plz suggest me how to do this by using lookup formula for
> repeated.Iam using MS-Office 2007.
>
> Warm Regards,
>
> Muralidhar E.
>
> --
>
> --
> 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


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

Fwd: $$Excel-Macros$$ Vlookup

[muralidhar e]

Dear all,

This is urgent to me, plz suggest solution as early as possible.

Warm Regards,

Muralidhar E.

-- Forwarded message --
From: muralidhar e 
Date: Thu, Nov 11, 2010 at 11:02 AM
Subject: $$Excel-Macros$$ Vlookup
To: excel-macros@googlegroups.com


 Dear all group members,

I want to get the L T no, by using vlookup formula, by repeated batches.
file was attached plz suggest me how to do this by using lookup formula for
repeated.Iam using MS-Office 2007.

Warm Regards,

Muralidhar E.

-- 
--
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


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

Re: $$Excel-Macros$$ Vlookup

[Rajasekhar Praharaju]

Hi Muralidhar,

did u check the attached pivot solution
let me know if it is not apt then i will do v-lookup fucntion as u sent.

Thanks,
Raj

On Thu, Nov 11, 2010 at 12:49 PM, muralidhar e wrote:

> Dear all,
>
> This is urgent to me, plz suggest solution as early as possible.
>
> Warm Regards,
>
> Muralidhar E.
>
> -- Forwarded message --
> From: muralidhar e 
> Date: Thu, Nov 11, 2010 at 11:02 AM
> Subject: $$Excel-Macros$$ Vlookup
> To: excel-macros@googlegroups.com
>
>
>  Dear all group members,
>
> I want to get the L T no, by using vlookup formula, by repeated batches.
> file was attached plz suggest me how to do this by using lookup formula for
> repeated.Iam using MS-Office 2007.
>
> Warm Regards,
>
> Muralidhar E.
>
> --
>
> --
> 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
>

-- 
--
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

[muralidhar e]

hai,
sorry like this, it is not useful for me(for my internal office work). for
my work i want like this only, Is their any possibility like this plz find
the solution, and one more thing is that the batches are like this are
nearly 2,so their is no possiblity to use the pivot table, i check like
this also.

Plz give the solution what i have asked format. it will usefull me.

Thanks and Regards,
Muralidhar E.

On Thu, Nov 11, 2010 at 12:47 PM, Rajasekhar Praharaju <
rajasekhar.prahar...@gmail.com> wrote:

> Hello Muralidhar,
>
> Instead of Vlookup you can use Pivot table it depicts good results.
>
> Please find Attached is the solved sheet..
>
> Let me know if you are looking for the same or anything else.
>
> Thanks,
> Raj
>
> On Thu, Nov 11, 2010 at 11:02 AM, muralidhar e wrote:
>
>>  Dear all group members,
>>
>> I want to get the L T no, by using vlookup formula, by repeated batches.
>> file was attached plz suggest me how to do this by using lookup formula for
>> repeated.Iam using MS-Office 2007.
>>
>> Warm Regards,
>>
>> Muralidhar E.
>>
>> --
>>
>> --
>> 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
>

-- 
--
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

$$Excel-Macros$$ vlookup query

[PRADEEP KUMAR KOKNE]

I have a some query regarding the vlookup can somebody help

-- 
--
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/discussexcel

$$Excel-Macros$$ Vlookup Query

[PRADEEP KUMAR KOKNE]

Base file: this file has 3 columns which has


CustomerLE  Cost Center
AUG0001 SDFV445858
USA0001 JHNE652147
ZMA0001 NMVE321745

Actual file: I have same 3 columns, I want a macro which has to
CONCATENATE all the 3 columns and do a vlookup to check the
combination, if the combination is invalid it has to show an error
message

CustomerLE  Cost Center Errrs
AUG0001 SDFV527850  error message; combination is invalid
USA0001 JHNE652147
ZMA0001 NMVE321745

-- 
--
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/discussexcel

$$Excel-Macros$$ vlookup query

[ankur]

*
*Have A Nice Time & Enjoy Life

Regards:
CMA Ankur Pandey
(Someone Different)

I'm not the best but i'm not like the rest~~


-- Forwarded message --
From: ankur 
Date: Mon, Jul 11, 2011 at 4:38 PM
Subject: Re: $$Excel-Macros$$ vlookup query
To: PRADEEP KUMAR KOKNE 


*hi pradeep

plz find the attached file.hope this is what u needed...
see "macro file" for solution.
i m not so good in vba , but just tried to solve it...let me know if it
helps u
*
*
*Have A Nice Time & Enjoy Life

Regards:
CMA Ankur Pandey
(Someone Different)

I'm not the best but i'm not like the rest~~


On Mon, Jul 11, 2011 at 2:22 PM, PRADEEP KUMAR KOKNE <
pradeepkumar...@gmail.com> wrote:

>
> Hi
>
> Can some one write a macro as per the attach files.
>
> i need a loop fo
>
> On Mon, Jul 11, 2011 at 11:37 AM, ankur  wrote:
>
>> *where is query?
>> *Have A Nice Time & Enjoy Life
>>
>> Regards:
>> CMA Ankur Pandey
>> (Someone Different)
>>
>> I'm not the best but i'm not like the rest~~
>>
>>
>> On Sat, Jul 9, 2011 at 11:37 AM, Venkatesh Srinivas <
>> venkateshs@gmail.com> wrote:
>>
>>> please shoot your query
>>>
>>>
>>> On Sat, Jul 9, 2011 at 9:43 AM, PRADEEP KUMAR KOKNE <
>>> pradeepkumar...@gmail.com> wrote:
>>>
>>>> I have a some query regarding the vlookup can somebody help
>>>>
>>>> --
>>>>
>>>> --
>>>> 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/discussexcel
>>>>
>>>
>>>
>>>
>>> --
>>>
>>> Regards
>>> Venkatesh KS
>>> Phone: +91 98419 69353
>>>
>>>  --
>>>
>>> --
>>> 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/discussexcel
>>>
>>
>>  --
>>
>> --
>> 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/discussexcel
>>
>
>

-- 
--
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/discussexcel


Solution By Ankur.rar
Description: application/rar

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

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

$$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 Required

[amar takale]

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

FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

6) Jobs posting is not allowed.

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

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




REPORT.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Vlookup Book

[Amit Desai (MERU)]

Dear Noorain,

Few days back you were referring a book to be written on vlookup.

If you have completed, could you please share the same with the Group?

Best Regards,
Amit



Disclaimer: This message and its attachments contain confidential information 
and may also contain legally privileged information. This message is intended 
solely for the named addressee. If you are not the addressee indicated in this 
message (or authorized to receive for addressee), you may not copy or deliver 
any part of this message or its attachments to anyone or use any part of this 
message or its attachments. Rather, you should permanently delete this message 
and its attachments (and all copies) from your system and kindly notify the 
sender by reply e-mail. Any content of this message and its attachments that 
does not relate to the official business of Meru Cab Company Pvt. Ltd. must be 
taken not to have been sent or endorsed by any of them. Email communications 
are not private and no warranty is made that e-mail communications are timely, 
secure or free from computer virus or other defect.

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

FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

6) Jobs posting is not allowed.

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

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

$$Excel-Macros$$ VLOOKUP QUEARY

[Saleem Ansari]

Dear All,

Please Solve my Query On Urgent Basic. ASAP

Please Find The Attachment.


Thanks & Regards?
   ​​
*​*
*Saleem Ansari*

*Logicash Solutions Pvt. Ltd.*
*A-79| Sector-4| Noida| Gautam Budh Nagar (U.P) 201301*

*Email Id :-* *saleem.logic...@gmail.com *

*Mobile : - +91 7840096219*



The information in this email is confidential and may be legally
privileged. It is intended solely for the addressee. Access to this email
by anyone else is unauthorized. If you are not the intended recipient, any
disclosure, copying, distribution or any action taken or committed to be
taken in reliance on it, is prohibited and may be unlawful.

Please consider the environment before printing this e-mail

*पेड़ बचाएँ*  *पर्यावरण बचाएँ*

[image: Description: cid:image003.gif@01CCD1FE.E699F6D0]*"Go Green, Save
Earth"**?*
​
*[image: Untitled]*

-- 
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/d/optout.


VLOOKUP QUEARY.xlsx
Description: MS-Excel 2007 spreadsheet

$$Excel-Macros$$ Vlookup query

[Shrinivas Shevde]

Dear All

I have a text in Column A4 ,I am extracting a number from that text in
colum B4,using outcome of I want to use Vlookup but its not successful.
Same Out put I entered by hand in the column then I get desire result.
To entered manually its take lot of time I have more than 1000 data.
Please find attached file,

-- 
Shrini

-- 
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/d/optout.


Query.xlsx
Description: MS-Excel 2007 spreadsheet

Re: $$Excel-Macros$$ Vlookup

[Sam Mathai Chacko]

Function MultiResultLookedUp(varLookupValue, rngRange As Range) As String

Dim lngLoop As Long
Dim varArray
varArray = rngRange

For lngLoop = LBound(varArray, 1) To UBound(varArray, 1)
If varArray(lngLoop, 1) = varLookupValue Then
MultiResultLookedUp = MultiResultLookedUp & varArray(lngLoop, 2)
& "/"
End If
Next lngLoop
MultiResultLookedUp = Left(MultiResultLookedUp, Len(MultiResultLookedUp)
- 1)

End Function


Regards,

Sam Mathai Chacko (GL)

On Mon, Oct 24, 2011 at 10:46 PM, Aamir Shahzad wrote:

> Dear Experts,
>
> I want to pick the multi values like vlookup formula. Is there any way?
> Sheet attached. Can we prepare the any function e.g. (mylookup) which save
> in excel & when ever I use that function it picks the desired values like
> attached sheet.
>
> Regards,
>
> Aamir Shahzad
>
> --
>
> --
> 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/discussexcel
>



-- 
Sam Mathai Chacko

-- 
--
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/discussexcel


Vlookup.xlsm
Description: Binary data

Re: $$Excel-Macros$$ Vlookup

[dguillett1]

A pure macro solution without formulas or UDF

Sub GetMultipleDataSAS()
Application.ScreenUpdating = False
Columns("e").Clear
On Error Resume Next
For i = 3 To Cells(Rows.Count, "b").End(xlUp).Row
sLr = Cells(Rows.Count, "i").End(xlUp).Row
With Columns("I")
Set c = .Find(What:=Cells(i, "b"), After:=Range("I2"), LookIn:=xlValues, 
LookAt _
:=xlWhole, SearchOrder:=xlByRows, SearchDirection:=xlNext)
 If Not c Is Nothing Then
firstAddress = c.Address
Do
ms = ms & "/" & Cells(c.Row, "J")
Set c = .FindNext(c)
Loop While Not c Is Nothing And c.Address <> firstAddress
End If
End With
Cells(i, "e") = Right(ms, Len(ms) - 1)
ms = ""
Next i
Columns("e").AutoFit
Application.ScreenUpdating = True
End Sub

Don Guillett
SalesAid Software
dguille...@gmail.com

From: Sam Mathai Chacko 
Sent: Monday, October 24, 2011 12:27 PM
To: excel-macros@googlegroups.com 
Subject: Re: $$Excel-Macros$$ Vlookup

Function MultiResultLookedUp(varLookupValue, rngRange As Range) As String

Dim lngLoop As Long
Dim varArray
varArray = rngRange

For lngLoop = LBound(varArray, 1) To UBound(varArray, 1)
If varArray(lngLoop, 1) = varLookupValue Then
MultiResultLookedUp = MultiResultLookedUp & varArray(lngLoop, 2) & 
"/"
End If
Next lngLoop
MultiResultLookedUp = Left(MultiResultLookedUp, Len(MultiResultLookedUp) - 
1)

End Function


Regards,

Sam Mathai Chacko (GL)


On Mon, Oct 24, 2011 at 10:46 PM, Aamir Shahzad  
wrote:

  Dear Experts,


  I want to pick the multi values like vlookup formula. Is there any way? Sheet 
attached. Can we prepare the any function e.g. (mylookup) which save in excel & 
when ever I use that function it picks the desired values like attached sheet. 

  Regards,

  Aamir Shahzad
  -- 
  
--
  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/discussexcel




-- 
Sam Mathai Chacko
-- 
--
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/discussexcel

-- 
--
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/discussexcel

Re: $$Excel-Macros$$ Vlookup

[Aamir Shahzad]

thank you very much SAM for this wonderful solution. But I want to make this
to permanent function you can say by means of add in, I want to make add in
to use this "MultiResultLookedup" Macro because any time if I want to use
this function I have to convert the file format xlsx to xlsm. Please
suggest.

Regards,

Aamir Shahzad

On Mon, Oct 24, 2011 at 10:27 PM, Sam Mathai Chacko wrote:

> Function MultiResultLookedUp(varLookupValue, rngRange As Range) As String
>
> Dim lngLoop As Long
> Dim varArray
> varArray = rngRange
>
> For lngLoop = LBound(varArray, 1) To UBound(varArray, 1)
> If varArray(lngLoop, 1) = varLookupValue Then
> MultiResultLookedUp = MultiResultLookedUp & varArray(lngLoop,
> 2) & "/"
> End If
> Next lngLoop
> MultiResultLookedUp = Left(MultiResultLookedUp,
> Len(MultiResultLookedUp) - 1)
>
> End Function
>
>
> Regards,
>
> Sam Mathai Chacko (GL)
>
>
> On Mon, Oct 24, 2011 at 10:46 PM, Aamir Shahzad 
> wrote:
>
>> Dear Experts,
>>
>> I want to pick the multi values like vlookup formula. Is there any way?
>> Sheet attached. Can we prepare the any function e.g. (mylookup) which save
>> in excel & when ever I use that function it picks the desired values like
>> attached sheet.
>>
>> Regards,
>>
>> Aamir Shahzad
>> --
>>
>> --
>> 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/discussexcel
>>
>
>
>
> --
> Sam Mathai Chacko
>
> --
>
> --
> 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/discussexcel
>

-- 
--
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/discussexcel

Re: $$Excel-Macros$$ Vlookup

[Sam Mathai Chacko]

Aamir, copy the entire code to your personal.xlsb file. You will now have it
available in all your workbooks, similar to an add-in.

If you do not have the personal file, just do any macro recording by
selecting the personal workbook. Stop recording, and the overwrite the macro
that was recorded.

Regards,

Sam Mathai Chacko (GL)

On Tue, Oct 25, 2011 at 1:32 AM, Aamir Shahzad wrote:

> thank you very much SAM for this wonderful solution. But I want to make
> this to permanent function you can say by means of add in, I want to make
> add in to use this "MultiResultLookedup" Macro because any time if I want to
> use this function I have to convert the file format xlsx to xlsm. Please
> suggest.
>
> Regards,
>
> Aamir Shahzad
>
> On Mon, Oct 24, 2011 at 10:27 PM, Sam Mathai Chacko wrote:
>
>> Function MultiResultLookedUp(varLookupValue, rngRange As Range) As String
>>
>> Dim lngLoop As Long
>> Dim varArray
>> varArray = rngRange
>>
>> For lngLoop = LBound(varArray, 1) To UBound(varArray, 1)
>> If varArray(lngLoop, 1) = varLookupValue Then
>> MultiResultLookedUp = MultiResultLookedUp & varArray(lngLoop,
>> 2) & "/"
>> End If
>> Next lngLoop
>> MultiResultLookedUp = Left(MultiResultLookedUp,
>> Len(MultiResultLookedUp) - 1)
>>
>> End Function
>>
>>
>> Regards,
>>
>> Sam Mathai Chacko (GL)
>>
>>
>> On Mon, Oct 24, 2011 at 10:46 PM, Aamir Shahzad > > wrote:
>>
>>> Dear Experts,
>>>
>>> I want to pick the multi values like vlookup formula. Is there any way?
>>> Sheet attached. Can we prepare the any function e.g. (mylookup) which save
>>> in excel & when ever I use that function it picks the desired values like
>>> attached sheet.
>>>
>>> Regards,
>>>
>>> Aamir Shahzad
>>> --
>>>
>>> --
>>> 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/discussexcel
>>>
>>
>>
>>
>> --
>> Sam Mathai Chacko
>>
>> --
>>
>> --
>> 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/discussexcel
>>
>
>  --
>
> --
> 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/discussexcel
>



-- 
Sam Mathai Chacko

-- 
--
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/discussexcel

Re: $$Excel-Macros$$ Vlookup

[Aamir Shahzad]

SAM please further brief step by step procedure which are you saying as I am
very new in macro.

Aamir Shahzad

On Tue, Oct 25, 2011 at 1:05 AM, Sam Mathai Chacko wrote:

> Aamir, copy the entire code to your personal.xlsb file. You will now have
> it available in all your workbooks, similar to an add-in.
>
> If you do not have the personal file, just do any macro recording by
> selecting the personal workbook. Stop recording, and the overwrite the macro
> that was recorded.
>
>
> Regards,
>
> Sam Mathai Chacko (GL)
>
> On Tue, Oct 25, 2011 at 1:32 AM, Aamir Shahzad 
> wrote:
>
>> thank you very much SAM for this wonderful solution. But I want to make
>> this to permanent function you can say by means of add in, I want to make
>> add in to use this "MultiResultLookedup" Macro because any time if I want to
>> use this function I have to convert the file format xlsx to xlsm. Please
>> suggest.
>>
>> Regards,
>>
>> Aamir Shahzad
>>
>> On Mon, Oct 24, 2011 at 10:27 PM, Sam Mathai Chacko 
>> wrote:
>>
>>> Function MultiResultLookedUp(varLookupValue, rngRange As Range) As String
>>>
>>> Dim lngLoop As Long
>>> Dim varArray
>>> varArray = rngRange
>>>
>>> For lngLoop = LBound(varArray, 1) To UBound(varArray, 1)
>>> If varArray(lngLoop, 1) = varLookupValue Then
>>> MultiResultLookedUp = MultiResultLookedUp & varArray(lngLoop,
>>> 2) & "/"
>>> End If
>>> Next lngLoop
>>> MultiResultLookedUp = Left(MultiResultLookedUp,
>>> Len(MultiResultLookedUp) - 1)
>>>
>>> End Function
>>>
>>>
>>> Regards,
>>>
>>> Sam Mathai Chacko (GL)
>>>
>>>
>>> On Mon, Oct 24, 2011 at 10:46 PM, Aamir Shahzad <
>>> aamirshahza...@gmail.com> wrote:
>>>
 Dear Experts,

 I want to pick the multi values like vlookup formula. Is there any way?
 Sheet attached. Can we prepare the any function e.g. (mylookup) which save
 in excel & when ever I use that function it picks the desired values like
 attached sheet.

 Regards,

 Aamir Shahzad
 --

 --
 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/discussexcel

>>>
>>>
>>>
>>> --
>>> Sam Mathai Chacko
>>>
>>> --
>>>
>>> --
>>> 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/discussexcel
>>>
>>
>> --
>>
>> --
>> 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/discussexcel
>>
>
>
>
> --
> Sam Mathai Chacko
> --
>
> --
> 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/discussexcel
>

-- 
--

Re: $$Excel-Macros$$ Vlookup

[Sam Mathai Chacko]

OK. Click on record macro from the developer tab. Short cut key ALT+T+M+R

Then in the option to select store macro in, select personal workbook. Then
click OK. Then do anything on the spreadsheet, like select a cell, or delete
a row or something. The stop the macro recording. You can use the same short
cut key as above.

Then click ALT+F11. This will take you to the VBE window. There in the
project explorer window you will see the personal macro workbook. In that
you will find a module. In the module, just paste my code, and then use it
like you would normally use any formula..

Regards,

Sam

On Tue, Oct 25, 2011 at 1:50 AM, Aamir Shahzad wrote:

> SAM please further brief step by step procedure which are you saying as I
> am very new in macro.
>
> Aamir Shahzad
>
> On Tue, Oct 25, 2011 at 1:05 AM, Sam Mathai Chacko wrote:
>
>> Aamir, copy the entire code to your personal.xlsb file. You will now have
>> it available in all your workbooks, similar to an add-in.
>>
>> If you do not have the personal file, just do any macro recording by
>> selecting the personal workbook. Stop recording, and the overwrite the macro
>> that was recorded.
>>
>>
>> Regards,
>>
>> Sam Mathai Chacko (GL)
>>
>> On Tue, Oct 25, 2011 at 1:32 AM, Aamir Shahzad 
>> wrote:
>>
>>> thank you very much SAM for this wonderful solution. But I want to make
>>> this to permanent function you can say by means of add in, I want to make
>>> add in to use this "MultiResultLookedup" Macro because any time if I want to
>>> use this function I have to convert the file format xlsx to xlsm. Please
>>> suggest.
>>>
>>> Regards,
>>>
>>> Aamir Shahzad
>>>
>>> On Mon, Oct 24, 2011 at 10:27 PM, Sam Mathai Chacko 
>>> wrote:
>>>
 Function MultiResultLookedUp(varLookupValue, rngRange As Range) As
 String

 Dim lngLoop As Long
 Dim varArray
 varArray = rngRange

 For lngLoop = LBound(varArray, 1) To UBound(varArray, 1)
 If varArray(lngLoop, 1) = varLookupValue Then
 MultiResultLookedUp = MultiResultLookedUp &
 varArray(lngLoop, 2) & "/"
 End If
 Next lngLoop
 MultiResultLookedUp = Left(MultiResultLookedUp,
 Len(MultiResultLookedUp) - 1)

 End Function


 Regards,

 Sam Mathai Chacko (GL)


 On Mon, Oct 24, 2011 at 10:46 PM, Aamir Shahzad <
 aamirshahza...@gmail.com> wrote:

> Dear Experts,
>
> I want to pick the multi values like vlookup formula. Is there any way?
> Sheet attached. Can we prepare the any function e.g. (mylookup) which save
> in excel & when ever I use that function it picks the desired values like
> attached sheet.
>
> Regards,
>
> Aamir Shahzad
> --
>
> --
> 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/discussexcel
>



 --
 Sam Mathai Chacko

 --

 --
 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/discussexcel

>>>
>>> --
>>>
>>> --
>>> 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 lin

Re: $$Excel-Macros$$ Vlookup

[Aamir Shahzad]

SAM - I am doing your instruction like this:
1) In the blank new work book opening marco by shortkey.
2) selecting personal workbook. Click ok
3) then going to VBE window. In the Personal Macro workbook & in the module
after pasting your code then save then close.
4) after that in excel typing the required multiresultlookedup formula still
not showing
what I am doing wrong. Please help.

Aamir Shahzad


On Tue, Oct 25, 2011 at 1:37 AM, Sam Mathai Chacko wrote:

> OK. Click on record macro from the developer tab. Short cut key ALT+T+M+R
>
> Then in the option to select store macro in, select personal workbook. Then
> click OK. Then do anything on the spreadsheet, like select a cell, or delete
> a row or something. The stop the macro recording. You can use the same short
> cut key as above.
>
> Then click ALT+F11. This will take you to the VBE window. There in the
> project explorer window you will see the personal macro workbook. In that
> you will find a module. In the module, just paste my code, and then use it
> like you would normally use any formula..
>
> Regards,
>
> Sam
>
>
> On Tue, Oct 25, 2011 at 1:50 AM, Aamir Shahzad 
> wrote:
>
>> SAM please further brief step by step procedure which are you saying as I
>> am very new in macro.
>>
>> Aamir Shahzad
>>
>> On Tue, Oct 25, 2011 at 1:05 AM, Sam Mathai Chacko wrote:
>>
>>> Aamir, copy the entire code to your personal.xlsb file. You will now have
>>> it available in all your workbooks, similar to an add-in.
>>>
>>> If you do not have the personal file, just do any macro recording by
>>> selecting the personal workbook. Stop recording, and the overwrite the macro
>>> that was recorded.
>>>
>>>
>>> Regards,
>>>
>>> Sam Mathai Chacko (GL)
>>>
>>> On Tue, Oct 25, 2011 at 1:32 AM, Aamir Shahzad >> > wrote:
>>>
 thank you very much SAM for this wonderful solution. But I want to make
 this to permanent function you can say by means of add in, I want to make
 add in to use this "MultiResultLookedup" Macro because any time if I want 
 to
 use this function I have to convert the file format xlsx to xlsm. Please
 suggest.

 Regards,

 Aamir Shahzad

 On Mon, Oct 24, 2011 at 10:27 PM, Sam Mathai Chacko >>> > wrote:

> Function MultiResultLookedUp(varLookupValue, rngRange As Range) As
> String
>
> Dim lngLoop As Long
> Dim varArray
> varArray = rngRange
>
> For lngLoop = LBound(varArray, 1) To UBound(varArray, 1)
> If varArray(lngLoop, 1) = varLookupValue Then
> MultiResultLookedUp = MultiResultLookedUp &
> varArray(lngLoop, 2) & "/"
> End If
> Next lngLoop
> MultiResultLookedUp = Left(MultiResultLookedUp,
> Len(MultiResultLookedUp) - 1)
>
> End Function
>
>
> Regards,
>
> Sam Mathai Chacko (GL)
>
>
> On Mon, Oct 24, 2011 at 10:46 PM, Aamir Shahzad <
> aamirshahza...@gmail.com> wrote:
>
>> Dear Experts,
>>
>> I want to pick the multi values like vlookup formula. Is there any
>> way? Sheet attached. Can we prepare the any function e.g. (mylookup) 
>> which
>> save in excel & when ever I use that function it picks the desired values
>> like attached sheet.
>>
>> Regards,
>>
>> Aamir Shahzad
>> --
>>
>> --
>> 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/discussexcel
>>
>
>
>
> --
> Sam Mathai Chacko
>
> --
>
> --
> 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/discussexcel
>

 --

 --

Re: $$Excel-Macros$$ Vlookup

[Sam Mathai Chacko]

Aamir, you have to past the code in the code module, not the workbook/sheet
module

Sam

On Thu, Oct 27, 2011 at 1:12 AM, Aamir Shahzad wrote:

> SAM - I am doing your instruction like this:
> 1) In the blank new work book opening marco by shortkey.
> 2) selecting personal workbook. Click ok
> 3) then going to VBE window. In the Personal Macro workbook & in the module
> after pasting your code then save then close.
> 4) after that in excel typing the required multiresultlookedup formula
> still not showing
> what I am doing wrong. Please help.
>
> Aamir Shahzad
>
>
> On Tue, Oct 25, 2011 at 1:37 AM, Sam Mathai Chacko wrote:
>
>> OK. Click on record macro from the developer tab. Short cut key ALT+T+M+R
>>
>> Then in the option to select store macro in, select personal workbook.
>> Then click OK. Then do anything on the spreadsheet, like select a cell, or
>> delete a row or something. The stop the macro recording. You can use the
>> same short cut key as above.
>>
>> Then click ALT+F11. This will take you to the VBE window. There in the
>> project explorer window you will see the personal macro workbook. In that
>> you will find a module. In the module, just paste my code, and then use it
>> like you would normally use any formula..
>>
>> Regards,
>>
>> Sam
>>
>>
>> On Tue, Oct 25, 2011 at 1:50 AM, Aamir Shahzad 
>> wrote:
>>
>>> SAM please further brief step by step procedure which are you saying as I
>>> am very new in macro.
>>>
>>> Aamir Shahzad
>>>
>>> On Tue, Oct 25, 2011 at 1:05 AM, Sam Mathai Chacko 
>>> wrote:
>>>
 Aamir, copy the entire code to your personal.xlsb file. You will now
 have it available in all your workbooks, similar to an add-in.

 If you do not have the personal file, just do any macro recording by
 selecting the personal workbook. Stop recording, and the overwrite the 
 macro
 that was recorded.


 Regards,

 Sam Mathai Chacko (GL)

 On Tue, Oct 25, 2011 at 1:32 AM, Aamir Shahzad <
 aamirshahza...@gmail.com> wrote:

> thank you very much SAM for this wonderful solution. But I want to make
> this to permanent function you can say by means of add in, I want to make
> add in to use this "MultiResultLookedup" Macro because any time if I want 
> to
> use this function I have to convert the file format xlsx to xlsm. Please
> suggest.
>
> Regards,
>
> Aamir Shahzad
>
> On Mon, Oct 24, 2011 at 10:27 PM, Sam Mathai Chacko <
> samde...@gmail.com> wrote:
>
>> Function MultiResultLookedUp(varLookupValue, rngRange As Range) As
>> String
>>
>> Dim lngLoop As Long
>> Dim varArray
>> varArray = rngRange
>>
>> For lngLoop = LBound(varArray, 1) To UBound(varArray, 1)
>> If varArray(lngLoop, 1) = varLookupValue Then
>> MultiResultLookedUp = MultiResultLookedUp &
>> varArray(lngLoop, 2) & "/"
>> End If
>> Next lngLoop
>> MultiResultLookedUp = Left(MultiResultLookedUp,
>> Len(MultiResultLookedUp) - 1)
>>
>> End Function
>>
>>
>> Regards,
>>
>> Sam Mathai Chacko (GL)
>>
>>
>> On Mon, Oct 24, 2011 at 10:46 PM, Aamir Shahzad <
>> aamirshahza...@gmail.com> wrote:
>>
>>> Dear Experts,
>>>
>>> I want to pick the multi values like vlookup formula. Is there any
>>> way? Sheet attached. Can we prepare the any function e.g. (mylookup) 
>>> which
>>> save in excel & when ever I use that function it picks the desired 
>>> values
>>> like attached sheet.
>>>
>>> Regards,
>>>
>>> Aamir Shahzad
>>> --
>>>
>>> --
>>> 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/discussexcel
>>>
>>
>>
>>
>> --
>> Sam Mathai Chacko
>>
>> --
>>
>> --
>> 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

Re: $$Excel-Macros$$ Vlookup

[Sam Mathai Chacko]

Aamir, I was just checking, and found that I was wrong. You have to save a
file as an add-in for this to work. Create a new file, put the code in a new
module of that file, and save it as add-in (.xlam).

Sam

On Thu, Oct 27, 2011 at 1:19 AM, Aamir Shahzad wrote:

> I am pasting SAM see attached file may be doing some thing wrong. In your
> previous mail you instructed to create xlsb file why?
>
>
> On Thu, Oct 27, 2011 at 12:44 AM, Sam Mathai Chacko wrote:
>
>> Aamir, you have to past the code in the code module, not the
>> workbook/sheet module
>>
>> Sam
>>
>>
>> On Thu, Oct 27, 2011 at 1:12 AM, Aamir Shahzad 
>> wrote:
>>
>>> SAM - I am doing your instruction like this:
>>> 1) In the blank new work book opening marco by shortkey.
>>> 2) selecting personal workbook. Click ok
>>> 3) then going to VBE window. In the Personal Macro workbook & in the
>>> module after pasting your code then save then close.
>>> 4) after that in excel typing the required multiresultlookedup formula
>>> still not showing
>>> what I am doing wrong. Please help.
>>>
>>> Aamir Shahzad
>>>
>>>
>>> On Tue, Oct 25, 2011 at 1:37 AM, Sam Mathai Chacko 
>>> wrote:
>>>
 OK. Click on record macro from the developer tab. Short cut key
 ALT+T+M+R

 Then in the option to select store macro in, select personal workbook.
 Then click OK. Then do anything on the spreadsheet, like select a cell, or
 delete a row or something. The stop the macro recording. You can use the
 same short cut key as above.

 Then click ALT+F11. This will take you to the VBE window. There in the
 project explorer window you will see the personal macro workbook. In that
 you will find a module. In the module, just paste my code, and then use it
 like you would normally use any formula..

 Regards,

 Sam


 On Tue, Oct 25, 2011 at 1:50 AM, Aamir Shahzad <
 aamirshahza...@gmail.com> wrote:

> SAM please further brief step by step procedure which are you saying as
> I am very new in macro.
>
> Aamir Shahzad
>
> On Tue, Oct 25, 2011 at 1:05 AM, Sam Mathai Chacko  > wrote:
>
>> Aamir, copy the entire code to your personal.xlsb file. You will now
>> have it available in all your workbooks, similar to an add-in.
>>
>> If you do not have the personal file, just do any macro recording by
>> selecting the personal workbook. Stop recording, and the overwrite the 
>> macro
>> that was recorded.
>>
>>
>> Regards,
>>
>> Sam Mathai Chacko (GL)
>>
>> On Tue, Oct 25, 2011 at 1:32 AM, Aamir Shahzad <
>> aamirshahza...@gmail.com> wrote:
>>
>>> thank you very much SAM for this wonderful solution. But I want to
>>> make this to permanent function you can say by means of add in, I want 
>>> to
>>> make add in to use this "MultiResultLookedup" Macro because any time if 
>>> I
>>> want to use this function I have to convert the file format xlsx to 
>>> xlsm.
>>> Please suggest.
>>>
>>> Regards,
>>>
>>> Aamir Shahzad
>>>
>>> On Mon, Oct 24, 2011 at 10:27 PM, Sam Mathai Chacko <
>>> samde...@gmail.com> wrote:
>>>
 Function MultiResultLookedUp(varLookupValue, rngRange As Range) As
 String

 Dim lngLoop As Long
 Dim varArray
 varArray = rngRange

 For lngLoop = LBound(varArray, 1) To UBound(varArray, 1)
 If varArray(lngLoop, 1) = varLookupValue Then
 MultiResultLookedUp = MultiResultLookedUp &
 varArray(lngLoop, 2) & "/"
 End If
 Next lngLoop
 MultiResultLookedUp = Left(MultiResultLookedUp,
 Len(MultiResultLookedUp) - 1)

 End Function


 Regards,

 Sam Mathai Chacko (GL)


 On Mon, Oct 24, 2011 at 10:46 PM, Aamir Shahzad <
 aamirshahza...@gmail.com> wrote:

> Dear Experts,
>
> I want to pick the multi values like vlookup formula. Is there any
> way? Sheet attached. Can we prepare the any function e.g. (mylookup) 
> which
> save in excel & when ever I use that function it picks the desired 
> values
> like attached sheet.
>
> Regards,
>
> Aamir Shahzad
> --
>
> --
> 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.blogs

Re: $$Excel-Macros$$ Vlookup

[Aamir Shahzad]

created as xlsb now tell me how to use, I mean how to use now

Aamir Shahzad

On Thu, Oct 27, 2011 at 1:08 AM, Sam Mathai Chacko wrote:

> Aamir, I was just checking, and found that I was wrong. You have to save a
> file as an add-in for this to work. Create a new file, put the code in a new
> module of that file, and save it as add-in (.xlam).
>
> Sam
>
>
> On Thu, Oct 27, 2011 at 1:19 AM, Aamir Shahzad 
> wrote:
>
>> I am pasting SAM see attached file may be doing some thing wrong. In your
>> previous mail you instructed to create xlsb file why?
>>
>>
>> On Thu, Oct 27, 2011 at 12:44 AM, Sam Mathai Chacko 
>> wrote:
>>
>>> Aamir, you have to past the code in the code module, not the
>>> workbook/sheet module
>>>
>>> Sam
>>>
>>>
>>> On Thu, Oct 27, 2011 at 1:12 AM, Aamir Shahzad >> > wrote:
>>>
 SAM - I am doing your instruction like this:
 1) In the blank new work book opening marco by shortkey.
 2) selecting personal workbook. Click ok
 3) then going to VBE window. In the Personal Macro workbook & in the
 module after pasting your code then save then close.
 4) after that in excel typing the required multiresultlookedup formula
 still not showing
 what I am doing wrong. Please help.

 Aamir Shahzad


 On Tue, Oct 25, 2011 at 1:37 AM, Sam Mathai Chacko 
 wrote:

> OK. Click on record macro from the developer tab. Short cut key
> ALT+T+M+R
>
> Then in the option to select store macro in, select personal workbook.
> Then click OK. Then do anything on the spreadsheet, like select a cell, or
> delete a row or something. The stop the macro recording. You can use the
> same short cut key as above.
>
> Then click ALT+F11. This will take you to the VBE window. There in the
> project explorer window you will see the personal macro workbook. In that
> you will find a module. In the module, just paste my code, and then use it
> like you would normally use any formula..
>
> Regards,
>
> Sam
>
>
> On Tue, Oct 25, 2011 at 1:50 AM, Aamir Shahzad <
> aamirshahza...@gmail.com> wrote:
>
>> SAM please further brief step by step procedure which are you saying
>> as I am very new in macro.
>>
>> Aamir Shahzad
>>
>> On Tue, Oct 25, 2011 at 1:05 AM, Sam Mathai Chacko <
>> samde...@gmail.com> wrote:
>>
>>> Aamir, copy the entire code to your personal.xlsb file. You will now
>>> have it available in all your workbooks, similar to an add-in.
>>>
>>> If you do not have the personal file, just do any macro recording by
>>> selecting the personal workbook. Stop recording, and the overwrite the 
>>> macro
>>> that was recorded.
>>>
>>>
>>> Regards,
>>>
>>> Sam Mathai Chacko (GL)
>>>
>>> On Tue, Oct 25, 2011 at 1:32 AM, Aamir Shahzad <
>>> aamirshahza...@gmail.com> wrote:
>>>
 thank you very much SAM for this wonderful solution. But I want to
 make this to permanent function you can say by means of add in, I want 
 to
 make add in to use this "MultiResultLookedup" Macro because any time 
 if I
 want to use this function I have to convert the file format xlsx to 
 xlsm.
 Please suggest.

 Regards,

 Aamir Shahzad

 On Mon, Oct 24, 2011 at 10:27 PM, Sam Mathai Chacko <
 samde...@gmail.com> wrote:

> Function MultiResultLookedUp(varLookupValue, rngRange As Range) As
> String
>
> Dim lngLoop As Long
> Dim varArray
> varArray = rngRange
>
> For lngLoop = LBound(varArray, 1) To UBound(varArray, 1)
> If varArray(lngLoop, 1) = varLookupValue Then
> MultiResultLookedUp = MultiResultLookedUp &
> varArray(lngLoop, 2) & "/"
> End If
> Next lngLoop
> MultiResultLookedUp = Left(MultiResultLookedUp,
> Len(MultiResultLookedUp) - 1)
>
> End Function
>
>
> Regards,
>
> Sam Mathai Chacko (GL)
>
>
> On Mon, Oct 24, 2011 at 10:46 PM, Aamir Shahzad <
> aamirshahza...@gmail.com> wrote:
>
>> Dear Experts,
>>
>> I want to pick the multi values like vlookup formula. Is there any
>> way? Sheet attached. Can we prepare the any function e.g. (mylookup) 
>> which
>> save in excel & when ever I use that function it picks the desired 
>> values
>> like attached sheet.
>>
>> Regards,
>>
>> Aamir Shahzad
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://t

Re: $$Excel-Macros$$ Vlookup

[Sam Mathai Chacko]

No, do not create an xlsb. Create an xlam. The add it to the add-in list.

Sam

On Thu, Oct 27, 2011 at 1:51 AM, Aamir Shahzad wrote:

> created as xlsb now tell me how to use, I mean how to use now
>
> Aamir Shahzad
>
> On Thu, Oct 27, 2011 at 1:08 AM, Sam Mathai Chacko wrote:
>
>> Aamir, I was just checking, and found that I was wrong. You have to save a
>> file as an add-in for this to work. Create a new file, put the code in a new
>> module of that file, and save it as add-in (.xlam).
>>
>> Sam
>>
>>
>> On Thu, Oct 27, 2011 at 1:19 AM, Aamir Shahzad 
>> wrote:
>>
>>> I am pasting SAM see attached file may be doing some thing wrong. In your
>>> previous mail you instructed to create xlsb file why?
>>>
>>>
>>> On Thu, Oct 27, 2011 at 12:44 AM, Sam Mathai Chacko 
>>> wrote:
>>>
 Aamir, you have to past the code in the code module, not the
 workbook/sheet module

 Sam


 On Thu, Oct 27, 2011 at 1:12 AM, Aamir Shahzad <
 aamirshahza...@gmail.com> wrote:

> SAM - I am doing your instruction like this:
> 1) In the blank new work book opening marco by shortkey.
> 2) selecting personal workbook. Click ok
> 3) then going to VBE window. In the Personal Macro workbook & in the
> module after pasting your code then save then close.
> 4) after that in excel typing the required multiresultlookedup formula
> still not showing
> what I am doing wrong. Please help.
>
> Aamir Shahzad
>
>
> On Tue, Oct 25, 2011 at 1:37 AM, Sam Mathai Chacko  > wrote:
>
>> OK. Click on record macro from the developer tab. Short cut key
>> ALT+T+M+R
>>
>> Then in the option to select store macro in, select personal workbook.
>> Then click OK. Then do anything on the spreadsheet, like select a cell, 
>> or
>> delete a row or something. The stop the macro recording. You can use the
>> same short cut key as above.
>>
>> Then click ALT+F11. This will take you to the VBE window. There in the
>> project explorer window you will see the personal macro workbook. In that
>> you will find a module. In the module, just paste my code, and then use 
>> it
>> like you would normally use any formula..
>>
>> Regards,
>>
>> Sam
>>
>>
>> On Tue, Oct 25, 2011 at 1:50 AM, Aamir Shahzad <
>> aamirshahza...@gmail.com> wrote:
>>
>>> SAM please further brief step by step procedure which are you saying
>>> as I am very new in macro.
>>>
>>> Aamir Shahzad
>>>
>>> On Tue, Oct 25, 2011 at 1:05 AM, Sam Mathai Chacko <
>>> samde...@gmail.com> wrote:
>>>
 Aamir, copy the entire code to your personal.xlsb file. You will now
 have it available in all your workbooks, similar to an add-in.

 If you do not have the personal file, just do any macro recording by
 selecting the personal workbook. Stop recording, and the overwrite the 
 macro
 that was recorded.


 Regards,

 Sam Mathai Chacko (GL)

 On Tue, Oct 25, 2011 at 1:32 AM, Aamir Shahzad <
 aamirshahza...@gmail.com> wrote:

> thank you very much SAM for this wonderful solution. But I want to
> make this to permanent function you can say by means of add in, I 
> want to
> make add in to use this "MultiResultLookedup" Macro because any time 
> if I
> want to use this function I have to convert the file format xlsx to 
> xlsm.
> Please suggest.
>
> Regards,
>
> Aamir Shahzad
>
> On Mon, Oct 24, 2011 at 10:27 PM, Sam Mathai Chacko <
> samde...@gmail.com> wrote:
>
>> Function MultiResultLookedUp(varLookupValue, rngRange As Range) As
>> String
>>
>> Dim lngLoop As Long
>> Dim varArray
>> varArray = rngRange
>>
>> For lngLoop = LBound(varArray, 1) To UBound(varArray, 1)
>> If varArray(lngLoop, 1) = varLookupValue Then
>> MultiResultLookedUp = MultiResultLookedUp &
>> varArray(lngLoop, 2) & "/"
>> End If
>> Next lngLoop
>> MultiResultLookedUp = Left(MultiResultLookedUp,
>> Len(MultiResultLookedUp) - 1)
>>
>> End Function
>>
>>
>> Regards,
>>
>> Sam Mathai Chacko (GL)
>>
>>
>> On Mon, Oct 24, 2011 at 10:46 PM, Aamir Shahzad <
>> aamirshahza...@gmail.com> wrote:
>>
>>> Dear Experts,
>>>
>>> I want to pick the multi values like vlookup formula. Is there
>>> any way? Sheet attached. Can we prepare the any function e.g. 
>>> (mylookup)
>>> which save in excel & when ever I use that function it picks the 
>>> desired
>>> values like attached 

Re: $$Excel-Macros$$ Vlookup

[Aamir Shahzad]

*Done SAM*, wonderful thanks for your cooperation. I think I must have to
save this add in file in save location for permanent use of this function is
it? second this add in don't show in ribbon no problem but I saw that my
friend create the add in and it shows in the ribbon with his multi commands
can I use this in the ribbon with button.

And can I create further macros solutions in the same add in with multi
buttons?

Thanks again for your cooperate.

Regards,

Aamir Shahzad

On Thu, Oct 27, 2011 at 1:38 AM, Sam Mathai Chacko wrote:

> No, do not create an xlsb. Create an xlam. The add it to the add-in list.
>
> Sam
>
>
> On Thu, Oct 27, 2011 at 1:51 AM, Aamir Shahzad 
> wrote:
>
>> created as xlsb now tell me how to use, I mean how to use now
>>
>> Aamir Shahzad
>>
>> On Thu, Oct 27, 2011 at 1:08 AM, Sam Mathai Chacko wrote:
>>
>>> Aamir, I was just checking, and found that I was wrong. You have to save
>>> a file as an add-in for this to work. Create a new file, put the code in a
>>> new module of that file, and save it as add-in (.xlam).
>>>
>>> Sam
>>>
>>>
>>> On Thu, Oct 27, 2011 at 1:19 AM, Aamir Shahzad >> > wrote:
>>>
 I am pasting SAM see attached file may be doing some thing wrong. In
 your previous mail you instructed to create xlsb file why?


 On Thu, Oct 27, 2011 at 12:44 AM, Sam Mathai Chacko >>> > wrote:

> Aamir, you have to past the code in the code module, not the
> workbook/sheet module
>
> Sam
>
>
> On Thu, Oct 27, 2011 at 1:12 AM, Aamir Shahzad <
> aamirshahza...@gmail.com> wrote:
>
>> SAM - I am doing your instruction like this:
>> 1) In the blank new work book opening marco by shortkey.
>> 2) selecting personal workbook. Click ok
>> 3) then going to VBE window. In the Personal Macro workbook & in the
>> module after pasting your code then save then close.
>> 4) after that in excel typing the required multiresultlookedup formula
>> still not showing
>> what I am doing wrong. Please help.
>>
>> Aamir Shahzad
>>
>>
>> On Tue, Oct 25, 2011 at 1:37 AM, Sam Mathai Chacko <
>> samde...@gmail.com> wrote:
>>
>>> OK. Click on record macro from the developer tab. Short cut key
>>> ALT+T+M+R
>>>
>>> Then in the option to select store macro in, select personal
>>> workbook. Then click OK. Then do anything on the spreadsheet, like 
>>> select a
>>> cell, or delete a row or something. The stop the macro recording. You 
>>> can
>>> use the same short cut key as above.
>>>
>>> Then click ALT+F11. This will take you to the VBE window. There in
>>> the project explorer window you will see the personal macro workbook. In
>>> that you will find a module. In the module, just paste my code, and 
>>> then use
>>> it like you would normally use any formula..
>>>
>>> Regards,
>>>
>>> Sam
>>>
>>>
>>> On Tue, Oct 25, 2011 at 1:50 AM, Aamir Shahzad <
>>> aamirshahza...@gmail.com> wrote:
>>>
 SAM please further brief step by step procedure which are you saying
 as I am very new in macro.

 Aamir Shahzad

 On Tue, Oct 25, 2011 at 1:05 AM, Sam Mathai Chacko <
 samde...@gmail.com> wrote:

> Aamir, copy the entire code to your personal.xlsb file. You will
> now have it available in all your workbooks, similar to an add-in.
>
> If you do not have the personal file, just do any macro recording
> by selecting the personal workbook. Stop recording, and the overwrite 
> the
> macro that was recorded.
>
>
> Regards,
>
> Sam Mathai Chacko (GL)
>
> On Tue, Oct 25, 2011 at 1:32 AM, Aamir Shahzad <
> aamirshahza...@gmail.com> wrote:
>
>> thank you very much SAM for this wonderful solution. But I want to
>> make this to permanent function you can say by means of add in, I 
>> want to
>> make add in to use this "MultiResultLookedup" Macro because any time 
>> if I
>> want to use this function I have to convert the file format xlsx to 
>> xlsm.
>> Please suggest.
>>
>> Regards,
>>
>> Aamir Shahzad
>>
>> On Mon, Oct 24, 2011 at 10:27 PM, Sam Mathai Chacko <
>> samde...@gmail.com> wrote:
>>
>>> Function MultiResultLookedUp(varLookupValue, rngRange As Range)
>>> As String
>>>
>>> Dim lngLoop As Long
>>> Dim varArray
>>> varArray = rngRange
>>>
>>> For lngLoop = LBound(varArray, 1) To UBound(varArray, 1)
>>> If varArray(lngLoop, 1) = varLookupValue Then
>>> MultiResultLookedUp = MultiResultLookedUp &
>>> varArray(lngLoop, 2) & "/"
>>> End If
>>> Next lngL

Re: $$Excel-Macros$$ Vlookup

[Karan]

Dear SAM,

I have created the addin from the above trailing mails. Can u please
guide me where am i going wrong or how to use it once the addin is
created?

Please help

On Oct 27, 1:59 am, Aamir Shahzad  wrote:
> *Done SAM*, wonderful thanks for your cooperation. I think I must have to
> save this add in file in save location for permanent use of this function is
> it? second this add in don't show in ribbon no problem but I saw that my
> friend create the add in and it shows in the ribbon with his multi commands
> can I use this in the ribbon with button.
>
> And can I create further macros solutions in the same add in with multi
> buttons?
>
> Thanks again for your cooperate.
>
> Regards,
>
> Aamir Shahzad
>
> On Thu, Oct 27, 2011 at 1:38 AM, Sam Mathai Chacko wrote:
>
>
>
>
>
>
>
> > No, do not create an xlsb. Create an xlam. The add it to the add-in list.
>
> > Sam
>
> > On Thu, Oct 27, 2011 at 1:51 AM, Aamir Shahzad 
> > wrote:
>
> >> created as xlsb now tell me how to use, I mean how to use now
>
> >> Aamir Shahzad
>
> >> On Thu, Oct 27, 2011 at 1:08 AM, Sam Mathai Chacko 
> >> wrote:
>
> >>> Aamir, I was just checking, and found that I was wrong. You have to save
> >>> a file as an add-in for this to work. Create a new file, put the code in a
> >>> new module of that file, and save it as add-in (.xlam).
>
> >>> Sam
>
> >>> On Thu, Oct 27, 2011 at 1:19 AM, Aamir Shahzad  >>> > wrote:
>
>  I am pasting SAM see attached file may be doing some thing wrong. In
>  your previous mail you instructed to create xlsb file why?
>
>  On Thu, Oct 27, 2011 at 12:44 AM, Sam Mathai Chacko   > wrote:
>
> > Aamir, you have to past the code in the code module, not the
> > workbook/sheet module
>
> > Sam
>
> > On Thu, Oct 27, 2011 at 1:12 AM, Aamir Shahzad <
> > aamirshahza...@gmail.com> wrote:
>
> >> SAM - I am doing your instruction like this:
> >> 1) In the blank new work book opening marco by shortkey.
> >> 2) selecting personal workbook. Click ok
> >> 3) then going to VBE window. In the Personal Macro workbook & in the
> >> module after pasting your code then save then close.
> >> 4) after that in excel typing the required multiresultlookedup formula
> >> still not showing
> >> what I am doing wrong. Please help.
>
> >> Aamir Shahzad
>
> >> On Tue, Oct 25, 2011 at 1:37 AM, Sam Mathai Chacko <
> >> samde...@gmail.com> wrote:
>
> >>> OK. Click on record macro from the developer tab. Short cut key
> >>> ALT+T+M+R
>
> >>> Then in the option to select store macro in, select personal
> >>> workbook. Then click OK. Then do anything on the spreadsheet, like 
> >>> select a
> >>> cell, or delete a row or something. The stop the macro recording. You 
> >>> can
> >>> use the same short cut key as above.
>
> >>> Then click ALT+F11. This will take you to the VBE window. There in
> >>> the project explorer window you will see the personal macro workbook. 
> >>> In
> >>> that you will find a module. In the module, just paste my code, and 
> >>> then use
> >>> it like you would normally use any formula..
>
> >>> Regards,
>
> >>> Sam
>
> >>> On Tue, Oct 25, 2011 at 1:50 AM, Aamir Shahzad <
> >>> aamirshahza...@gmail.com> wrote:
>
>  SAM please further brief step by step procedure which are you saying
>  as I am very new in macro.
>
>  Aamir Shahzad
>
>  On Tue, Oct 25, 2011 at 1:05 AM, Sam Mathai Chacko <
>  samde...@gmail.com> wrote:
>
> > Aamir, copy the entire code to your personal.xlsb file. You will
> > now have it available in all your workbooks, similar to an add-in.
>
> > If you do not have the personal file, just do any macro recording
> > by selecting the personal workbook. Stop recording, and the 
> > overwrite the
> > macro that was recorded.
>
> > Regards,
>
> > Sam Mathai Chacko (GL)
>
> > On Tue, Oct 25, 2011 at 1:32 AM, Aamir Shahzad <
> > aamirshahza...@gmail.com> wrote:
>
> >> thank you very much SAM for this wonderful solution. But I want to
> >> make this to permanent function you can say by means of add in, I 
> >> want to
> >> make add in to use this "MultiResultLookedup" Macro because any 
> >> time if I
> >> want to use this function I have to convert the file format xlsx 
> >> to xlsm.
> >> Please suggest.
>
> >> Regards,
>
> >> Aamir Shahzad
>
> >> On Mon, Oct 24, 2011 at 10:27 PM, Sam Mathai Chacko <
> >> samde...@gmail.com> wrote:
>
> >>> Function MultiResultLookedUp(varLookupValue, rngRange As Range)
> >>> As String
>
> >>>     Dim lngLoop As Long
> >>>     Dim varArray
> >>>     varArray = rngRange
>
> >>>     For lngLoop = LBound(varArray, 1) To UBound(varArray, 1)
> >>>         If va

Re: $$Excel-Macros$$ Vlookup

[Sam Mathai Chacko]

Karan, sure I will try to help, but what is the problem to start with? You
haven't mentioned what issue you are facing.

Sam

On Fri, Dec 2, 2011 at 12:26 PM, Karan  wrote:

> Dear SAM,
>
> I have created the addin from the above trailing mails. Can u please
> guide me where am i going wrong or how to use it once the addin is
> created?
>
> Please help
>
> On Oct 27, 1:59 am, Aamir Shahzad  wrote:
> > *Done SAM*, wonderful thanks for your cooperation. I think I must have to
> > save this add in file in save location for permanent use of this
> function is
> > it? second this add in don't show in ribbon no problem but I saw that my
> > friend create the add in and it shows in the ribbon with his multi
> commands
> > can I use this in the ribbon with button.
> >
> > And can I create further macros solutions in the same add in with multi
> > buttons?
> >
> > Thanks again for your cooperate.
> >
> > Regards,
> >
> > Aamir Shahzad
> >
> > On Thu, Oct 27, 2011 at 1:38 AM, Sam Mathai Chacko  >wrote:
> >
> >
> >
> >
> >
> >
> >
> > > No, do not create an xlsb. Create an xlam. The add it to the add-in
> list.
> >
> > > Sam
> >
> > > On Thu, Oct 27, 2011 at 1:51 AM, Aamir Shahzad <
> aamirshahza...@gmail.com>wrote:
> >
> > >> created as xlsb now tell me how to use, I mean how to use now
> >
> > >> Aamir Shahzad
> >
> > >> On Thu, Oct 27, 2011 at 1:08 AM, Sam Mathai Chacko <
> samde...@gmail.com>wrote:
> >
> > >>> Aamir, I was just checking, and found that I was wrong. You have to
> save
> > >>> a file as an add-in for this to work. Create a new file, put the
> code in a
> > >>> new module of that file, and save it as add-in (.xlam).
> >
> > >>> Sam
> >
> > >>> On Thu, Oct 27, 2011 at 1:19 AM, Aamir Shahzad <
> aamirshahza...@gmail.com
> > >>> > wrote:
> >
> >  I am pasting SAM see attached file may be doing some thing wrong. In
> >  your previous mail you instructed to create xlsb file why?
> >
> >  On Thu, Oct 27, 2011 at 12:44 AM, Sam Mathai Chacko <
> samde...@gmail.com
> >  > wrote:
> >
> > > Aamir, you have to past the code in the code module, not the
> > > workbook/sheet module
> >
> > > Sam
> >
> > > On Thu, Oct 27, 2011 at 1:12 AM, Aamir Shahzad <
> > > aamirshahza...@gmail.com> wrote:
> >
> > >> SAM - I am doing your instruction like this:
> > >> 1) In the blank new work book opening marco by shortkey.
> > >> 2) selecting personal workbook. Click ok
> > >> 3) then going to VBE window. In the Personal Macro workbook & in
> the
> > >> module after pasting your code then save then close.
> > >> 4) after that in excel typing the required multiresultlookedup
> formula
> > >> still not showing
> > >> what I am doing wrong. Please help.
> >
> > >> Aamir Shahzad
> >
> > >> On Tue, Oct 25, 2011 at 1:37 AM, Sam Mathai Chacko <
> > >> samde...@gmail.com> wrote:
> >
> > >>> OK. Click on record macro from the developer tab. Short cut key
> > >>> ALT+T+M+R
> >
> > >>> Then in the option to select store macro in, select personal
> > >>> workbook. Then click OK. Then do anything on the spreadsheet,
> like select a
> > >>> cell, or delete a row or something. The stop the macro
> recording. You can
> > >>> use the same short cut key as above.
> >
> > >>> Then click ALT+F11. This will take you to the VBE window. There
> in
> > >>> the project explorer window you will see the personal macro
> workbook. In
> > >>> that you will find a module. In the module, just paste my code,
> and then use
> > >>> it like you would normally use any formula..
> >
> > >>> Regards,
> >
> > >>> Sam
> >
> > >>> On Tue, Oct 25, 2011 at 1:50 AM, Aamir Shahzad <
> > >>> aamirshahza...@gmail.com> wrote:
> >
> >  SAM please further brief step by step procedure which are you
> saying
> >  as I am very new in macro.
> >
> >  Aamir Shahzad
> >
> >  On Tue, Oct 25, 2011 at 1:05 AM, Sam Mathai Chacko <
> >  samde...@gmail.com> wrote:
> >
> > > Aamir, copy the entire code to your personal.xlsb file. You
> will
> > > now have it available in all your workbooks, similar to an
> add-in.
> >
> > > If you do not have the personal file, just do any macro
> recording
> > > by selecting the personal workbook. Stop recording, and the
> overwrite the
> > > macro that was recorded.
> >
> > > Regards,
> >
> > > Sam Mathai Chacko (GL)
> >
> > > On Tue, Oct 25, 2011 at 1:32 AM, Aamir Shahzad <
> > > aamirshahza...@gmail.com> wrote:
> >
> > >> thank you very much SAM for this wonderful solution. But I
> want to
> > >> make this to permanent function you can say by means of add
> in, I want to
> > >> make add in to use this "MultiResultLookedup" Macro because
> any time if I
> > >> want to use this function I have to convert the file format
> xlsx to xlsm.
> > >> Please suggest.
> >
> > 

Re: $$Excel-Macros$$ Vlookup

[Karan]

I have done as said still the function is not working. So i want to
know where am i going wrong?

I have send u the screen shots on ur email as i dont know how to
attach files on these grp

Thanks,

Karan

On Dec 2, 8:15 pm, Sam Mathai Chacko  wrote:
> Karan, sure I will try to help, but what is the problem to start with? You
> haven't mentioned what issue you are facing.
>
> Sam
>
>
>
>
>
>
>
> On Fri, Dec 2, 2011 at 12:26 PM, Karan  wrote:
> > Dear SAM,
>
> > I have created the addin from the above trailing mails. Can u please
> > guide me where am i going wrong or how to use it once the addin is
> > created?
>
> > Please help
>
> > On Oct 27, 1:59 am, Aamir Shahzad  wrote:
> > > *Done SAM*, wonderful thanks for your cooperation. I think I must have to
> > > save this add in file in save location for permanent use of this
> > function is
> > > it? second this add in don't show in ribbon no problem but I saw that my
> > > friend create the add in and it shows in the ribbon with his multi
> > commands
> > > can I use this in the ribbon with button.
>
> > > And can I create further macros solutions in the same add in with multi
> > > buttons?
>
> > > Thanks again for your cooperate.
>
> > > Regards,
>
> > > Aamir Shahzad
>
> > > On Thu, Oct 27, 2011 at 1:38 AM, Sam Mathai Chacko  > >wrote:
>
> > > > No, do not create an xlsb. Create an xlam. The add it to the add-in
> > list.
>
> > > > Sam
>
> > > > On Thu, Oct 27, 2011 at 1:51 AM, Aamir Shahzad <
> > aamirshahza...@gmail.com>wrote:
>
> > > >> created as xlsb now tell me how to use, I mean how to use now
>
> > > >> Aamir Shahzad
>
> > > >> On Thu, Oct 27, 2011 at 1:08 AM, Sam Mathai Chacko <
> > samde...@gmail.com>wrote:
>
> > > >>> Aamir, I was just checking, and found that I was wrong. You have to
> > save
> > > >>> a file as an add-in for this to work. Create a new file, put the
> > code in a
> > > >>> new module of that file, and save it as add-in (.xlam).
>
> > > >>> Sam
>
> > > >>> On Thu, Oct 27, 2011 at 1:19 AM, Aamir Shahzad <
> > aamirshahza...@gmail.com
> > > >>> > wrote:
>
> > >  I am pasting SAM see attached file may be doing some thing wrong. In
> > >  your previous mail you instructed to create xlsb file why?
>
> > >  On Thu, Oct 27, 2011 at 12:44 AM, Sam Mathai Chacko <
> > samde...@gmail.com
> > >  > wrote:
>
> > > > Aamir, you have to past the code in the code module, not the
> > > > workbook/sheet module
>
> > > > Sam
>
> > > > On Thu, Oct 27, 2011 at 1:12 AM, Aamir Shahzad <
> > > > aamirshahza...@gmail.com> wrote:
>
> > > >> SAM - I am doing your instruction like this:
> > > >> 1) In the blank new work book opening marco by shortkey.
> > > >> 2) selecting personal workbook. Click ok
> > > >> 3) then going to VBE window. In the Personal Macro workbook & in
> > the
> > > >> module after pasting your code then save then close.
> > > >> 4) after that in excel typing the required multiresultlookedup
> > formula
> > > >> still not showing
> > > >> what I am doing wrong. Please help.
>
> > > >> Aamir Shahzad
>
> > > >> On Tue, Oct 25, 2011 at 1:37 AM, Sam Mathai Chacko <
> > > >> samde...@gmail.com> wrote:
>
> > > >>> OK. Click on record macro from the developer tab. Short cut key
> > > >>> ALT+T+M+R
>
> > > >>> Then in the option to select store macro in, select personal
> > > >>> workbook. Then click OK. Then do anything on the spreadsheet,
> > like select a
> > > >>> cell, or delete a row or something. The stop the macro
> > recording. You can
> > > >>> use the same short cut key as above.
>
> > > >>> Then click ALT+F11. This will take you to the VBE window. There
> > in
> > > >>> the project explorer window you will see the personal macro
> > workbook. In
> > > >>> that you will find a module. In the module, just paste my code,
> > and then use
> > > >>> it like you would normally use any formula..
>
> > > >>> Regards,
>
> > > >>> Sam
>
> > > >>> On Tue, Oct 25, 2011 at 1:50 AM, Aamir Shahzad <
> > > >>> aamirshahza...@gmail.com> wrote:
>
> > >  SAM please further brief step by step procedure which are you
> > saying
> > >  as I am very new in macro.
>
> > >  Aamir Shahzad
>
> > >  On Tue, Oct 25, 2011 at 1:05 AM, Sam Mathai Chacko <
> > >  samde...@gmail.com> wrote:
>
> > > > Aamir, copy the entire code to your personal.xlsb file. You
> > will
> > > > now have it available in all your workbooks, similar to an
> > add-in.
>
> > > > If you do not have the personal file, just do any macro
> > recording
> > > > by selecting the personal workbook. Stop recording, and the
> > overwrite the
> > > > macro that was recorded.
>
> > > > Regards,
>
> > > > Sam Mathai Chacko (GL)
>
> > > > On Tue, Oct 25, 2011 at 1:32 AM, Aamir Shahzad <
> > > > aamirshahza...@gmail.com> wrote:
>
> > > >> thank you v

$$Excel-Macros$$ Vlookup Help

[Chidurala, Shrinivas]

Dear Team,

I am creating macro for Recon of prices where facing problem in multiple 
vlookup. Find attached Recon file.

Please any one help me the multiple vlookup function/coding multiple vlookup.

Thanking in Advance.

Regards,
Shrinivas

-- 
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


Recon.xls
Description: Recon.xls

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

$$Excel-Macros$$ vlookup madness

[alanthomas062]

I am really confused about the behavior of my VLOOKUP functions in Column 2 
of the attached spreadsheet.  The function is simply 
=VLOOKUP(A1,$E$1:$F$17,2).  This is giving me wrong (undefined, or wrong 
number) results for some of what I`m looking up.  I have not found the 
cause or a way around the problem.

Is Excel getting confused because I have this involves some numbers and 
some letters?


-- 
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?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.




vlookup.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ VLOOKUP doubt

[Satiqjaffar ali]

Hello experts,

I have some doubt in VLOOKUP, that how can i get lookup value from previous
cell?. please find the attached sheet and advice.. thanks a lot.

Thanks
Satiq

-- 
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 doubt.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ VLOOKUP Query

[Shrinivas Shevde]

Dear All
In vlookup we are giving the column no from which value should be picked up
.
I want to get the summation of 3 column is it possible?
For Eg
I want to get the summation of column 9,10,12
Can anyone tell me how to do it
Thanks in advance


-- 
Shrini

-- 
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 query

[Shrinivas Shevde]

Dear All
Please find attached query.
Is it possible to write  aformula as per my requirement

-- 
Shrini

-- 
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.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

$$Excel-Macros$$ vlookup help.

[Prabhu Pinky]

Hi Experts,

How to do vlookup in VBA. i have two sheets saved in different locations.

i need to do vlookup in sheet1 by referring another sheet saved in
different location.

please help.



Thanks & Regards,
Prabhu R

-- 
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.

Re: $$Excel-Macros$$ VLOOKUP Query

[Shrinivas Shevde]

Dear Mandeep
Sorry for too delay reply .Actually I was on different project and now back
to the home.
Please find attached file.
Marked in yellow is not giving results as I am using Vlookup with ABS
function ,marked in brown gives results I am using Vlookup without ABS
function.
If I used the Vlookup without ABS then I am not getting results for
other.see the first row marked in grey.

Regards
Shrinivas

On Mon, Nov 30, 2015 at 9:57 AM, Shrinivas Shevde 
wrote:

> Dear All
> I am using vlookup and facing following problem
> File attached
> thanks in advance
>
> --
> Shrini
>
> --
> 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/d/optout.
>



-- 
Shrini

-- 
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 https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


Vlookup.xlsx
Description: MS-Excel 2007 spreadsheet

$$Excel-Macros$$ Vlookup Matching Issue

[Bill Q]

Hi,

PSA.

Trying to do a simple vlookup. I cleaned up the data by trimming, but still 
cannot get a match. 

I manually entered in data in B2 in order to get a match. 

I never encountered anything like this before.  Not certain how to fix. 

Anyone ? 

Thanks. 

-- 
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 https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


TEST.xlsx
Description: MS-Excel 2007 spreadsheet

$$Excel-Macros$$ Vlookup Sensitive Case

[सचिन शर्मा]

Dear All,

Kindly help to resolve the attached file of Sensitive Case.

find the data by Vlookup between *Capital* & *Small* letters *(Eg. A & a)* 




*Thank & Regards*
*Sachin*

-- 
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 https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


Vlookup Sensitive Case.xlsx
Description: MS-Excel 2007 spreadsheet

$$Excel-Macros$$ VLOOKUP HELP NEED

[Venkatesh Narla]

Hi All,
I need help in Vlookup need formula.

"Hi All,
Column A has data; Column ""F"" is the range need E to pull"



10001   #N/AA   10001
10002   B   10002
10003   C   10003
10004   D   10004
10005   E   10005
10006   F   10006
10007   G   10007
10008   H   10008
10009   I   10009
10010   J   10010
10011   K   10011
10012   L   10012
10013   M   10013
10014   N   10014
10015   O   10015
10016   P   10016
10017   Q   10017
10018   R   10018
10019   S   10019
10020   T   10020

-- 
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


VLOOKUP HELP NEED.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

$$Excel-Macros$$ vlookup urgent help

[ankur]

Dear Members

i have one problem
in one sheet there is data as
party name  bill no.   amount

there are 100s of party detail,one party may has many bill no

in another sheet
party name  bill no.   amount


i want to extract amount from shhet 2 , if party name & bill name of
sheet 1 are same

in other words, i want to compare both party name and bill no. from
sheet 1 & sheet 2
and if they match i want to get amount from sheet 2

please help me

Have A Nice Time & Enjoy Life

Regards:
CMA Ankur Pandey
(Someone Different)

I'm not the best but i'm not like the rest~~

--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---

Re: $$Excel-Macros$$ Vlookup-Dates

[Alokeshwar Tiwary]

Please share the workbook?

_
"There are known knowns. These are things we know that we know. There are known 
unknowns. That is to say, there are things that we know we don't know. But 
there are also unknown unknowns. There are things we don't know we don't know." 





From: Sachin Gohil 
To: excel-macros@googlegroups.com
Sent: Sun, 10 January, 2010 7:00:44 PM
Subject: $$Excel-Macros$$ Vlookup-Dates

Dear All, 

I did a vlookup of dates, but Im getting #N/A. The reason is every date in 
excel is tored as serial no. Tried using Date/Date value but it doesnt work..



New Windows 7: Find the right PC for you. Learn more. -- 
--
Some important links for excel users:
1. Follow us in TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
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
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe



  The INTERNET now has a personality. YOURS! See your Yahoo! Homepage. 
http://in.yahoo.com/-- 
--
Some important links for excel users:
1. Follow us in TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
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
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

RE: $$Excel-Macros$$ Vlookup-Dates

[Sachin Gohil]

Its very simple data. For every date I want Mon-Sun for that date. 
File 1: Date   Week15-Jan-09   =vlookup(A2,File2,2,0) which gives #N/A
File 2:Date  Week11-Jan-09  11-Jan to 17-Jan12-Jan-09  11-Jan to 17-Jan
13-Jan-09  11-Jan to 17-Jan14-Jan-09  11-Jan to 17-Jan15-Jan-09  11-Jan to 
17-Jan16-Jan-09  11-Jan to 17-Jan17-Jan-09  11-Jan to 17-Jan18-Jan-09  18-Jan 
to 24-Jan19-Jan-09  18-Jan to 24-Jan
Date: Sun, 10 Jan 2010 09:10:23 -0800
From: alokeshwar.tiw...@yahoo.com
Subject: Re: $$Excel-Macros$$ Vlookup-Dates
To: excel-macros@googlegroups.com





Please share the workbook?

_
"There are known knowns. These are things we know that we know. There are known 
unknowns. That is to say, there are things that we know we don't know. But 
there are also unknown unknowns. There are things we don't know we don't know."






From: Sachin Gohil 
To: excel-macros@googlegroups.com
Sent: Sun, 10 January, 2010 7:00:44 PM
Subject: $$Excel-Macros$$ Vlookup-Dates



Dear All,


I did a vlookup of dates, but Im getting #N/A. The reason is every date in 
excel is tored as serial no. Tried using Date/Date value but it doesnt work..






New Windows 7: Find the right PC for you. Learn more. -- 
--
Some important links for excel users:
1. Follow us in TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
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
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe





   
The INTERNET now has a personality. YOURS! See your Yahoo! Homepage.
  
_
Windows 7: Find the right PC for you. Learn more.
http://windows.microsoft.com/shop-- 
--
Some important links for excel users:
1. Follow us in TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
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
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ Vlookup-Dates

[Alokeshwar Tiwary]

 you can use following function to get date range instead of a vlookup:

Function GetDateRange(Day1 As Date, CurrentDay As Date) As String
Dim i As Integer, LeftRange As Date, RightRange As Date
If Day1 > CurrentDay Then
    DateRange = "#INVALID#"
    Exit Function
End If
i = Application.WorksheetFunction.RoundDown((CurrentDay - Day1) / 7, 0)
LeftRange = 7 * (i) + (Day1)
RightRange = 7 * (i + 1) + (Day1 - 1)
GetDateRange = Format(LeftRange, "dd-mmm") & " to " & Format(RightRange, 
"dd-mmm")
End Function

If you want to convert date into Day names, use Text function = 
TEXT(YourDate,"ddd")

_
"There are known knowns. These are things we know that we know. There are known 
unknowns. That is to say, there are things that we know we don't know. But 
there are also unknown unknowns. There are things we don't know we don't know." 





From: Sachin Gohil 
To: excel-macros@googlegroups.com
Sent: Mon, 11 January, 2010 9:28:00 PM
Subject: RE: $$Excel-Macros$$ Vlookup-Dates

Its very simple data. For every date I want Mon-Sun for that date.  

File 1: 
Date           Week
15-Jan-09   =vlookup(A2,File2,2,0) which gives #N/A

File 2:
Date          Week
11-Jan-09  11-Jan to 17-Jan
12-Jan-09  11-Jan to 17-Jan
13-Jan-09  11-Jan to 17-Jan
14-Jan-09  11-Jan to 17-Jan
15-Jan-09  11-Jan to 17-Jan
16-Jan-09  11-Jan to 17-Jan
17-Jan-09  11-Jan to 17-Jan
18-Jan-09  18-Jan to 24-Jan
19-Jan-09  18-Jan to 24-Jan


Date: Sun, 10 Jan 2010 09:10:23 -0800
From: alokeshwar.tiw...@yahoo.com
Subject: Re: $$Excel-Macros$$ Vlookup-Dates
To: excel-macros@googlegroups.com



Please share the workbook?

_
"There are known knowns. These are things we know that we know. There are known 
unknowns. That is to say, there are things that we know we don't know. But 
there are also unknown unknowns. There are things we don't know we don't know." 




____
From: Sachin Gohil 
To: excel-macros@googlegroups.com
Sent: Sun, 10 January, 2010 7:00:44 PM
Subject: $$Excel-Macros$$ Vlookup-Dates

Dear All, 

I did a vlookup of dates, but Im getting #N/A. The reason is every date in 
excel is tored as serial no. Tried using Date/Date value but it doesnt work..



New Windows 7: Find the right PC for you. Learn more. -- 
--
Some important links for excel users:
1. Follow us in TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
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
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe


The INTERNET now has a personality. YOURS! See your Yahoo! Homepage.

Windows 7: Find the right PC for you. Learn more. -- 
--
Some important links for excel users:
1. Follow us in TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
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
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe



 

Re: $$Excel-Macros$$ VLOOKUP function

[Shreedar Pandurangaiah]

Hi Alan,

The third part of the formula, where you've put $E:$E has to be replaced by
either 1 or 2(since your table array is just D and E column).

Thanks,
Shreedar

On Sun, Oct 10, 2010 at 2:30 AM, Alan  wrote:

>   I am using Excel 2007 and having a strange problem with the VLOOKUP
> function.  I have never used it before, but I have looked at examples
> on the Internet.  However, I cannot figure it out.
>
>  I placed the following formula in Cell B2:
>
> =VLOOKUP($A2,$D$2:$E$9,$E:$E,FALSE)
>
> and then copied it to B3 and B4, which respectively show up as:
>
> =VLOOKUP($A3,$D$2:$E$9,$E:$E,FALSE)
> =VLOOKUP($A4,$D$2:$E$9,$E:$E,FALSE)
>
> My lookup table is located at D2:E9, with what I am looking up in
> column D, and the value for the lookup in column E.
>
>I placed the second entry in the table in cells A2, A3, and A4.
> The VLOOKUP functions in cells B2, B3, and B4 show the following
> results:
>
> B2: #VALUE!
> B3: , same as in A3
> B4: the correct lookup value.
>
>   This does not make any sense to me, based on the examples I have
> seen.
>
> What am I doing wrong?  Thanks, Alan
>
>
> --
>
> --
> 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 function

[Alan]

  Thank you!  I had problems when I just used an absolute column
number.
I did not realize that it was relative to the start of the table.  In
the simple tutorials,
it is not clear whether it was supposed to be absolute or relative
(same in examples).

  Alan

On Oct 9, 10:57 pm, Shreedar Pandurangaiah
 wrote:
> Hi Alan,
>
> The third part of the formula, where you've put $E:$E has to be replaced by
> either 1 or 2(since your table array is just D and E column).
>
> Thanks,
> Shreedar
>
>

-- 
--
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 function

[Pranav Vashishtha]

Dear Alan
Apply tis formula and your problem will be over.
VlOOKUP Function needs 4 parameters your 1st,2nd,& 4th parameters are
correct but in the 3rd parameter (Column no.) you supplied the column
address that is $E:$E. I have just changed it to column no. 2 which is
second column of your table where you want to look up for data.

=VLOOKUP($A2,$D$2:$E$9,2,FALSE)

Hope that helps!

Warm Regards,

Pranav


On Sun, Oct 10, 2010 at 2:30 AM, Alan  wrote:

>   I am using Excel 2007 and having a strange problem with the VLOOKUP
> function.  I have never used it before, but I have looked at examples
> on the Internet.  However, I cannot figure it out.
>
>  I placed the following formula in Cell B2:
>
> =VLOOKUP($A2,$D$2:$E$9,$E:$E,FALSE)
>
> and then copied it to B3 and B4, which respectively show up as:
>
> =VLOOKUP($A3,$D$2:$E$9,$E:$E,FALSE)
> =VLOOKUP($A4,$D$2:$E$9,$E:$E,FALSE)
>
> My lookup table is located at D2:E9, with what I am looking up in
> column D, and the value for the lookup in column E.
>
>I placed the second entry in the table in cells A2, A3, and A4.
> The VLOOKUP functions in cells B2, B3, and B4 show the following
> results:
>
> B2: #VALUE!
> B3: , same as in A3
> B4: the correct lookup value.
>
>   This does not make any sense to me, based on the examples I have
> seen.
>
> What am I doing wrong?  Thanks, Alan
>
>
> --
>
> --
> 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 function

[Pranav Vashishtha]

Dear Alan
Apply tis formula and your problem will be over.
VlOOKUP Function needs 4 parameters your 1st,2nd,& 4th parameters are
correct but in the 3rd parameter (Column no.) you supplied the column
address that is $E:$E. I have just changed it to column no. 2 which is
second column of your table where you want to look up for data.

=VLOOKUP($A2,$D$2:$E$9,2,FALSE)

Hope that helps!

Warm Regards,

Pranav


On Sun, Oct 10, 2010 at 2:30 AM, Alan  wrote:

>   I am using Excel 2007 and having a strange problem with the VLOOKUP
> function.  I have never used it before, but I have looked at examples
> on the Internet.  However, I cannot figure it out.
>
>  I placed the following formula in Cell B2:
>
> =VLOOKUP($A2,$D$2:$E$9,$E:$E,FALSE)
>
> and then copied it to B3 and B4, which respectively show up as:
>
> =VLOOKUP($A3,$D$2:$E$9,$E:$E,FALSE)
> =VLOOKUP($A4,$D$2:$E$9,$E:$E,FALSE)
>
> My lookup table is located at D2:E9, with what I am looking up in
> column D, and the value for the lookup in column E.
>
>I placed the second entry in the table in cells A2, A3, and A4.
> The VLOOKUP functions in cells B2, B3, and B4 show the following
> results:
>
> B2: #VALUE!
> B3: , same as in A3
> B4: the correct lookup value.
>
>   This does not make any sense to me, based on the examples I have
> seen.
>
> What am I doing wrong?  Thanks, Alan
>
>
> --
>
> --
> 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 function

[SUMIT VYAS]

Dear,

Please find herewith VBA vlookup

   one
Value look up in column 1  6
Value look up in column 2  vlookup2(F10, F11, tLookupDemo, 3) Result





Option Explicit

''
***
'' Purpose  : Test VLOOKUP2 function
'' Written  : 01-Nov-2001 by Andy Wiggins, Byg Software Limited
'' Notes: To see the reuslts, ensure the "Immediate" window is open
(Ctrl+G)
''
Sub Test_Vlookup2()

ThisWorkbook.Activate
Sheets("Lookup in two columns").Select

''Test two numeric parameters
Debug.Print "(1) " & VLOOKUP2(3, 5, Range("tLookupDemo"), 3)
''Test alpha and numeric parameter
Debug.Print "(2) " & VLOOKUP2("One", 4, Range("tLookupDemo"), 3)

''Test two valid parameters
If IsError(VLOOKUP2(3, 5, Range("tLookupDemo"), 3)) Then
Debug.Print "(3) " & "Is error"
Else
Debug.Print "(3) " & "Okay"
End If

''Test with an invalid parameter
If IsError(VLOOKUP2(33, 5, Range("tLookupDemo"), 3)) Then
Debug.Print "(4) " & "Is error"
Else
Debug.Print "(4) " & "Okay"
End If

End Sub

''
***
'' Purpose  : Lookup function based on two columns / Demonstrate use of
Evaluate
'' Written  : 30-Oct-2001 by Andy Wiggins, Byg Software Limited
'' Amended  : 09-May-2002 by Andy Wiggins
''
Function VLOOKUP2(pVal1, pVal2, pRng As Range, pInd As Integer)
''The lookup values refer to columns 1 and 2 in the range
Application.Volatile

Dim lStr_Seek As String
Dim lStr_Col1 As String
Dim lStr_Col2 As String
Dim lStr_Col3 As String

''If an error occurs with "Evaluate" it isn't passed to this function's
error handler
''This handler will pick up any other errors that may occur
On Error GoTo Error_VLOOKUP2

''The quotes enure strings are treated as such and NOT as range names
lStr_Seek =  & pVal1 & ":""&""" & pVal2 & 
lStr_Col1 = pRng.Columns(1).Address
lStr_Col2 = pRng.Columns(2).Address
lStr_Col3 = pRng.Columns(pInd).Address

VLOOKUP2 = Evaluate("index(" & lStr_Col3 & ",match(" & lStr_Seek & "," &
lStr_Col1 & "&"":""&" & lStr_Col2 & ",0))")
Exit Function

Error_VLOOKUP2:
VLOOKUP2 = Err
End Function





On Mon, Oct 11, 2010 at 5:34 PM, Pranav Vashishtha wrote:

> Dear Alan
> Apply tis formula and your problem will be over.
> VlOOKUP Function needs 4 parameters your 1st,2nd,& 4th parameters are
> correct but in the 3rd parameter (Column no.) you supplied the column
> address that is $E:$E. I have just changed it to column no. 2 which is
> second column of your table where you want to look up for data.
>
> =VLOOKUP($A2,$D$2:$E$9,2,FALSE)
>
> Hope that helps!
>
> Warm Regards,
>
> Pranav
>
>
> On Sun, Oct 10, 2010 at 2:30 AM, Alan  wrote:
>
>>   I am using Excel 2007 and having a strange problem with the VLOOKUP
>> function.  I have never used it before, but I have looked at examples
>> on the Internet.  However, I cannot figure it out.
>>
>>  I placed the following formula in Cell B2:
>>
>> =VLOOKUP($A2,$D$2:$E$9,$E:$E,FALSE)
>>
>> and then copied it to B3 and B4, which respectively show up as:
>>
>> =VLOOKUP($A3,$D$2:$E$9,$E:$E,FALSE)
>> =VLOOKUP($A4,$D$2:$E$9,$E:$E,FALSE)
>>
>> My lookup table is located at D2:E9, with what I am looking up in
>> column D, and the value for the lookup in column E.
>>
>>I placed the second entry in the table in cells A2, A3, and A4.
>> The VLOOKUP functions in cells B2, B3, and B4 show the following
>> results:
>>
>> B2: #VALUE!
>> B3: , same as in A3
>> B4: the correct lookup value.
>>
>>   This does not make any sense to me, based on the examples I have
>> seen.
>>
>> What am I doing wrong?  Thanks, Alan
>>
>>
>> --
>>
>> --
>> 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:/

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

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

[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

[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

$$Excel-Macros$$ Vlookup in Macro

[Raj Mahapatra]

hi group,

In the following vlookup code in macro, if any object is #N/A in the rng
then "*run time error 1004*"occurs.  In such case, i want that it should
show a message as "*lookfor data is not in the range"*

help me how to put msg box if lookfor is not in the rng.

Sub vlookup()
Dim lookfor As Range
Dim rng As Range
Dim col As Integer

Set lookfor = ActiveCell.Offset(0, 2)
Set rng = Sheets("MV").Columns("A:C")
col = 3

dept_code = Application.WorksheetFunction.vlookup(lookfor, rng, col, 0)
End Sub
Thanks & Regards

Rajesh Mahapatra

-- 
--
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

$$Excel-Macros$$ Vlookup Query-2

[Jai]

Hello Experts

I Have a one Qurery Please Check the attachment

-- 
--
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/discussexcel


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

Re: $$Excel-Macros$$ vlookup query

[Venkatesh Srinivas]

please shoot your query

On Sat, Jul 9, 2011 at 9:43 AM, PRADEEP KUMAR KOKNE <
pradeepkumar...@gmail.com> wrote:

> I have a some query regarding the vlookup can somebody help
>
> --
>
> --
> 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/discussexcel
>



-- 

Regards
Venkatesh KS
Phone: +91 98419 69353

-- 
--
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/discussexcel

Re: $$Excel-Macros$$ Vlookup Query

[ashish koul]

check the attachment see if it helps


On Sat, Jul 9, 2011 at 9:56 AM, PRADEEP KUMAR KOKNE <
pradeepkumar...@gmail.com> wrote:

> Base file: this file has 3 columns which has
>
>
> CustomerLE  Cost Center
> AUG0001 SDFV445858
> USA0001 JHNE652147
> ZMA0001 NMVE321745
>
> Actual file: I have same 3 columns, I want a macro which has to
> CONCATENATE all the 3 columns and do a vlookup to check the
> combination, if the combination is invalid it has to show an error
> message
>
> CustomerLE  Cost Center Errrs
> AUG0001 SDFV527850  error message; combination is invalid
> USA0001 JHNE652147
> ZMA0001 NMVE321745
>
> --
>
> --
> 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/discussexcel
>



-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com 
http://akoul.posterous.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/discussexcel


lookup value error.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Vlookup Query

[PRADEEP KUMAR KOKNE]

Hey thanks for the formulae, but i want this with a vba code,  as i have
send to my customers, i cannot tell them to use formulaes they want
everything in "ALT+F8" format

On Sat, Jul 9, 2011 at 12:01 PM, ashish koul  wrote:

> check the attachment see if it helps
>
>
> On Sat, Jul 9, 2011 at 9:56 AM, PRADEEP KUMAR KOKNE <
> pradeepkumar...@gmail.com> wrote:
>
>> Base file: this file has 3 columns which has
>>
>>
>> CustomerLE  Cost Center
>> AUG0001 SDFV445858
>> USA0001 JHNE652147
>> ZMA0001 NMVE321745
>>
>> Actual file: I have same 3 columns, I want a macro which has to
>> CONCATENATE all the 3 columns and do a vlookup to check the
>> combination, if the combination is invalid it has to show an error
>> message
>>
>> CustomerLE  Cost Center Errrs
>> AUG0001 SDFV527850  error message; combination is invalid
>> USA0001 JHNE652147
>> ZMA0001 NMVE321745
>>
>> --
>>
>> --
>> 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/discussexcel
>>
>
>
>
> --
> *Regards*
> * *
> *Ashish Koul*
> *akoul*.*blogspot*.com 
> http://akoul.posterous.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/discussexcel
>

-- 
--
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/discussexcel

Re: $$Excel-Macros$$ Vlookup Query

[PRADEEP KUMAR KOKNE]

Hey how can i attach sample files, which button to click? as i dont
see any button with browse or attach. please help


On Jul 9, 11:31 am, ashish koul  wrote:
> check the attachment see if it helps
>
> On Sat, Jul 9, 2011 at 9:56 AM, PRADEEP KUMAR KOKNE <
>
>
>
>
>
>
>
>
>
> pradeepkumar...@gmail.com> wrote:
> > Base file: this file has 3 columns which has
>
> > Customer        LE      Cost Center
> > AUG0001 SDFV    445858
> > USA0001 JHNE    652147
> > ZMA0001 NMVE    321745
>
> > Actual file: I have same 3 columns, I want a macro which has to
> > CONCATENATE all the 3 columns and do a vlookup to check the
> > combination, if the combination is invalid it has to show an error
> > message
>
> > Customer        LE      Cost Center     Errrs
> > AUG0001 SDFV    527850  error message; combination is invalid
> > USA0001 JHNE    652147
> > ZMA0001 NMVE    321745
>
> > --
>
> > --- 
> > ---
> > 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/discussexcel
>
> --
> *Regards*
> * *
> *Ashish Koul*
> *akoul*.*blogspot*.com http://akoul.posterous.com/
> *akoul*.wordpress.com 
> My Linkedin Profile 
>
> P Before printing, think about the environment.
>
>  lookup value error.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/discussexcel

Re: $$Excel-Macros$$ vlookup query

[ankur]

*where is query?
*Have A Nice Time & Enjoy Life

Regards:
CMA Ankur Pandey
(Someone Different)

I'm not the best but i'm not like the rest~~


On Sat, Jul 9, 2011 at 11:37 AM, Venkatesh Srinivas <
venkateshs@gmail.com> wrote:

> please shoot your query
>
>
> On Sat, Jul 9, 2011 at 9:43 AM, PRADEEP KUMAR KOKNE <
> pradeepkumar...@gmail.com> wrote:
>
>> I have a some query regarding the vlookup can somebody help
>>
>> --
>>
>> --
>> 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/discussexcel
>>
>
>
>
> --
>
> Regards
> Venkatesh KS
> Phone: +91 98419 69353
>
>  --
>
> --
> 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/discussexcel
>

-- 
--
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/discussexcel

Re: $$Excel-Macros$$ vlookup query

[PRADEEP KUMAR KOKNE]

Hi

Can some one write a macro as per the attach files.

i need a loop fo
On Mon, Jul 11, 2011 at 11:37 AM, ankur  wrote:

> *where is query?
> *Have A Nice Time & Enjoy Life
>
> Regards:
> CMA Ankur Pandey
> (Someone Different)
>
> I'm not the best but i'm not like the rest~~
>
>
> On Sat, Jul 9, 2011 at 11:37 AM, Venkatesh Srinivas <
> venkateshs@gmail.com> wrote:
>
>> please shoot your query
>>
>>
>> On Sat, Jul 9, 2011 at 9:43 AM, PRADEEP KUMAR KOKNE <
>> pradeepkumar...@gmail.com> wrote:
>>
>>> I have a some query regarding the vlookup can somebody help
>>>
>>> --
>>>
>>> --
>>> 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/discussexcel
>>>
>>
>>
>>
>> --
>>
>> Regards
>> Venkatesh KS
>> Phone: +91 98419 69353
>>
>>  --
>>
>> --
>> 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/discussexcel
>>
>
>  --
>
> --
> 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/discussexcel
>

-- 
--
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/discussexcel


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


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

$$Excel-Macros$$ VLOOKUP or Similiar

[Cab Boose]

Hi


I have a list of data 5 columns 1000 rows. There are some blank rows in this
list. Sometimes one sometimes several. I do not want to delete the rows.
 I want a vlookup function or similiar, to lookup column A for the required
number and copy into normal cell where formula is. That is: just a normal
vllookup function.

Question:How do I get the vlookup to go past the first blank row ?
 Thanks
 Charlie

-- 
--
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/discussexcel

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<>

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

[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]

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

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

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

[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

[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

[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

$$Excel-Macros$$ Vlookup Help required

[Anera Shyam]

Hi All,

I Dont think I have the syntax right..here is what am trying, If the result
of the Lookup is "Extended" and the subsequent look-up outputs are between
1 to 5 should show as R, between 5 to 7 as Y and >8 as G Or If the Lookup
value is "Monthly" and the subsequent look-up outputs are 1=R, 2=Y and
3=G..

Here is what i tried below, Please help...

=IF (Vlookup(A5, Data!A:D, 3, 0)="Extended", AND(IF(VLOOKUP($A5,
Data!$A:$N, 8, 0)<4.99, "R", IF(VLOOKUP($A5, Data!$A:$N, 8, 0)>4.99<7.99,
"Y", IF(VLOOKUP($A5, Data!$A:$N, 8, 0)>7.99, "G" OR(If (Vlookup(A5,
Data!A:D, 3, 0)="Monthly", If (Vlookup($A5, Data!$A:$N, 8, 0)=1, "R",
If(Vlookup($A5, Data!$A:$N, 8, 0)=2, "Y", If(Vlookup($A5, Data!$A:$N, 8,
0)=3, "G"))

Regards
Shyam

-- 
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 multiple cells

[Jorge]

Hi

I would like to be able to search for a name on a data base and 
automatically generate the 3 rows next to it containing the data related to 
the original search. For example if I search for PAUL on A1, I would like 
to have the the data on B1, B2 and B3 generated automatically on the same 
row split up in 4 cells as the original display on a different worksheet.

Can It be possible?

Please help

Thanks in advance,

Jorge

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

FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

6) Jobs posting is not allowed.

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

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

Re: $$Excel-Macros$$ Vlookup Required

[Paul Schreiner]

is there a question here?
 
Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-





From: amar takale 
To: excel-macros@googlegroups.com
Sent: Mon, September 24, 2012 7:51:28 AM
Subject: $$Excel-Macros$$ Vlookup Required


-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel
 
FORUM RULES (1120+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

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

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

FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

6) Jobs posting is not allowed.

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

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

Re: $$Excel-Macros$$ Vlookup Required

[amar takale]

Pual Sir,
This is not question.Actually I need Vlookup solution for Data Arrange. So
I post my query for solution to my excel group users.
Regards
Amar

On Mon, Sep 24, 2012 at 5:23 PM, Paul Schreiner wrote:

> is there a question here?
>
>
> *Paul*
>
> -
> *“Do all the good you can,
> By all the means you can,
> In all the ways you can,
> In all the places you can,
> At all the times you can,
> To all the people you can,
> As long as ever you can.” - John Wesley
> *-
>
>
>  --
> *From:* amar takale 
> *To:* excel-macros@googlegroups.com
> *Sent:* Mon, September 24, 2012 7:51:28 AM
> *Subject:* $$Excel-Macros$$ Vlookup Required
>
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>

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

FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

6) Jobs posting is not allowed.

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

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

Re: $$Excel-Macros$$ Vlookup Required

[David Grugeon]

It is not possible to tell from the file what you want to achieve.
Please describe the problem in the body of your email.

Regards
David Grugeon


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

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

FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

6) Jobs posting is not allowed.

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

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

Re: $$Excel-Macros$$ Vlookup Required

[Paul Schreiner]

Sorry, I must've jumped into the discussion mid-way.
I didn't find any question or request, and the subject is a simple statement.
I didn't realize that it was responding to something else, not an initial 
request for assistance.

Sorry for the confusion.
 
Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-





From: amar takale 
To: excel-macros@googlegroups.com
Sent: Mon, September 24, 2012 8:01:53 AM
Subject: Re: $$Excel-Macros$$ Vlookup Required

Pual Sir,
This is not question.Actually I need Vlookup solution for Data Arrange. So I 
post my query for solution to my excel group users.
Regards
Amar  


On Mon, Sep 24, 2012 at 5:23 PM, Paul Schreiner  wrote:

is there a question here?
> 
>Paul
>-
>“Do all the good you can,
>By all the means you can,
>In all the ways you can,
>In all the places you can,
>At all the times you can,
>To all the people you can,
>As long as ever you can.” - John Wesley
>-
>
>
>
>
>

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

 
6) Jobs posting is not allowed.
 
7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
 
NOTE : Don't eve

Re: $$Excel-Macros$$ Vlookup Required

[David Grugeon]

Hi Paul

I don't think it is a question or an answer.  I think it is a mindreading test.
Regards
David Grugeon


On 24 September 2012 22:08, Paul Schreiner  wrote:
> Sorry, I must've jumped into the discussion mid-way.
> I didn't find any question or request, and the subject is a simple
> statement.
> I didn't realize that it was responding to something else, not an initial
> request for assistance.
>
> Sorry for the confusion.
>
>
> Paul
>
> -
> “Do all the good you can,
> By all the means you can,
> In all the ways you can,
> In all the places you can,
> At all the times you can,
> To all the people you can,
> As long as ever you can.” - John Wesley
> -
>
>
>
> 
> From: amar takale 
> To: excel-macros@googlegroups.com
> Sent: Mon, September 24, 2012 8:01:53 AM
> Subject: Re: $$Excel-Macros$$ Vlookup Required
>
> Pual Sir,
> This is not question.Actually I need Vlookup solution for Data Arrange. So I
> post my query for solution to my excel group users.
> Regards
> Amar
>
> On Mon, Sep 24, 2012 at 5:23 PM, Paul Schreiner 
> wrote:
>>
>> is there a question here?
>>
>>
>> Paul
>>
>> -
>> “Do all the good you can,
>> By all the means you can,
>> In all the ways you can,
>> In all the places you can,
>> At all the times you can,
>> To all the people you can,
>> As long as ever you can.” - John Wesley
>> -
>>
>>
>>
>> 
>> From: amar takale 
>> To: excel-macros@googlegroups.com
>> Sent: Mon, September 24, 2012 7:51:28 AM
>> Subject: $$Excel-Macros$$ Vlookup Required
>>
>>
>> --
>> Join official facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES (1120+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
>> not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> 6) Jobs posting is not allowed.
>>
>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> To unsubscribe from this group, send email to
>> excel-macros+unsubscr...@googlegroups.com.
>>
>>
>>
>> --
>> Join official facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES (1120+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
>> not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> 6) Jobs posting is not allowed.
>>
>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> To unsubscribe from this group, send email to
>> excel-macros+unsubscr...@googlegroups.com.
>>
>>
>
>
> --
> Join official facebook page of this forum 

$$Excel-Macros$$ Vlookup with total

[Amit Desai (MERU)]

Dear All,

I have an excel file for which, there is Incentive worked out based on 2-3 
parameters for the same Technician.

I want to do a vlookup with the total amount (of 2-3 amounts) against that 
person. Please help me with a formula.

Best Regards,
Amit



Disclaimer: This message and its attachments contain confidential information 
and may also contain legally privileged information. This message is intended 
solely for the named addressee. If you are not the addressee indicated in this 
message (or authorized to receive for addressee), you may not copy or deliver 
any part of this message or its attachments to anyone or use any part of this 
message or its attachments. Rather, you should permanently delete this message 
and its attachments (and all copies) from your system and kindly notify the 
sender by reply e-mail. Any content of this message and its attachments that 
does not relate to the official business of Meru Cab Company Pvt. Ltd. must be 
taken not to have been sent or endorsed by any of them. Email communications 
are not private and no warranty is made that e-mail communications are timely, 
secure or free from computer virus or other defect.

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

FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

6) Jobs posting is not allowed.

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

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

Re: $$Excel-Macros$$ Vlookup Book

[noorain . ansari]

Dear Amit,

Currently i am out of station. Will share it shortly


Sent from BlackBerry® on Airtel

-Original Message-
From: "Amit Desai (MERU)" 
Sender: excel-macros@googlegroups.com
Date: Mon, 29 Oct 2012 14:25:27 
To: 
Reply-To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Vlookup Book

Dear Noorain,

Few days back you were referring a book to be written on vlookup.

If you have completed, could you please share the same with the Group?

Best Regards,
Amit



Disclaimer: This message and its attachments contain confidential information 
and may also contain legally privileged information. This message is intended 
solely for the named addressee. If you are not the addressee indicated in this 
message (or authorized to receive for addressee), you may not copy or deliver 
any part of this message or its attachments to anyone or use any part of this 
message or its attachments. Rather, you should permanently delete this message 
and its attachments (and all copies) from your system and kindly notify the 
sender by reply e-mail. Any content of this message and its attachments that 
does not relate to the official business of Meru Cab Company Pvt. Ltd. must be 
taken not to have been sent or endorsed by any of them. Email communications 
are not private and no warranty is made that e-mail communications are timely, 
secure or free from computer virus or other defect.

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

FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

6) Jobs posting is not allowed.

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

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



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

FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

6) Jobs posting is not allowed.

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

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

RE: $$Excel-Macros$$ Vlookup Book

[Amit Desai (MERU)]

Thanks a lot.

Best Regards,
Amit

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of noorain.ans...@gmail.com
Sent: 29 October 2012 17:07
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Vlookup Book

Dear Amit,

Currently i am out of station. Will share it shortly
Sent from BlackBerry(r) on Airtel

From: "Amit Desai (MERU)" 
mailto:amit.de...@merucabs.com>>
Sender: excel-macros@googlegroups.com<mailto:excel-macros@googlegroups.com>
Date: Mon, 29 Oct 2012 14:25:27 +0530
To: mailto:excel-macros@googlegroups.com>>
ReplyTo: excel-macros@googlegroups.com<mailto:excel-macros@googlegroups.com>
Subject: $$Excel-Macros$$ Vlookup Book

Dear Noorain,

Few days back you were referring a book to be written on vlookup.

If you have completed, could you please share the same with the Group?

Best Regards,
Amit



Disclaimer: This message and its attachments contain confidential information 
and may also contain legally privileged information. This message is intended 
solely for the named addressee. If you are not the addressee indicated in this 
message (or authorized to receive for addressee), you may not copy or deliver 
any part of this message or its attachments to anyone or use any part of this 
message or its attachments. Rather, you should permanently delete this message 
and its attachments (and all copies) from your system and kindly notify the 
sender by reply e-mail. Any content of this message and its attachments that 
does not relate to the official business of Meru Cab Company Pvt. Ltd. must be 
taken not to have been sent or endorsed by any of them. Email communications 
are not private and no warranty is made that e-mail communications are timely, 
secure or free from computer virus or other defect.
--
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

6) Jobs posting is not allowed.

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

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


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

FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

6) Jobs posting is not allowed.

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

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




Disclaimer: This message and its attachments contain confidential information 
and may also contain legally privileged information. This message is intended 
solely for the named addressee. If you are not the addressee indicated in this 
message (or authorized to receive for addressee), you may not copy or deliver 
any part of this message or its attachments to anyone or use any part of th

RE: $$Excel-Macros$$ Vlookup Book

[Amit Desai (MERU)]

Dear Noorain,

Are you back?

Could you please share the file please?

Best Regards,
Amit

From: excel-macros@googlegroups.com<mailto:excel-macros@googlegroups.com> 
[mailto:excel-macros@googlegroups.com] On Behalf Of 
noorain.ans...@gmail.com<mailto:noorain.ans...@gmail.com>
Sent: 29 October 2012 17:07
To: excel-macros@googlegroups.com<mailto:excel-macros@googlegroups.com>
Subject: Re: $$Excel-Macros$$ Vlookup Book

Dear Amit,

Currently i am out of station. Will share it shortly
Sent from BlackBerry(r) on Airtel

From: "Amit Desai (MERU)" 
mailto:amit.de...@merucabs.com>>
Sender: excel-macros@googlegroups.com<mailto:excel-macros@googlegroups.com>
Date: Mon, 29 Oct 2012 14:25:27 +0530
To: mailto:excel-macros@googlegroups.com>>
ReplyTo: excel-macros@googlegroups.com<mailto:excel-macros@googlegroups.com>
Subject: $$Excel-Macros$$ Vlookup Book

Dear Noorain,

Few days back you were referring a book to be written on vlookup.

If you have completed, could you please share the same with the Group?

Best Regards,
Amit



Disclaimer: This message and its attachments contain confidential information 
and may also contain legally privileged information. This message is intended 
solely for the named addressee. If you are not the addressee indicated in this 
message (or authorized to receive for addressee), you may not copy or deliver 
any part of this message or its attachments to anyone or use any part of this 
message or its attachments. Rather, you should permanently delete this message 
and its attachments (and all copies) from your system and kindly notify the 
sender by reply e-mail. Any content of this message and its attachments that 
does not relate to the official business of Meru Cab Company Pvt. Ltd. must be 
taken not to have been sent or endorsed by any of them. Email communications 
are not private and no warranty is made that e-mail communications are timely, 
secure or free from computer virus or other defect.
--
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

6) Jobs posting is not allowed.

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

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


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

FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

6) Jobs posting is not allowed.

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

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




Disclaimer: This message and its attachments contain confidential information 
and may also contain legally privileged information. This message is intended 
solely for the named addressee. If you are not th

RE: $$Excel-Macros$$ Vlookup Book

[Amit Desai (MERU)]

Dear Noorain,

Are you back?

Could you please share a book to be written on vlookup?

Best Regards,
Amit

From: excel-macros@googlegroups.com<mailto:excel-macros@googlegroups.com> 
[mailto:excel-macros@googlegroups.com] On Behalf Of 
noorain.ans...@gmail.com<mailto:noorain.ans...@gmail.com>
Sent: 29 October 2012 17:07
To: excel-macros@googlegroups.com<mailto:excel-macros@googlegroups.com>
Subject: Re: $$Excel-Macros$$ Vlookup Book

Dear Amit,

Currently i am out of station. Will share it shortly
Sent from BlackBerry(r) on Airtel

From: "Amit Desai (MERU)" 
mailto:amit.de...@merucabs.com>>
Sender: excel-macros@googlegroups.com<mailto:excel-macros@googlegroups.com>
Date: Mon, 29 Oct 2012 14:25:27 +0530
To: mailto:excel-macros@googlegroups.com>>
ReplyTo: excel-macros@googlegroups.com<mailto:excel-macros@googlegroups.com>
Subject: $$Excel-Macros$$ Vlookup Book

Dear Noorain,

Few days back you were referring a book to be written on vlookup.

If you have completed, could you please share the same with the Group?

Best Regards,
Amit



Disclaimer: This message and its attachments contain confidential information 
and may also contain legally privileged information. This message is intended 
solely for the named addressee. If you are not the addressee indicated in this 
message (or authorized to receive for addressee), you may not copy or deliver 
any part of this message or its attachments to anyone or use any part of this 
message or its attachments. Rather, you should permanently delete this message 
and its attachments (and all copies) from your system and kindly notify the 
sender by reply e-mail. Any content of this message and its attachments that 
does not relate to the official business of Meru Cab Company Pvt. Ltd. must be 
taken not to have been sent or endorsed by any of them. Email communications 
are not private and no warranty is made that e-mail communications are timely, 
secure or free from computer virus or other defect.
--
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

6) Jobs posting is not allowed.

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

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


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

FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

6) Jobs posting is not allowed.

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

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




Disclaimer: This message and its attachments contain confidential information 
and may also contain legally privileged information. This message is intended 
solely for the named addressee.

RE: $$Excel-Macros$$ Vlookup Book

[Amit Desai (MERU)]

Dear Noorain,

Could you please share the Vlookup book if it is prepared at your end?

Best Regards,
Amit

From: Amit Desai (MERU) [mailto:amit.de...@merucabs.com]
Sent: 02 November 2012 16:46
To: 'excel-macros@googlegroups.com'
Subject: RE: $$Excel-Macros$$ Vlookup Book

Dear Noorain,

Are you back?

Could you please share a book to be written on vlookup?

Best Regards,
Amit

From: excel-macros@googlegroups.com<mailto:excel-macros@googlegroups.com> 
[mailto:excel-macros@googlegroups.com] On Behalf Of 
noorain.ans...@gmail.com<mailto:noorain.ans...@gmail.com>
Sent: 29 October 2012 17:07
To: excel-macros@googlegroups.com<mailto:excel-macros@googlegroups.com>
Subject: Re: $$Excel-Macros$$ Vlookup Book

Dear Amit,

Currently i am out of station. Will share it shortly
Sent from BlackBerry(r) on Airtel

From: "Amit Desai (MERU)" 
mailto:amit.de...@merucabs.com>>
Sender: excel-macros@googlegroups.com<mailto:excel-macros@googlegroups.com>
Date: Mon, 29 Oct 2012 14:25:27 +0530
To: mailto:excel-macros@googlegroups.com>>
ReplyTo: excel-macros@googlegroups.com<mailto:excel-macros@googlegroups.com>
Subject: $$Excel-Macros$$ Vlookup Book

Dear Noorain,

Few days back you were referring a book to be written on vlookup.

If you have completed, could you please share the same with the Group?

Best Regards,
Amit



Disclaimer: This message and its attachments contain confidential information 
and may also contain legally privileged information. This message is intended 
solely for the named addressee. If you are not the addressee indicated in this 
message (or authorized to receive for addressee), you may not copy or deliver 
any part of this message or its attachments to anyone or use any part of this 
message or its attachments. Rather, you should permanently delete this message 
and its attachments (and all copies) from your system and kindly notify the 
sender by reply e-mail. Any content of this message and its attachments that 
does not relate to the official business of Meru Cab Company Pvt. Ltd. must be 
taken not to have been sent or endorsed by any of them. Email communications 
are not private and no warranty is made that e-mail communications are timely, 
secure or free from computer virus or other defect.
--
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

6) Jobs posting is not allowed.

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

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


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

FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

6) Jobs posting is not allowed.

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

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

Re: $$Excel-Macros$$ Vlookup Book

[NOORAIN ANSARI]

Dear Amit,

I am still committed on my words.

But I need some more time to complete it perfection and after completing it
I will definitely share it with group without any further reminder.

Kindly don't mark any mail to my official ID.



-- 
With Regards,
Noorain Ansari
http:// 
<http://www.noorainansari.com>noorainansari.com<http://www.noorainansari.com>
http:// 
<http://www.excelvbaclinic.blogspot.com>excelvbaclinic.com<http://www.excelvbaclinic.blogspot.com>



On Thu, Nov 8, 2012 at 4:31 PM, Amit Desai (MERU)
wrote:

>  Dear Noorain,
>
> ** **
>
> Could you please share the Vlookup book if it is prepared at your end?
>
> ** **
>
> Best Regards,
>
> Amit
>
> ** **
>
> *From:* Amit Desai (MERU) [mailto:amit.de...@merucabs.com]
> *Sent:* 02 November 2012 16:46
> *To:* 'excel-macros@googlegroups.com'
> *Subject:* RE: $$Excel-Macros$$ Vlookup Book
>
> ** **
>
> Dear Noorain,
>
> ** **
>
> Are you back?
>
> ** **
>
> Could you please share a book to be written on vlookup?
>
> ** **
>
> Best Regards,
>
> Amit
>
> ** **
>
> *From:* excel-macros@googlegroups.com [
> mailto:excel-macros@googlegroups.com ] *On
> Behalf Of *noorain.ans...@gmail.com
> *Sent:* 29 October 2012 17:07
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Vlookup Book
>
> ** **
>
> Dear Amit,
>
>
> Currently i am out of station. Will share it shortly
>
>  Sent from BlackBerry® on Airtel
>  --
>
> *From: *"Amit Desai (MERU)"  
>
> *Sender: *excel-macros@googlegroups.com 
>
> *Date: *Mon, 29 Oct 2012 14:25:27 +0530
>
> *To: *
>
> *ReplyTo: *excel-macros@googlegroups.com 
>
> *Subject: *$$Excel-Macros$$ Vlookup Book
>
> ** **
>
> Dear Noorain,
>
> ** **
>
> Few days back you were referring a book to be written on vlookup.
>
> ** **
>
> If you have completed, could you please share the same with the Group?
>
> ** **
>
> Best Regards,
>
> Amit
>
> ** **
>
> ** **
>  --
>
> Disclaimer: This message and its attachments contain confidential
> information and may also contain legally privileged information. This
> message is intended solely for the named addressee. If you are not the
> addressee indicated in this message (or authorized to receive for
> addressee), you may not copy or deliver any part of this message or its
> attachments to anyone or use any part of this message or its attachments.
> Rather, you should permanently delete this message and its attachments (and
> all copies) from your system and kindly notify the sender by reply e-mail.
> Any content of this message and its attachments that does not relate to the
> official business of Meru Cab Company Pvt. Ltd. must be taken not to have
> been sent or endorsed by any of them. Email communications are not private
> and no warranty is made that e-mail communications are timely, secure or
> free from computer virus or other defect.
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>
>  
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, li

RE: $$Excel-Macros$$ Vlookup Book

[Amit Desai (MERU)]

Sure... thanks a lot.

Best Regards,
Amit

From: NOORAIN ANSARI [mailto:noorain.ans...@gmail.com]
Sent: 08 November 2012 16:47
To: Amit Desai (MERU)
Cc: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Vlookup Book

Dear Amit,

I am still committed on my words.

But I need some more time to complete it perfection and after completing it I 
will definitely share it with group without any further reminder.

Kindly don't mark any mail to my official ID.



--
With Regards,
Noorain Ansari
http://<http://www.noorainansari.com>noorainansari.com<http://www.noorainansari.com>
http://<http://www.excelvbaclinic.blogspot.com>excelvbaclinic.com<http://www.excelvbaclinic.blogspot.com>


On Thu, Nov 8, 2012 at 4:31 PM, Amit Desai (MERU) 
mailto:amit.de...@merucabs.com>> wrote:
Dear Noorain,

Could you please share the Vlookup book if it is prepared at your end?

Best Regards,
Amit

From: Amit Desai (MERU) 
[mailto:amit.de...@merucabs.com<mailto:amit.de...@merucabs.com>]
Sent: 02 November 2012 16:46
To: 'excel-macros@googlegroups.com<mailto:excel-macros@googlegroups.com>'
Subject: RE: $$Excel-Macros$$ Vlookup Book

Dear Noorain,

Are you back?

Could you please share a book to be written on vlookup?

Best Regards,
Amit

From: excel-macros@googlegroups.com<mailto:excel-macros@googlegroups.com> 
[mailto:excel-macros@googlegroups.com] On Behalf Of 
noorain.ans...@gmail.com<mailto:noorain.ans...@gmail.com>
Sent: 29 October 2012 17:07
To: excel-macros@googlegroups.com<mailto:excel-macros@googlegroups.com>
Subject: Re: $$Excel-Macros$$ Vlookup Book

Dear Amit,


Currently i am out of station. Will share it shortly
Sent from BlackBerry(r) on Airtel

From: "Amit Desai (MERU)" 
mailto:amit.de...@merucabs.com>>
Sender: excel-macros@googlegroups.com<mailto:excel-macros@googlegroups.com>
Date: Mon, 29 Oct 2012 14:25:27 +0530
To: mailto:excel-macros@googlegroups.com>>
ReplyTo: excel-macros@googlegroups.com<mailto:excel-macros@googlegroups.com>
Subject: $$Excel-Macros$$ Vlookup Book

Dear Noorain,

Few days back you were referring a book to be written on vlookup.

If you have completed, could you please share the same with the Group?

Best Regards,
Amit



Disclaimer: This message and its attachments contain confidential information 
and may also contain legally privileged information. This message is intended 
solely for the named addressee. If you are not the addressee indicated in this 
message (or authorized to receive for addressee), you may not copy or deliver 
any part of this message or its attachments to anyone or use any part of this 
message or its attachments. Rather, you should permanently delete this message 
and its attachments (and all copies) from your system and kindly notify the 
sender by reply e-mail. Any content of this message and its attachments that 
does not relate to the official business of Meru Cab Company Pvt. Ltd. must be 
taken not to have been sent or endorsed by any of them. Email communications 
are not private and no warranty is made that e-mail communications are timely, 
secure or free from computer virus or other defect.
--
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

6) Jobs posting is not allowed.

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

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


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

FORUM RULES (1120+ members already BANNED for violation)

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

2) Don't post a question in the t