$$Excel-Macros$$ Re: Vlookup Matching Issue

Thank you. It works perfectly. MUCH appreciated. On Sunday, 22 May 2016 06:51:12 UTC-4, Bill Q wrote: > > 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 ne

$$Excel-Macros$$ Re: Vlookup with match or Indirect or Index

look at the attachment if you get some idea for your requirements -- 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 ti

Re: $$Excel-Macros$$ Re: VLOOKUP Query

Dear Pawan, Problem solved thanks for help Regards Shrinivas On Sat, Dec 26, 2015 at 9:40 AM, Shrinivas Shevde wrote: > Dear Pawan > Very very thanks I will check on Monday As I am out of office and let you > know. > Thanks once again > Regards > Shrinivas > > On Wed, Dec 23, 2015 at 5:18 PM,

Re: $$Excel-Macros$$ Re: VLOOKUP Query

Dear Pawan Very very thanks I will check on Monday As I am out of office and let you know. Thanks once again Regards Shrinivas On Wed, Dec 23, 2015 at 5:18 PM, Pawan Yadav wrote: > Hi Shrini, > > Use this formula instead => > *=VLOOKUP(IFERROR(ABS(C2),C2),$H$7:$I$17,2,FALSE) * > > Problem: ABS f

$$Excel-Macros$$ Re: VLOOKUP Query

Hi Shrini, Use this formula instead => *=VLOOKUP(IFERROR(ABS(C2),C2),$H$7:$I$17,2,FALSE) * Problem: ABS formula is not for Text value so it will return #Value Solution: As you lookup value consist both number and text value, so if you want to use ABS formula than use the above formula. If you

Re: $$Excel-Macros$$ Re: VLOOKUP Query

> > Some values in both tables are text and some are integers, You will get > Error for those only when text value is comparing with Integer. For correct > result you need to keep the format same. > *To understand this activity Do this to understand * Put 1 in cell A1 put formula in b1 = Text

Re: $$Excel-Macros$$ Re: VLOOKUP Query

Dear Mandeep thanks for reply but I could not understand which format shall I change which column Regards Shrinivas On Mon, Nov 30, 2015 at 10:34 AM, Mandeep Baluja wrote: > Keep the data in same format, number can't be equal to Text and text can't >> be equal to number,I put the data in same f

Re: $$Excel-Macros$$ Re: Vlookup Help required

rgenly required >> >> Rakesh >> -- Forwarded message -- >> From: "Mandeep Baluja" >> Date: 06-Jan-2015 5:52 PM >> Subject: $$Excel-Macros$$ Re: Vlookup Help required >> To: >> Cc: , >> >> Try this. >>> >> &

Re: $$Excel-Macros$$ Re: Vlookup Help required

e: 06-Jan-2015 5:52 PM > Subject: $$Excel-Macros$$ Re: Vlookup Help required > To: > Cc: , > > Try this. >> > > Regards, > Mandeep Baluja > LearningZmyPassion > https://www.linkedin.com/profile/view?id=312532939 > https://www.facebook.com/VBAEXCELSQL?ref=hl >

Fwd: $$Excel-Macros$$ Re: Vlookup Help required

Kindly with suitable formula urgenly required Rakesh -- Forwarded message -- From: "Mandeep Baluja" Date: 06-Jan-2015 5:52 PM Subject: $$Excel-Macros$$ Re: Vlookup Help required To: Cc: , Try this. > Regards, Mandeep Baluja LearningZmyPassion https://www.linkedi

$$Excel-Macros$$ Re: Vlookup Help required

Clear few things, 1.What is busy hour do you want that for first entry busy hour is 21 means 9 pm or anything else and then check whether it is in between start time and end time. and getting result for serving cell. 2.what is Peging Regards, Mandeep Baluja LearningZmyPassion https://www.linke

$$Excel-Macros$$ Re: Vlookup Help required

> > Try this. > Regards, Mandeep Baluja LearningZmyPassion https://www.linkedin.com/profile/view?id=312532939 https://www.facebook.com/VBAEXCELSQL?ref=hl -- 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 fo

$$Excel-Macros$$ Re: Vlookup Issue

You ought to spellcheck dictionery , the correct spelling is dictionary. On Monday, September 1, 2014 4:06:59 PM UTC+3, sk.yadav7186 wrote: > > Hello Friends, > > i have a query, please guide me. > > i have created a little software for word-meaning, now i want to display > error message when

Re: $$Excel-Macros$$ Re: Vlookup problem

