Re: $$Excel-Macros$$ Vlookup

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

Re: $$Excel-Macros$$ Vlookup

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

Re: $$Excel-Macros$$ Vlookup

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

Re: $$Excel-Macros$$ Vlookup

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

Re: $$Excel-Macros$$ Vlookup

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.

Re: $$Excel-Macros$$ Vlookup

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 sug

Re: $$Excel-Macros$$ Vlookup

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

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

$$Excel-Macros$$ Vlookup

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

Re: $$Excel-Macros$$ vlookup return with pcture assinged

On 10/16/11, Sam Mathai Chacko wrote: > Since Noorain and Ashish aren't around, I'll step in. The main function used > is the INDIRECT function, along with a combo Match function to return the > position of the value being searched for. > > So for example, =INDIRECT("SourcePic!A"&MATCH($A$4,Source

Re: $$Excel-Macros$$ vlookup return with pcture assinged

Hi, can u pls explain the formula being used in this sheet. On Oct 14, 9:45 pm, NOORAIN ANSARI wrote: > Dear prabhat, > > Please find attached sheet in Excel 2003 Version. > Hope it help to u > > -- > Thanks & regards, > Noorain Ansari >  *http://excelmacroworld.blogspot.com/*

Re: $$Excel-Macros$$ vlookup return with pcture assinged

The file need to run on ms excel 2003 version. Rgrds.Prabhat On Oct 14, 12:03 pm, ashish koul wrote: > see if it helps > > On Fri, Oct 14, 2011 at 9:46 AM, prabhat.shrivasta...@gmail.com < > > > > > > prabhat.shrivasta...@gmail.com> wrote: > > Good morning experts > > > Need your valueab

Re: $$Excel-Macros$$ vlookup return with pcture assinged

Dear Prabhat, Please try it and see attached sheet for reference Copy it and paste in Formula-Define Name-Referes to Indirect Formula =INDIRECT("Sheet4!B"&MATCH('Indirect Example 3'!$A$4,Sheet4!$A:$A,0)) On Fri, Oct 14, 2011 at 9:46 AM, prabhat.shrivasta...@gmail.com < prabhat.shri

$$Excel-Macros$$ vlookup return with pcture assinged

Good morning experts Need your valueable help to complete ma project, i have three n more pics in name of ram, shyam, n more pasted on diffrent sheet now i want if i write ram in a assinged cell ram's pic appear in selected area of sheet n so on. I dont wanna use macro for thisi need this

Re: $$Excel-Macros$$ vlookup for two same value in acceding order with two Criteria

See attached to do as desired From: vickey Sent: Monday, September 26, 2011 10:14 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ vlookup for two same value in acceding order with two Criteria Thanks, It worked, but there is one argument, if there are more then three

Re: $$Excel-Macros$$ vlookup for two same value in acceding order with two Criteria

Thanks, It worked, but there is one argument, if there are more then three entries in a particular day i.e. on 1st of sept there are three diffrent times mentioned or more than that, then very first and very last time should reflects. (means in time of morning and out time of evening) I have

Re: $$Excel-Macros$$ vlookup for two same value in acceding order with two Criteria

Dear Vicky, See attached sheet if it help to u.. Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/* On Sun, Sep 25, 2011 at 4:03 PM, vickey wrote: > can I ge

Re: $$Excel-Macros$$ vlookup for two same value in acceding order with two Criteria

: Deepak Pal Singh Sent: Sunday, September 25, 2011 11:09 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ vlookup for two same value in acceding order with two Criteria Sure. :-) On Sun, Sep 25, 2011 at 9:35 PM, vickey wrote: Yes, great its working can I raise

Re: $$Excel-Macros$$ vlookup for two same value in acceding order with two Criteria

Sure. :-) On Sun, Sep 25, 2011 at 9:35 PM, vickey wrote: > Yes, great its working can I raise more query/issues in case I face > during the operation... > > > > -- > > -- > Some important links for ex

Re: $$Excel-Macros$$ vlookup for two same value in acceding order with two Criteria

Yes, great its working can I raise more query/issues in case I face during the operation... -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twit

Re: $$Excel-Macros$$ vlookup for two same value in acceding order with two Criteria

5, 2011 10:32 AM > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ vlookup for two same value in acceding > order with two Criteria > > Try this one... :-) > > On Sun, Sep 25, 2011 at 8:36 PM, dguillett1 wrote: > >> I sent a solution t

Re: $$Excel-Macros$$ vlookup for two same value in acceding order with two Criteria

It appears that you properly understood the question. From: Deepak Pal Singh Sent: Sunday, September 25, 2011 10:32 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ vlookup for two same value in acceding order with two Criteria Try this one... :-) On Sun, Sep 25, 2011 at 8

Re: $$Excel-Macros$$ vlookup for two same value in acceding order with two Criteria

nday, September 25, 2011 9:40 AM > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ vlookup for two same value in acceding > order with two Criteria > > Thanks a lot I got the idea but however I am trying somthing diffrent as > per attached forward, I have u

Re: $$Excel-Macros$$ vlookup for two same value in acceding order with two Criteria

I sent a solution to what I thought was your request. Now, you have an entirely different question. Please give examples and clear logic on how to get the result. From: vickey Sent: Sunday, September 25, 2011 9:40 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ vlookup for

Re: $$Excel-Macros$$ vlookup for two same value in acceding order with two Criteria

Thanks a lot I got the idea but however I am trying somthing diffrent as per attached forward, I have used your suggested code in the field, but there is problem of updation of values if I enter employee code highlited in yellow as per sample file attached. Pleaes have a sample copy of the ide

Re: $$Excel-Macros$$ vlookup for two same value in acceding order with two Criteria

MAX(IF(($B$2:$B$22=F2),($C$2:$C$22=G2)),$D$2:$D$22),"hh:mm:ss")&")" From: vickey Sent: Sunday, September 25, 2011 5:33 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ vlookup for two same value in acceding order with two Criteria can I get values (time) of

Re: $$Excel-Macros$$ vlookup for two same value in acceding order with two Criteria

Just ask your vendor to publish data in your required format, he'll do it because your organization is paying him monthly maintenance... On Sun, Sep 25, 2011 at 4:03 PM, vickey wrote: > can I get values (time) of two same values in accedning order with two > Criteria. > for example I have emplo

$$Excel-Macros$$ vlookup for two same value in acceding order with two Criteria

can I get values (time) of two same values in accedning order with two Criteria. for example I have employee code / date & time now employee code repeates two or more times in a day with diffrent times. now what I want if I select parcticular date with particular empoyee ID then time of that

Re: $$Excel-Macros$$ vlookup , index - Reg

Hi Mothilal, Nesting limit for function(s) is 6+1 but this is not applicable in your case here. Not sure why this is happening, try attaching a sample file for better understanding of the Group. Thanks Regards, DILIPandey On 9/20/11, jmothilal wrote: > Dear Friends, > > Any limit is there vloo

Re: $$Excel-Macros$$ vlookup , index - Reg

Hi, May be there was some logical Error..because there is not limitation of this type.. On Tue, Sep 20, 2011 at 7:02 PM, jmothilal wrote: > Dear Friends, > > Any limit is there vlookup and index. because i fix the array a1: a300 > =index(b1:b300,match(a1,a1:a300,0)) some time its not work.

$$Excel-Macros$$ vlookup , index - Reg

Dear Friends, Any limit is there vlookup and index. because i fix the array a1: a300 =index(b1:b300,match(a1,a1:a300,0)) some time its not work. if lesser array its working. i am using office 2003. -- J.Mohilal Universal Computer Systems # 16, Brindavan Complex Otteri, Vellore-2 --

Re: $$Excel-Macros$$ Vlookup with more than one condition

Dear MSEXL Learner Correcting a mistake won't be treated as hurting -: I am fully agree with u but u can correct a mistake by polite way (Never create and suggest formula's based on the articles you read in internet or book, understand the concept how the functions are working and it's concept then

Re: $$Excel-Macros$$ Vlookup with more than one condition

Hi Mr. Shrinivas, Correcting a mistake won't be treated as hurting and if you feel like that then it's your way of thought and I don't want to comment about it. Real experts never like to see wrong answers getting delivered to the questioners and that was I did. If I am providing a wrong solutio

Re: $$Excel-Macros$$ Vlookup with more than one condition

Dear All I am a member of this group for last more than 2 years. I can proudly say that u will find the solutions(not solution) for all u r problem. By reading the above mail (from Noorani and Excel Learner) I got some different feeling.So my suggestion is dont critise any one Dont write any mail w

Re: $$Excel-Macros$$ Vlookup with more than one condition

I am tired... --- Ms.Exl.Learner --- On Fri, Sep 2, 2011 at 11:48 PM, NOORAIN ANSARI wrote: > Dear MS.EXL.Learner, > > Please see attached sheet... > ** > Dear i better understand work and Concept of below mentio

Re: $$Excel-Macros$$ Vlookup with more than one condition

Dear MS.EXL.Learner, Please see attached sheet... ** Dear i better understand work and Concept of below mentioned functionsi never denied to differencition between each functions. but at a time we can use a function for multiple purpose. * *

Re: $$Excel-Macros$$ Vlookup with more than one condition

Hi Noorain Ansari, Case-1 I have attached the same file for your reference and I have not changed anything on it just created a duplicate data. Now look at the excel file and see what are all the results your formula is deriving. Whether all the results are same? Take my previous mail and read

Re: $$Excel-Macros$$ Vlookup with more than one condition

Dear Ms-Exl-Learner, Thanks for your valuable suggestion.. Case -I, In case of duplicay all formulas are successfull working except vlookup(vlookup) example. You can see fresh attachement.. Case -II, You can't compare Sumproduct with If function both are different.. Correct Syntex of Formula Sho

Re: $$Excel-Macros$$ Vlookup with more than one condition

Hi Noorain Ansari, It might be better if you might have constructed your example data with some duplicates, since the questioner can able to understand the difference between the *[vlookup, Index-Match, Offset-Match]* and *[Sumproduct, Sumifs, Dsum]*. The *First set of formula's / Functions* just

Re: $$Excel-Macros$$ Vlookup with more than one condition

Dear Haytham, Please try below formula : *=VLOOKUP(J3&K3,$E$3:$H$3,4,0)* *=VLOOKUP(VLOOKUP($J$3,$F$3:$G$8,2,0),$G$3:$H$8,2,0)* other Alternative... *=SUMPRODUCT((F3=J3)*(G3=K3)*H3)* *{=INDEX($H$3:$H$8,MATCH(1,($F$3:$F$8=$J$3)*($G$3:$G$8=$K$3),0))}* *{=OFFSET($H$2,MATCH(1,($F$3:$F$8=$J$3)*($G

Re: $$Excel-Macros$$ Vlookup with more than one condition

-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Vlookup with more than one condition Dear Haytham, See sample...If Helps.. *Best Regards,* *Venkat * *Chennai* *My Linked in profile <http://in.linkedin.com/pub/venkatesan-c/21/492/a71>* On Fri, Sep 2, 2011 at 7:07 PM, Venkat CV

Re: $$Excel-Macros$$ Vlookup with more than one condition

Dear Haytham, See sample...If Helps.. *Best Regards,* *Venkat * *Chennai* *My Linked in profile * On Fri, Sep 2, 2011 at 7:07 PM, Venkat CV wrote: > Dear Haytham, > > Try SUMPRODUCT... > > > *Best Regards,* > *Venkat * > *Chennai* > *My Li

Re: $$Excel-Macros$$ Vlookup with more than one condition

Dear Haytham, Try SUMPRODUCT... *Best Regards,* *Venkat * *Chennai* *My Linked in profile * On Fri, Sep 2, 2011 at 5:02 PM, Haytham Zoromba wrote: > Dear all, > > I have tried to search about using vlookup with more than one condition. > > Is

$$Excel-Macros$$ Vlookup with more than one condition

Dear all, I have tried to search about using vlookup with more than one condition. Is their any one know a formula for that? BRegards, Haytham Zoromba -- -- Some important links for excel users: 1. Follow us on TW

Re: $$Excel-Macros$$ Vlookup with 2 criteria

Dear All Rally thanks for Kind help Shrinivas On Wed, Aug 31, 2011 at 9:20 PM, NOORAIN ANSARI wrote: > Dear Shrinivas, > > Please see attached sheet.. > > *=VLOOKUP(H6&I6,A4:D8,4,0)* > Alternative solutions... > > *{=INDEX(D4:D8,MATCH(1,(B4:B8=H6)*(C4:C8=I6),0))} > {=OFFSET(D3,MATCH(1,(B4:B8=H6)*

Re: $$Excel-Macros$$ Vlookup with 2 criteria

Dear Shrinivas, Please see attached sheet.. *=VLOOKUP(H6&I6,A4:D8,4,0)* Alternative solutions... *{=INDEX(D4:D8,MATCH(1,(B4:B8=H6)*(C4:C8=I6),0))} {=OFFSET(D3,MATCH(1,(B4:B8=H6)*(C4:C8=I6),0),0)}* *=DSUM(B3:D8,D3,H5:I6)* -- Thanks & regards, Noorain Ansari *http://noorain-ansari.blogspot.com/*

RE: $$Excel-Macros$$ Vlookup with 2 criteria

Subject: $$Excel-Macros$$ Vlookup with 2 criteria Dear all Can I use Vlookup with 2 criteria? If Yes please let me know -- Shrini -- -- Some important links for excel users: 1. Follow us on TWITTER for tips

RE: $$Excel-Macros$$ Vlookup with 2 criteria

You can use this : =SUM((C3:C5=G3)*(D3:D5=H3)*(E3:E5)) From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Venkat CV Sent: Wednesday, August 31, 2011 12:26 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Vlookup with 2 criteria Hi

Re: $$Excel-Macros$$ Vlookup with 2 criteria

Hi Srinivas, Try the formula...and look attached sample... *=SUMPRODUCT(($C$3:$C$5=G3)*($D$3:$D$5=H3)*($E$3:$E$5))* On Tue, Aug 30, 2011 at 11:43 PM, Shrinivas Shevde wrote: > Dear all > Can I use Vlookup with 2 criteria? > If Yes please let me know > > > -- > Shrini > > -- > > --

Re: $$Excel-Macros$$ VLOOKUP or Similiar

I think you could insert a new column A and use 1,2,3.1000 to label rows From: NOORAIN ANSARI To: excel-macros@googlegroups.com Sent: Sunday, August 28, 2011 7:18 PM Subject: Re: $$Excel-Macros$$ VLOOKUP or Similiar Dear Cab, If possible please provide a sample sheet.. On Mon, Aug 29

Re: $$Excel-Macros$$ VLOOKUP or Similiar

Hi Noorain I have tried it using normal vlookup and it works great.I thought that in the column that the number is searched in had to be a column with no blanks. I had not tried when I sent email. Have tried now and it is ok. Apologies for taking up your time. Regards Charlie On Mon, Aug

Re: $$Excel-Macros$$ VLOOKUP or Similiar

Dear Cab, If possible please provide a sample sheet.. On Mon, Aug 29, 2011 at 4:22 AM, Cab Boose wrote: > 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 functi

$$Excel-Macros$$ VLOOKUP or Similiar

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 n

Re: $$Excel-Macros$$ Vlookup against the value generated from formula

Dear Subhash, You need to use trim command on group code in both sheets...your problem will be resolved. ...Still if you are not able to handle do revert. Regards Mukesh Gupta On Mon, Jul 25, 2011 at 6:37 PM, Subhash Yadav wrote: > When I m tryi

Re: $$Excel-Macros$$ Vlookup against the value generated from formula

thanks noorain.. On Thu, Aug 18, 2011 at 2:27 PM, NOORAIN ANSARI wrote: > Please see below link. > http://www.xldynamic.com/source/xld.SUMPRODUCT.html > > On Thu, Aug 18, 2011 at 2:18 PM, XLS S wrote: >> >> Ok...can you give me more information about "--"... >> >> D

Re: $$Excel-Macros$$ Vlookup against the value generated from formula

Please see below link. http://www.xldynamic.com/source/xld.SUMPRODUCT.html On Thu, Aug 18, 2011 at 2:18 PM, XLS S wrote: > Ok...can you give me more information about "--"... > > Did I use this function anywhere? > > On Thu, Aug 18, 2011 at 2:11 PM, NOORAIN ANSARI >

Re: $$Excel-Macros$$ Vlookup against the value generated from formula

Ok...can you give me more information about "--"... Did I use this function anywhere? On Thu, Aug 18, 2011 at 2:11 PM, NOORAIN ANSARI wrote: > Hi XLS, > > -- use for absolute value > > other way is this.. > =VLOOKUP(C5+0,Sheet3!$A$1:$D$403,4,FALSE) > > On Thu, Aug 18, 201

Re: $$Excel-Macros$$ Vlookup against the value generated from formula

Hi XLS, -- use for absolute value other way is this.. =VLOOKUP(C5+0,Sheet3!$A$1:$D$403,4,FALSE) On Thu, Aug 18, 2011 at 1:55 PM, XLS S wrote: > Hey Noorain, > > can you tell me what is the mean of ++ and -- > > > > > > On Thu, Aug 18, 2011 at 10:20 AM, NOORAIN ANSARI > wrote: > > Dear

Re: $$Excel-Macros$$ Vlookup against the value generated from formula

Hey Subhash, also use vlookup with value function, On Mon, Jul 25, 2011 at 6:37 PM, Subhash Yadav wrote: > When I m trying to use to formula VLOOKUP against any formula generated > value, there is error. > Please suggest suitable method for the same, as I have to take many of the > value based n

Re: $$Excel-Macros$$ Vlookup against the value generated from formula

Hey Noorain, can you tell me what is the mean of ++ and -- On Thu, Aug 18, 2011 at 10:20 AM, NOORAIN ANSARI wrote: > Dear Subhash, > > Please try it... > =VLOOKUP(--C5,Sheet3!$A$1:$D$403,4,FALSE) > > > -- > Thanks & regards, > Noorain Ansari > http://noorain-ansari.blogspot.com/ > On Mon, Ju

Re: $$Excel-Macros$$ Vlookup against the value generated from formula

Dear Subhash, Please try it... =VLOOKUP(--C5,Sheet3!$A$1:$D$403,4,FALSE) -- Thanks & regards, Noorain Ansari *http://noorain-ansari.blogspot.com/* On Mon, Jul 25, 2011 at 6:37 PM, Subhash Yadav wrote: > When I m trying to use to formula VLOOKUP against a

Re: $$Excel-Macros$$ Vlookup Including Cell Comments..

glegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Venkat CV > *Sent:* Wednesday, August 03, 2011 2:09 PM > > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Vlookup Including Cell Comments.. > > ** ** > > Hi Rajan, > >

RE: $$Excel-Macros$$ Vlookup Including Cell Comments..

: $$Excel-Macros$$ Vlookup Including Cell Comments.. Hi Rajan, Thanks for reply How can i give the inputs In Input boxes. Please explain Best Regards, Venkat Chennai On Wed, Aug 3, 2011 at 1:27 PM, Rajan_Verma wrote: See if it Helps : Sub VlookupByCodes() Dim

Re: $$Excel-Macros$$ Vlookup Including Cell Comments..

Boolean* > > *On Error GoTo err:* > > *If cell.Comment.Text <> "" Then* > > *hasComment = True* > > *Else* > > *hasComment = False* > > *End If* > > *err:* > > *If err.Number <> 0 Then* > > *hasComment = False* > &g

Re: $$Excel-Macros$$ Vlookup Including Cell Comments..

Dear Ashish, Find attached Sample Worksheet with my requiremnt.. *Best Regards,* *Venkat* *Chennai* On Wed, Aug 3, 2011 at 12:01 PM, ashish koul wrote: > can you attach the worksheet > > > On Wed, Aug 3, 2011 at 11:11 AM, Venkat CV wrote: > >> Dear All, >> >> Let me know how to Vlookup Includ

Re: $$Excel-Macros$$ Vlookup Including Cell Comments..

can you attach the worksheet On Wed, Aug 3, 2011 at 11:11 AM, Venkat CV wrote: > Dear All, > > Let me know how to Vlookup Including Cell Comments..in Each Cells... > > > > *Best Regards,* > *Venkat* > *Chennai* > * > * > * > * > > > -- > > ---

RE: $$Excel-Macros$$ Vlookup against the value generated from formula

Use this =VLOOKUP(VALUE(C5),Sheet3!$A$1:$D$403,4,FALSE) From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Subhash Yadav Sent: Monday, July 25, 2011 6:38 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Vlookup against the value generated

$$Excel-Macros$$ Vlookup against the value generated from formula

When I m trying to use to formula VLOOKUP against any formula generated value, there is error. Please suggest suitable method for the same, as I have to take many of the value based n these types of conditions. Sample file attached. -- Subhash Chand Yadav -- -

$$Excel-Macros$$ vlookup 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~~ -- Forwarded message -- From: ankur Date: Mon, Jul 11, 2011 at 4:38 PM Subject: Re: $$Excel-Macros$$ vlookup query To: PRADEEP KUMAR KOKNE

Re: $$Excel-Macros$$ vlookup query

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,

Re: $$Excel-Macros$$ vlookup query

*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, PRAD

Re: $$Excel-Macros$$ Vlookup Query

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

Re: $$Excel-Macros$$ Vlookup Query

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

Re: $$Excel-Macros$$ Vlookup Query

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

Re: $$Excel-Macros$$ vlookup query

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 ex

$$Excel-Macros$$ Vlookup Query

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 co

$$Excel-Macros$$ vlookup query

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

RE: $$Excel-Macros$$ Vlookup Query-2

See if it help From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Jai Sent: Wednesday, July 06, 2011 4:37 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Vlookup Query-2 Hello Experts I Have a one Qurery Please Check the attachment

RE: $$Excel-Macros$$ Vlookup Regarding Query Please Help

"*" Character will find the value which start with Following Characters. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of ankur Sent: Wednesday, July 06, 2011 4:07 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Vlookup Regar

Re: $$Excel-Macros$$ Vlookup Query-2

Dear Jai, Please find solution of 2nd Query... =VLOOKUP("*"&C6&"*",Sheet1!B4:C10,2,0) See attached sheet. -- Thanks & regards, Noorain Ansari *http://noorain-ansari.blogspot.com/* On Wed, Jul 6, 2011 at 4:37 PM, Jai wrote: > Hello Experts > > I Have a on

RE: $$Excel-Macros$$ Vlookup Query-2

Hello, Can you explain a bit more ? Regards. Daniel De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de Jai Envoyé : mercredi 6 juillet 2011 13:07 À : excel-macros@googlegroups.com Objet : $$Excel-Macros$$ Vlookup Query-2 Hello Experts I

$$Excel-Macros$$ Vlookup Query-2

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 gro

Re: $$Excel-Macros$$ Vlookup Regarding Query Please Help

THIS Realy Good Formula Thaks On Wed, Jul 6, 2011 at 3:49 PM, NOORAIN ANSARI wrote: > Dear Jai, > > Please try it without helping column.. > > =VLOOKUP(B7&"*",Sheet1!B7:C12,2,) > > > Thanks & regards, > Noorain Ansari > *http://noorain-ansari.blogspot.com/* >

Re: $$Excel-Macros$$ Vlookup Regarding Query Please Help

It's great...!!! *--- кαяαηη* On Wed, Jul 6, 2011 at 3:49 PM, NOORAIN ANSARI wrote: > Dear Jai, > > Please try it without helping column.. > > =VLOOKUP(B7&"*",Sheet1!B7:C12,2,) > > > Thanks & regards, > Noorain Ansari > *http://noorain-ansari.blogspot.com/*

Re: $$Excel-Macros$$ Vlookup Regarding Query Please Help

Very intelligent solution by Noorain.. Jai, I am giving another solution =VLOOKUP(IF(FIND(B17,Sheet1!B5,1),"*"&B17&"*",0),Sheet1!$B$5:$C$10,2,0) Try this, it will search "RAM" or "ROH" in total string and show result. "RAM or "ROH" could be anywhere in the string. On Wed, Jul 6, 201

Re: $$Excel-Macros$$ Vlookup Regarding Query Please Help

Thanks of Lot Sir On Wed, Jul 6, 2011 at 3:42 PM, ankur wrote: > *hi jai > find the attached filethis has slight modification of venkatesan > solution...the repeat of name is taken care , as u required tell me it > helps? > *Have A Nice Time & Enjoy Life > > Regards: > CMA Ankur Pa

Re: $$Excel-Macros$$ Vlookup Regarding Query Please Help

hi Noorain Ansari very good formula.can u explain me what "*" had make difference in this formula. use of "*" in formula had done what magic..i will also use this in other formulas in future Have A Nice Time & Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best bu

Re: $$Excel-Macros$$ Vlookup Regarding Query Please Help

Dear Jai, Please try it without helping column.. =VLOOKUP(B7&"*",Sheet1!B7:C12,2,) Thanks & regards, Noorain Ansari *http://noorain-ansari.blogspot.com/* On Wed, Jul 6, 2011 at 2:19 PM, Jai wrote: > -- > > ---

Re: $$Excel-Macros$$ Vlookup Regarding Query Please Help

*hi jai find the attached filethis has slight modification of venkatesan solution...the repeat of name is taken care , as u required tell me it helps? *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 Wed, Jul 6,

Re: $$Excel-Macros$$ Vlookup Regarding Query Please Help

Hi Jai, Look Attached below.. On Wed, Jul 6, 2011 at 2:19 PM, Jai wrote: > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailyti

$$Excel-Macros$$ Vlookup Regarding Query Please 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 tutor

Re: $$Excel-Macros$$ VLOOKUP(H17,[231.xls]Sheet1!$I$5:$K$20,H$15,0)

11 18:04:26 +0530 > *To: *Pravin Kumar; > > *Subject: *Re: $$Excel-Macros$$ > VLOOKUP(H17,[231.xls]Sheet1!$I$5:$K$20,H$15,0) > > Dear Pravin, > > Please try it. > > =IFERROR(VLOOKUP(H17,[SCWK23134 > .xls]Sheet1!$I$5:$K$20,H$15,0),IFERROR(VLOOKUP

Re: $$Excel-Macros$$ VLOOKUP(H17,[231.xls]Sheet1!$I$5:$K$20,H$15,0)

My friend I'll have data for all 34 35-53 soi there will be no error Sent on my BlackBerry® from Vodafone -Original Message- From: NOORAIN ANSARI Date: Thu, 5 May 2011 18:04:26 To: Pravin Kumar; Subject: Re: $$Excel-Macros$$ VLOOKUP(H17,[231.xls]Sheet1!$I$5:$K$20,H$15,0) Dear P

Re: $$Excel-Macros$$ VLOOKUP(H17,[231.xls]Sheet1!$I$5:$K$20,H$15,0)

You can use Indirect Function for the same... VLOOKUP(H17,indirect(SC231WK34.xls]Sheet1!")$I$5:$K$20,H$15,0) On Thu, May 5, 2011 at 12:47 PM, Pravin Kumar wrote: > > Folk > > I have different workbook with different name in different folder. the > workbook name will be like SC231WK34, SC231WK35,

RE: $$Excel-Macros$$ VLOOKUP(H17,[231.xls]Sheet1!$I$5:$K$20,H$15,0)

with INDIRECT before. Regards - Dave Date: Thu, 5 May 2011 18:04:26 +0530 Subject: Re: $$Excel-Macros$$ VLOOKUP(H17,[231.xls]Sheet1!$I$5:$K$20,H$15,0) From: noorain.ans...@gmail.com To: pravin.si...@gmail.com; excel-macros@googlegroups.com Dear Pravin, Please try it.

Re: $$Excel-Macros$$ VLOOKUP(H17,[231.xls]Sheet1!$I$5:$K$20,H$15,0)

Dear Pravin, Please try it. =IFERROR(VLOOKUP(H17,[SCWK23134 .xls]Sheet1!$I$5:$K$20,H$15,0),IFERROR(VLOOKUP(H17,[SC231WK35 .xls]Sheet1!$I$5:$K$20,H$15,0),IFERROR(VLOOKUP(H17,[SC231WK36 .xls]Sheet1!$I$5:$K$20,H$15,0),""))) On Thu, May 5, 2011 at 12:47 PM, Pravin Kumar wrote: >

$$Excel-Macros$$ VLOOKUP(H17,[231.xls]Sheet1!$I$5:$K$20,H$15,0)

Folk I have different workbook with different name in different folder. the workbook name will be like SC231WK34, SC231WK35, SC231WK36 etc. all the sheet will be in the same format. is there any way to write vlookup where I can link the part of the name to any of cell. VLOOKUP(H17,[SC231WK34.xls]

Fwd: $$Excel-Macros$$ Vlookup in master file through Macro

Dear all, any help possible on mentioned subject? Thanks Regards, Hemant -- Forwarded message -- From: Hems Date: Sun, Mar 13, 2011 at 12:35 AM Subject: $$Excel-Macros$$ Vlookup in master file through Macro To: excel-macros@googlegroups.com Dear All, I want to update the

$$Excel-Macros$$ Vlookup in master file through Macro

Dear All, I want to update the status in master file from various users. The user files are located in particular folder but the count and name of these user is not define. Hence all records in master file should search all the user file (in same folder and in same format) and update the status t

Re: $$Excel-Macros$$ Vlookup in Macro

ps.com > > *Date: *Fri, 10 Dec 2010 10:02:19 +0530 > > *To: * > > *ReplyTo: *excel-mac...@googlegroups.com > > *Subject: *$$Excel-Macros$$ Vlookup in Macro > > > hi group, > > > In the following vlookup code in macro, if any object is #N/A in the rng > > th

<    1   2   3   4   5   >