=VLOOKUP($I2,$A$1:$F$9,MATCH(L$1,$A$1:$F$1,0),0) Thanks & regards, www.MrExcel4U.com On Thu, Mar 6, 2014 at 4:21 PM, mrExcel4u wrote: > Try this > > > =VLOOKUP($I1,$A$1:$F$9,COLUMN(A$1),0) > > Thanks & regards, > > www.MrExcel4U.com

Re: $$Excel-Macros$$ Re: Vlookup problem

Try this =VLOOKUP($I1,$A$1:$F$9,COLUMN(A$1),0) Thanks & regards, www.MrExcel4U.com On Thu, Mar 6, 2014 at 4:05 PM, manish jaiswal wrote: > > > On Thursday, March 6, 2014 4:03:30 PM UTC+5:30, manish jaiswal wrote: >> >> Cust#Sold to Cust#Sold to - Name Com

$$Excel-Macros$$ Re: Vlookup problem

On Thursday, March 6, 2014 4:03:30 PM UTC+5:30, manish jaiswal wrote: > > Cust#Sold to Cust#Sold to - Name Comm# Inv#No Invoice Date Item Code > Business 7000666325 SANDEEP ENTERPRISES 6562501469 01.03.2014 A39 HD Karbonn > Tab 7000666218 B.R. ENTERPRISES 6580015382 01.03.2014 A34 HD STAR

$$Excel-Macros$$ Re: Vlookup problem

Cust#Sold to Cust#Sold to - Name Comm# Inv#No Invoice Date Item Code Business 7000666325 SANDEEP ENTERPRISES 6562501469 01.03.2014 A39 HD Karbonn Tab 7000666218 B.R. ENTERPRISES 6580015382 01.03.2014 A34 HD STAR Karbonn Tab 7000663581 SHREENATHJI DISTRIBUTOR 6675032273 01.03.2014 A37 HD K

$$Excel-Macros$$ Re: Vlookup query

shrini check this http://excelautomate.blogspot.in/2013/12/lookups-and-tables.html On Wednesday, 20 November 2013 17:10:46 UTC+5:30, shrini wrote: > > Dear All > Please find attached query. > Is it possible to write aformula as per my requirement > > -- > Shrini > -- Are you =EXP(E:RT) or =NO

$$Excel-Macros$$ Re: vlookup help.

check this prabhu http://excelautomate.blogspot.in/2013/12/lookups-and-tables.html On Sunday, 24 November 2013 11:32:00 UTC+5:30, Prabhu Pinky wrote: > > 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 anoth

Re: $$Excel-Macros$$ Re: Vlookup query

Dear shakeel thanks problem solved great Help Regards Shrinivas On Thu, Nov 21, 2013 at 1:51 PM, Shakeel Dhanani wrote: > > You can use Index Match formula instead of VLookup as per Fiel atatched > > On Wednesday, November 20, 2013 4:40:46 PM UTC+5, shrini wrote: >> >> Dear All >> Please find at

$$Excel-Macros$$ Re: Vlookup query

You can use Index Match formula instead of VLookup as per Fiel atatched On Wednesday, November 20, 2013 4:40:46 PM UTC+5, shrini wrote: > > 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

$$Excel-Macros$$ Re: Vlookup - Price List

Are the qty min max consistent through out the table? If so, instead of vlookup, you can use MATCH instead I also have a multi-tiered pricing setup. I have written the table to have mutli columns for the prices Here is a sample of my lookup price table ITEM DESCRIPTION QTY PRICE QTY PRICE QT

$$Excel-Macros$$ Re: VlookUp VBA : Can't link up with a Text Box

Wow! Its working. Thanks a lot! On Wednesday, 30 October 2013 11:42:27 UTC+1, TAWHID wrote: > > Can anyone let me know whats wron in this code below? When I run it says > error in this line: Set lookFor = Me.TextBox1 > > Private Sub TextBox1_Change() > > Dim lookFor As Variant > Dim rng As Range

Re: $$Excel-Macros$$ Re: VlookUp VBA : Can't link up with a Text Box

Hi Rupesh, Clicking the count button is enabling the macro. No? Cheers On Thu, Oct 31, 2013 at 7:36 AM, Rupesh Patil wrote: > I have question over here how could userfrom show before without enable > micro. > > Thanks Rupesh > > > On Thu, Oct 31, 2013 at 11:48 AM, TAWHID wrote: > >> OMG! The P

$$Excel-Macros$$ Re: VlookUp VBA : Can't link up with a Text Box

Hi Rupesh, Clicking the count button is enabling the macro. No? Cheers On Wednesday, 30 October 2013 11:42:27 UTC+1, TAWHID wrote: > > Can anyone let me know whats wron in this code below? When I run it says > error in this line: Set lookFor = Me.TextBox1 > > Private Sub TextBox1_Change() > > D

Re: $$Excel-Macros$$ Re: VlookUp VBA : Can't link up with a Text Box

I have question over here how could userfrom show before without enable micro. Thanks Rupesh On Thu, Oct 31, 2013 at 11:48 AM, TAWHID wrote: > OMG! The Pic become to text !! print screen attached > > > On Wednesday, 30 October 2013 11:42:27 UTC+1, TAWHID wrote: >> >> Can anyone let me know wha

Re: $$Excel-Macros$$ Re: VlookUp VBA : Can't link up with a Text Box

Dear Tawhid, I have checked this ("When I put an item code in textbox1 it says item not found instead of showing it in the description. ") out and your code is working fine. I have enter item code in textbox1 and got there description in next to the textbox1 label Thanks Rupesh On Thu, Oct 31,

$$Excel-Macros$$ Re: VlookUp VBA : Can't link up with a Text Box

When I put an item code in textbox1 it says item not found instead of showing it in the description. Thanks On Wednesday, 30 October 2013 11:42:27 UTC+1, TAWHID wrote: > > Can anyone let me know whats wron in this code below? When I run it says > error in this line: Set lookFor = Me.TextBox1

Re: $$Excel-Macros$$ Re: VlookUp VBA : Can't link up with a Text Box

Your code is working fine. What error code you are getting there? On Wed, Oct 30, 2013 at 6:32 PM, TAWHID wrote: > Dear Rupesh , > Thanks for your quick reply. > > Please have look the attachemnt. > > If I press the "count" batton, the form appears. I am putting > (copy/paste) item code in t

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

Dear Ashish, I couldn't make out why you chose to use Choose function here. Am I missing something ? On Tue, Jul 16, 2013 at 7:35 PM, Kuldeep Singh wrote: > Your Welcome Ashish. > > Regards, > Kuldeep Singh > Assistant Manager Quality > Game Zone India Limited > Phone.: +91-9716615535 > || naukr

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

Your Welcome Ashish. Regards, Kuldeep Singh Assistant Manager Quality Game Zone India Limited Phone.: +91-9716615535 || naukrikuld...@gmail.com || *Please* *Consider the environment. Please don't print this e-mail unless you really need to.* On Tue, Jul 16, 2013 at 7:33 PM, Ashish Kumar wrote:

$$Excel-Macros$$ Re: vlookup madness

Thanks! This worked. However, I am not exactly sure why I got the weird results without that. -- 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)

$$Excel-Macros$$ Re: vlookup madness

Hi, After 2 in your formula plz add(, 0) for xl to recognize correct value. -- 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

$$Excel-Macros$$ Re: vlookup madness

I have changed the format of the columns and re-edited all the cells. This got rid of the invalid results, but I still get many incorrect results on the letters. I have looked up this topic on Google, but I have been able to resolve this frustrating problem! See attached, revised spreadsheet.

Re: $$Excel-Macros$$ Re: Vlookup for two same values

Dear Harshad, Please try.. -- With Regards, Noorain Ansari http:// noorainansari.com http:// excelvbaclinic.com On Fri, Jan 4, 2013 at 2:52 PM, Prince

Re: $$Excel-Macros$$ Re: Vlookup for two same values

I primarily want inclusion of all values in vlookup. Even if there is repetition of two item codes.corresponding inventory should be displayed.ordinarily only first value is taken. On Jan 7, 2013 9:54 AM, "Lalit Mohan Pandey" wrote: > Hi Harshad, > > Could you please explain how can you defrencia

$$Excel-Macros$$ Re: Vlookup for two same values

Hi Harshad, Could you please explain how can you defrenciate two same value like for which value i want data. Regards, Lalit Mohan On Friday, 4 January 2013 14:52:15 UTC+5:30, Prince wrote: > > Share your workbook. > > Regards > Prince > > On Friday, January 4, 2013 2:47:55 PM UTC+5:30, harshad

$$Excel-Macros$$ Re: Vlookup for two same values

Share your workbook. Regards Prince On Friday, January 4, 2013 2:47:55 PM UTC+5:30, harshad shukla wrote: > > I was stuck up with a problem.i have to use vlookup .but in case of two > same values i want distinct values as answer.i.e. if table has two common > values .the vlookup should give va

$$Excel-Macros$$ Re: Vlookup with total

Hi, You can also use sumif function =SUMIF(A2:B8,E5,B2:B8). Attachment is with formula results are derived. rgsd vishwanath On Tuesday, October 23, 2012 12:56:36 PM UTC+5:30, Amit Desai (MERU) wrote: > > Dear All, > > > > I have an excel fil

$$Excel-Macros$$ Re: Vlookup or Match formula - regionwise

Hi Sreejit, Please see the attachment i hope this will help you. regards prince 9891472849 On Sunday, 8 July 2012 20:55:24 UTC+5:30, Sreejith K. V wrote: > > Hi Team, > > Can someone please help me with the attached excel sheet. > > Regards > Sreejith > -- FORUM RULES (986+ members already

$$Excel-Macros$$ Re: VLOOKUP OR SUMPRODUCT FORMULA HELP

Hello Amit, Try this in G15 and copy down & across. =SUMPRODUCT(ISNUMBER(MATCH($F15&"|"&$F$5:$F$9,$A$5:$A$21&"|"&$B$5:$B$21,0))+0,G$5:G$9) Regards, Haseeb -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Hel

Re: $$Excel-Macros$$ Re: VLOOKUP FROM A RANGE OF SHEETS

Dear Vivek, Please find attached example sheet of Global Vlookup. -- Thanks & regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Mon, Jun 11, 2012 at 8:59 AM, Vivek wrote: > How to use the Vlookup function in a separate excel file, to search for > file number f

$$Excel-Macros$$ Re: VLOOKUP FROM A RANGE OF SHEETS

How to use the Vlookup function in a separate excel file, to search for file number form the client index file, where data are stored in multiple sheets. On Friday, 8 June 2012 10:12:45 UTC+5:30, Vivek wrote: > I have created a file index , with separate sheets alphabetically. > > > > Now I

Re: $$Excel-Macros$$ Re: VLOOKUP FROM A RANGE OF SHEETS

Please replace previous Please see attached 2012/6/9 ChilExcel : > Please see attached > > 2012/6/9 Vivek : >> >> Dear All, >> Please find enclosed herewith the sample file. >> Thanks >> CA Vivek Jain. >> >> On Friday, 8 June 2012 10:12:45 UTC+5:30, Vivek wrote: >>> >>> I have created a file index

Re: $$Excel-Macros$$ Re: VLOOKUP FROM A RANGE OF SHEETS

Please see attached 2012/6/9 Vivek : > > Dear All, > Please find enclosed herewith the sample file. > Thanks > CA Vivek Jain. > > On Friday, 8 June 2012 10:12:45 UTC+5:30, Vivek wrote: >> >> I have created a file index , with separate sheets alphabetically. >> >> >> >> Now I want to use the vlooku

Re: $$Excel-Macros$$ Re: VLOOKUP FROM A RANGE OF SHEETS

YOu could use something like this Use in B1 where you put the client name in A1 =INDEX(INDIRECT("'[sample file register .xlsx]"&LEFT(A1,1)&"'!$A$2:$A$20"),MATCH(A1,INDIRECT("'[sample file register .xlsx]"&LEFT(A1,1)&"'!$B$2:$B$20"),0)) Regards, Sam Mathai Chacko On Sat, Jun 9, 2012 at 5:06 PM,

$$Excel-Macros$$ Re: VLOOKUP FROM A RANGE OF SHEETS

Dear All, Please find enclosed herewith the sample file. Thanks CA Vivek Jain. On Friday, 8 June 2012 10:12:45 UTC+5:30, Vivek wrote: > I have created a file index , with separate sheets alphabetically. > > > > Now I want to use the vlookup function in a new file, wherein I would type > the

$$Excel-Macros$$ Re: Vlookup, Index, Match, Offset function in VBA Coading!!!!!!!!

These Youtube Videos my might Help http://youtu.be/nZfySb0FI8w - A VBA Formula Trick http://youtu.be/W82P4cxVK3M - Application.WorksheetFunction On Monday, May 14, 2012 4:23:28 AM UTC-6, Bullet wrote: > > > Hi All, > > Can anyone explain how to use Vlookup, Index, Match, Offset function in >

$$Excel-Macros$$ Re: Vlookup, Index, Match, Offset function in VBA Coading!!!!!!!!

you can use any Excel function in vba via Application.WorksheetFunction. Application.WorksheetFunction.VLookup(arg1,arg2,arg3,arg4) arg= parameters required in excel functions Application.WorksheetFunction.VLookup(range("A1").value,Range("B1:D7"),2,0) Best Regards, Anubhav On Monday, May 1

$$Excel-Macros$$ Re: VLookup Query.??????................Plz Help

Hi Noorain, Correct me if I am wrong. What you are trying to do in this function is to bring up the relevant data from 3 different worksheets. In the event, that one worksheet does not have the data, the formula will cycle through to the other worksheet. However, using the OR function here will no

Re: $$Excel-Macros$$ Re: VLOOKUP PPT

plz send to all,it will be benificialy for us. On Mon, Jul 5, 2010 at 10:10 AM, Soni.Rajender wrote: > Thanks for the ppt. > > Regards > Rajender Soni > > On Jul 4, 9:18 am, Ayush wrote: > > Hi Neil, > > > > Thank you for sharing the useful file. > > > > Best Regards, > > Ayush Jain > > Group Ma

$$Excel-Macros$$ Re: VLOOKUP PPT

Thanks for the ppt. Regards Rajender Soni On Jul 4, 9:18 am, Ayush wrote: > Hi Neil, > > Thank you for sharing the useful file. > > Best Regards, > Ayush Jain > Group Manager. > > On Jul 3, 9:41 pm, neil johnson wrote: > > > > > Hi Everyone, > > > This is ppt of vlookup .  I am very lucky , I a

$$Excel-Macros$$ Re: VLOOKUP PPT

Hi Neil, Thank you for sharing the useful file. Best Regards, Ayush Jain Group Manager. On Jul 3, 9:41 pm, neil johnson wrote: > Hi Everyone, > > This is ppt of vlookup .  I am very lucky , I am the member of this team. I > am sending attached PPT . > > Thanks and Regards > >  vlookup.ppt > 178

$$Excel-Macros$$ Re: Vlookup

Hi Thank you so much thats exactly i wanted Regards Ruchi On Mon, Sep 28, 2009 at 5:32 PM, Abhishek Jain wrote: > Please see the attached file. > > All I did is change the format of destination cell to "General" > > Rgrds > > On Mon, Sep 28, 2009 at 12:04 AM, god is gr8 i love u > wrote: >>

$$Excel-Macros$$ Re: Vlookup and If formula

Dear Jitheesh, Answered this one at 09:39 PM IST. Check that and let me know if you have any questions. Thanks -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 9/15/09, Jitheesh Vazhapully <7jit...@gmail.com

$$Excel-Macros$$ Re: Vlookup and If formula

"MS EXCEL AND VBA MACROS" > Sent: Thursday, September 17, 2009 2:38 PM > Subject: $$Excel-Macros$$ Re: Vlookup and If formula > > > > Great thought sir, > > I will definitely follow your advice. > > Thanks > > Jitheesh Janardhan > > > -- &g

$$Excel-Macros$$ Re: Vlookup and If formula

9 2:38 PM Subject: $$Excel-Macros$$ Re: Vlookup and If formula Great thought sir, I will definitely follow your advice. Thanks Jitheesh Janardhan -- DISCLAIMER: This message and any attachments are solely for the intended recipient and may contain confidential or privileged information. I

$$Excel-Macros$$ Re: Vlookup and If formula

Great thought sir, I will definitely follow your advice. Thanks Jitheesh Janardhan --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and

$$Excel-Macros$$ Re: Vlookup and If formula

Thanks Jiju, no need of cake, ur one line of gratitude is more than enough to make my day. But one suggestion from me, always go for the toughest solutions as* "Smooth roads never make good drivers".* * * Happy learning... * *Thanks & Regards, Harmeet Singh Sent via BlackBerry Wireless

$$Excel-Macros$$ Re: Vlookup and If formula

Hi prashant, Thankyou for your suggestion. I think next time, I have to use pivot tables rather than a formula. I'm just at a beginner and recreating such complex formulas like harmeetji's would be tough for me. Thankyou guys- --~--~-~--~~~---~--~~ ---

$$Excel-Macros$$ Re: Vlookup and If formula

Hi Harmeet Sir, Thankyou so much for all your efforts. Chocolate kya sirji, your deserve a cake for this--- Thanks --~--~-~--~~~---~--~~ -- Some important links for excel users: 1

$$Excel-Macros$$ Re: Vlookup and If formula

Dear Jitiesh, I have done the same using simple pivot report , then using show report filter pages option of pivot . It is very easy then formulas Regards, Prashant From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Jitheesh Vazhapully Sent: Tu

$$Excel-Macros$$ Re: Vlookup Value

> > dilipan...@yahoo.com > > New Delhi - 110062 > > > > On Wed, Sep 2, 2009 at 1:43 PM, Umesh Gupta 3 > wrote: > > > > > > > > > IT IS REALLY GOOD > > > > > THANKS > > > > > - Original Message - > > > *Fro

$$Excel-Macros$$ Re: Vlookup Value

upta 3 wrote: > > > > >  IT IS REALLY GOOD > > > THANKS > > > - Original Message - > > *From:* Dilip Pandey > > *To:* excel-macros@googlegroups.com > > *Sent:* 02 September, 2009 10:53 AM > > *Subject:* $$Excel-Macros$$ Re: Vlookup V

$$Excel-Macros$$ Re: Vlookup Value

e - > *From:* Dilip Pandey > *To:* excel-macros@googlegroups.com > *Sent:* 02 September, 2009 10:53 AM > *Subject:* $$Excel-Macros$$ Re: Vlookup Value > > Hi Ashwin, > > I believe you need multiple values based on single criteria across the data > range. Same is done a

$$Excel-Macros$$ Re: Vlookup Value

IT IS REALLY GOOD THANKS - Original Message - From: Dilip Pandey To: excel-macros@googlegroups.com Sent: 02 September, 2009 10:53 AM Subject: $$Excel-Macros$$ Re: Vlookup Value Hi Ashwin, I believe you need multiple values based on single criteria across the data

$$Excel-Macros$$ Re: Vlookup Value

Hi Ashwin, I believe you need multiple values based on single criteria across the data range. Same is done and attached herewith. Thanks -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 9/2/09, Ashwin Gopin

$$Excel-Macros$$ Re: Vlookup not working in 2007

Hi, Check the attached file 1 u have to freeze cells in the formula 2 you have to convert to numbers before applying the formula Regards Sathish Jalendran From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Mahesh Sent: 28 August 2009 PM 12:08 To

$$Excel-Macros$$ Re: Vlookup not working in 2007

thanx On Fri, Aug 28, 2009 at 2:20 PM, Sandeep wrote: > Hi Mahesh, > Find the attached solution > > Regards > Sandeep > > - Original Message - > *From:* Mahesh > *To:* excel-macros@googlegroups.com > *Sent:* Friday, August 28, 2009 12:07 PM > *Subject:* $$Excel-Macros$$ Vlookup not w

$$Excel-Macros$$ Re: vlookup help

yes, please email me at fahe...@gmail.com thanks On Aug 7, 1:06 am, fongie wrote: > Hi Osiso > > You sent me an email today with another query. > > I tried to send back to paraport email but got mail server rejections. > > Is there another email I can email you on? > > Alvin > > On Aug 6, 3:05 a

$$Excel-Macros$$ Re: vlookup help

Hi Osiso You sent me an email today with another query. I tried to send back to paraport email but got mail server rejections. Is there another email I can email you on? Alvin On Aug 6, 3:05 am, osiso wrote: > i would like to add an example of what im trying to do. please let me > know how t

$$Excel-Macros$$ Re: vlookup help

Hi Faheem, Just reply to excel-macros@googlegroups.com and include the file as an "Attachment" like we do when we sent out normal email. Alternatively, you can upload the files to the "files section" as well of the group (http://groups.google.co.in/group/excel-macros?hl=en&lnk) Thanks, -- DILIP

$$Excel-Macros$$ Re: vlookup from multiple sheet

Hello, Try : =IF(ISNA(VLOOKUP(A2;'Wrk1'!$F:$G;2;0));IF(ISNA(VLOOKUP(A2;'Wrk2'!$F:$G;2;0)) ;IF(ISNA(VLOOKUP(A2;'Wrk3'!$F:$G;2;0));"not found";VLOOKUP(A2;'Wrk3'!$F:$G;2;0));VLOOKUP(A2;'Wrk2'!$F:$G;2;0));VLOOKUP(A 2;'Wrk1'!$F:$G;2;0)) Regards. Daniel From: excel-macros@googlegroups.com [mailto

$$Excel-Macros$$ Re: vLOOKUP

Use Hlookup instead On 16/07/2009, Manoj Kukrej wrote: > > 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

$$Excel-Macros$$ Re: VLookup formula

Thanks Dilip and everyone for solving the issue. Appreciate all your knowledge !!! On Jul 16, 2:29 pm, Dilip Pandey wrote: > Hi Ayush, > > Query raised by Suresh has been answered. Thanks. > > Thanks & Best Regards, > DILipandey (Back from Holidays) > -- > DILIP KUMAR PANDEY >   MBA-HR,B COM(Ho

$$Excel-Macros$$ Re: VLookup formula

Hi All, This formula is working fine, But when i apply this formula to a very large data. It is not showing accurately. And this formula tells that it will look into only a particular cell. But i need some formula where it should search for all cells in a particular column. On Thu, Jul 16, 2009 a

$$Excel-Macros$$ Re: VLookup formula

HI EVERYBODY I CANT UNDERSTAND THE STEPS OF VLOOKUP FORMULA PLEASE SOLVE IN ATTACHED FILE VIKAS On Thu, Jul 16, 2009 at 5:03 PM, Dilip Pandey wrote: > Hey Ashish... > > Thanks a TON...!!! > > Remeber..>> "Everyone is learning here.. including me as well"..!! > > Best Regards, > DILipandey (Ba

$$Excel-Macros$$ Re: VLookup formula

Hey Ashish... Thanks a TON...!!! Remeber..>> "Everyone is learning here.. including me as well"..!! Best Regards, 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,

$$Excel-Macros$$ Re: VLookup formula

Suresh Key in this formula, this will serve. Unable to upload xls from my end. Please read alphabets as columns. *Sheet 1* ** ** *C* *D* *E* *F* Name Data Date No. Su 12 01/01/1999 123 gu 22 02/02/1999 124 gg 33 03/03/2000 125 *Sheet 2* ** ** ** ** *C* *D* *E* *F* *G* *H* Name Data Date

$$Excel-Macros$$ Re: VLookup formula

Dilipji Even though the solution to this problem was not requested by me, I must tell you that just seeing the solutions you and a few others so regularly provide have helped me understand Excel a lot more. Thanks a lot for your contributions, Dilipji and many others who help us in understanding

$$Excel-Macros$$ Re: VLookup formula

Sorry, Please find the revised file On Thu, Jul 16, 2009 at 2:27 PM, Atul Kesaria wrote: > Hello Suresh, > > Please find the attached sheet, hope this is what you are looking for. > > Thanks and Regards > Atul Kesaria > > On Thu, Jul 16, 2009 at 1:29 PM, Ayushj wrote: > >> >> Dear Members, >

$$Excel-Macros$$ Re: VLookup formula

Hello Suresh, Please find the attached sheet, hope this is what you are looking for. Thanks and Regards Atul Kesaria On Thu, Jul 16, 2009 at 1:29 PM, Ayushj wrote: > > Dear Members, > > Can anyone assist Suresh on his query ? > > Thank you. > > On Jul 16, 12:57 pm, suresh k wrote: > > Hi > >

$$Excel-Macros$$ Re: VLookup formula

Concatenate the two fields(Name & Data) in both sheets and then put Vlookup.. On Thu, Jul 16, 2009 at 1:29 PM, Ayushj wrote: > > Dear Members, > > Can anyone assist Suresh on his query ? > > Thank you. > > On Jul 16, 12:57 pm, suresh k wrote: > > Hi > > > > I have one query. > > I have data

$$Excel-Macros$$ Re: VLookup formula

Hi Ayush, Query raised by Suresh has been answered. Thanks. Thanks & Best Regards, 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 1:29 PM, Ayushj wrote:

$$Excel-Macros$$ Re: VLookup formula

Hi Suresh (Brave man) Solution is attached. Enjoy..!! This is slightly delayed as I was occupied with some other urgent project meetings. Thanks DILipandey (Back from Holidays) -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New

$$Excel-Macros$$ Re: VLookup formula

Dear Members, Can anyone assist Suresh on his query ? Thank you. On Jul 16, 12:57 pm, suresh k wrote: > 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              

$$Excel-Macros$$ Re: vlookup urgent help

Try this if it works 1. Add two columns of Party name and bill No with formula =CONCATENATE(B7,C7) in both the sheets. Party Name Bill no use formula XYZ LTD 25 =CONCATENATE(B7,C7) 2.then try the VLOOKUP if there is error in this vlookup after joining tw

$$Excel-Macros$$ Re: vlookup urgent help

Hey, Please send me the file, i'll put the formula and send it to you. Regards, Rajesh Kunder On Sat, Jun 20, 2009 at 2:24 PM, ankur wrote: > > Dear Members > > i have one problem > in one sheet there is data as > party name bill no. > amount > > there are 100

$$Excel-Macros$$ Re: vlookup urgent help

Hi Ankur, I am not sure whether i have understood your query correctly or not.What i understand is, if party name and bill no are same, then the corresponding amount is extracted in sheet 2. Based on that, i believe following is the code that you are looking for: ActiveCell.FormulaR1C1 = "=IF(VL

$$Excel-Macros$$ Re: vlookup urgent help

Hi Ankur, Do As Below : 1. In Both the Sheets, Insert one column. 2. In The column inserted, enter a formula : =PartyName & BillNo. (where Partyname is the cell for PartyName and BillNo. Is the cell for Bill No.) 3. Based on above inserted column, do the vlookup and you've done. Mer

$$Excel-Macros$$ Re: Vlookup

Hi thank u for ur explanation u r gem man regards ruchi On Fri, Jun 19, 2009 at 4:03 PM, Dave Bonallack wrote: > Hi Ruchi, > I've tried to explain the formulas in the attachment. > Regards - Dave. > > >> Hi >> >> Thank you so much thats excatly i want it >> but can u plz explain me the formula

$$Excel-Macros$$ Re: Vlookup

Hi Ruchi, I've tried to explain the formulas in the attachment. Regards - Dave. > Hi > > Thank you so much thats excatly i want it > but can u plz explain me the formula u applied? > and also 1 more thing as i m making chart of this data i want one line > at 2:30 which showz the cut off point l

$$Excel-Macros$$ Re: Vlookup

, Jun 18, 2009 at 10:44 AM, Dave Bonallack wrote: > Hi Ruchi, > Not sure I understand all your needs. > Take a look at the attached and tell me if I'm on the right track > Regards - Dave. > >> Date: Wed, 17 Jun 2009 22:38:51 +0530 >> Subject: $$Excel-Macros

$$Excel-Macros$$ Re: Vlookup

Hi Ruchi, Not sure I understand all your needs. Take a look at the attached and tell me if I'm on the right track Regards - Dave. > Date: Wed, 17 Jun 2009 22:38:51 +0530 > Subject: $$Excel-Macros$$ Re: Vlookup > From: ruchigab...@gmail.com > To: excel-macros@googleg

$$Excel-Macros$$ Re: Vlookup

Hi actually i send 1 query in the group but i hvnt get ne reply yet plz help me otherwise i will b in trouble my probs is i hv file in which i hv mention th eintervals acc. to that i want to get the frequency and avg and also i hv to make chart which showz the counts frquency as well as avg but a

$$Excel-Macros$$ Re: Vlookup

Hi oh this is gr8 thank u regards ruchi On Wed, Jun 17, 2009 at 5:17 PM, Dilip Pandey wrote: > Hi Ruchi, > > This query is related to the "linking of the files onto a excel > spreadsheet". > For example, you have some week - wise spreadsheets in your c drive (e.g. > C:\Ruchi\work).  The files m

$$Excel-Macros$$ Re: Vlookup

Hi Ruchi, This query is related to the "linking of the files onto a excel spreadsheet". For example, you have some week - wise spreadsheets in your c drive (e.g. C:\Ruchi\work). The files may have the names like (week4.xls, week5.xls, week6.xls) and so on. Now what you want to do, is to link up

$$Excel-Macros$$ Re: Vlookup

Hi Dilip can u plz help me to understand this query? plz elaborate it thanks regards ruchi On Tue, Jun 16, 2009 at 10:51 PM, Paul Schreiner wrote: > Well... the short answer is "Yes and No". > First, what does this have to do with the title "Vlookup"?? > > Your question is WAY too vague. >

$$Excel-Macros$$ Re: Vlookup

Well... the short answer is "Yes and No". First, what does this have to do with the title "Vlookup"?? Your question is WAY too vague. There can BE no files called "c:week25", "c:week26". they would have to be at a MINIMUM "C:\week25.xls", etc. Also... are they all really in the root of C:\ ??? th

$$Excel-Macros$$ Re: Vlookup

Thanks that gives me the resulting path but does not link to get the value of the path only if i paste special values hmmm stumped on this one !! cheers On Jun 16, 11:33 am, Dilip Pandey wrote: > Hi Jack, > > Many thanks for sharing the logic with us. > Look at the attached file, it may help you

  1   2   >