Re: $$Excel-Macros$$ Vlookup Sensitive Case

Guys, Any function of "*Vlookup*" & "*Code*" for the same ??? On Monday, August 8, 2016 at 8:57:54 PM UTC+5:30, sourav devrani wrote: > > Hi Sachin you can also use this one. > > Regards > Sourav Devrani > > On Mon, Aug 8, 2016 at 12:24 AM, Devendra Sahay > wrote: > >> Hi Sachin, >> >> You can

Re: $$Excel-Macros$$ Vlookup Sensitive Case

Hi Sachin you can also use this one. Regards Sourav Devrani On Mon, Aug 8, 2016 at 12:24 AM, Devendra Sahay < devendrasahanypt...@gmail.com> wrote: > Hi Sachin, > > You can also try this one- =SUMPRODUCT(EXACT($F$4,$B$5:$B$11) * > ($C$5:$C$11)) > > Please change the ref. accordingly. > > On Mon,

Re: $$Excel-Macros$$ Vlookup Sensitive Case

Hi Sachin, You can also try this one- =SUMPRODUCT(EXACT($F$4,$B$5:$B$11) * ($C$5:$C$11)) Please change the ref. accordingly. On Mon, Aug 8, 2016 at 12:52 PM, NOORAIN ANSARI wrote: > Dear Sachin, > > Please try it... > > =VLOOKUP(E6,CHOOSE({1,2},IF(EXACT($B$6:$B$9,E6),$B$6:$B$9, > ""),$C$6:$C$9

Re: $$Excel-Macros$$ Vlookup Sensitive Case

Dear Sachin, Please try it... =VLOOKUP(E6,CHOOSE({1,2},IF(EXACT($B$6:$B$9,E6),$B$6:$B$9,""),$C$6:$C$9),2,0) and press Ctrl+Shift+Enter See attachment for more clarity On Mon, Aug 8, 2016 at 12:25 PM, सचिन शर्मा wrote: > Dear All, > > Kindly help to resolve the attached file of Sensitive Case.

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

dear Ronsmithcan, use below formula =VLOOKUP(CLEAN(SUBSTITUTE(B3,CHAR(160),CHAR(17))),E:F,2,FALSE) Regards, Gawli Anil On Sun, May 22, 2016 at 4:21 PM, 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 manua

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

Hi, in lookup value, at end " " is available. to clear this use the following formula =CLEAN(SUBSTITUTE(B3,CHAR(160),CHAR(17))) Regards, A Gowrisankar ​ On Sun, May 22, 2016 at 4:21 PM, Bill Q wrote: > Hi, > > PSA. > > Trying to do a simple vlookup. I cleaned up the data by trimming, but > st

Re: $$Excel-Macros$$ VLOOKUP Query

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 Vlook

Re: $$Excel-Macros$$ VLOOKUP NOT WORKING

>> ----------------- >> >> -- >> *From:* abhishek bhalla >> *To:* excel-...@googlegroups.com >> *Sent:* Wednesday, October 7, 2015 5:57 AM >> *Subject:* Re: $$Excel-Macros$$ VLOOKUP NOT WORKING >>

Re: $$Excel-Macros$$ VLOOKUP NOT WORKING

_p...@att.net Sent: Friday, October 9, 2015 1:12 PM Subject: Re: $$Excel-Macros$$ VLOOKUP NOT WORKING On Wednesday, 7 October 2015 16:03:31 UTC+5, Paul Schreiner wrote: Is this related to "VLOOKUP NOT WORKING"? I suspect you've "hijacked" Izhar's thread. see forum

Re: $$Excel-Macros$$ VLOOKUP NOT WORKING

he places you can,At all the times you can,To all the people > you can,As long as ever you can.” - John Wesley* > - > > -- > *From:* abhishek bhalla > > *To:* excel-...@googlegroups.com > *Sent:* Wednesday, Octobe

Re: $$Excel-Macros$$ VLOOKUP NOT WORKING

halla To: excel-macros@googlegroups.com Sent: Wednesday, October 7, 2015 5:57 AM Subject: Re: $$Excel-Macros$$ VLOOKUP NOT WORKING Hi all, I want to combine data from different cells into a single. For example: A apple A ant A antique B bat B big I would like to collate data l

Re: $$Excel-Macros$$ VLOOKUP NOT WORKING

In your formula: =VLOOKUP(B4,DATASET,7,FALSE) The range DATASET contains column A:G VLOOKUP(Bmeans that it's comparing the value in column B to the value in column A of sheet2.There are no matches. you need to change it to:=VLOOKUP(A4,DATASET,7,FALSE)it was probably copied from column F, whic

Re: $$Excel-Macros$$ VLOOKUP NOT WORKING

pls share the work sheet On Wed, Oct 7, 2015 at 3:27 PM, abhishek bhalla < bhalla_abhis...@rediffmail.com> wrote: > Hi all, > > > > I want to combine data from different cells into a single. For example: > > > > A apple > > A ant > > A antique > > B bat > > B big > > > > I would like to collate d

Re: $$Excel-Macros$$ VLOOKUP NOT WORKING

Hi all, I want to combine data from different cells into a single. For example: A apple A ant A antique B bat B big I would like to collate data like: A apple, ant, antique B bat, big The letters and words should be in separate columns. Please help I need it urgent. Regards Abhishek Bhalla

Re: $$Excel-Macros$$ VLOOKUP NOT WORKING

Pls try it... *=VLOOKUP(A4,SHEET2!$A$1283:$G$1308,7,0)* On Wed, Oct 7, 2015 at 10:27 AM, Izhar wrote: > in the workbook, i have two worksheet i.e. SHEET1 & SHEET2, i want to look > the quantity in SHEET2 which does not exist in SHEET1, i applied a formula > but does not work, please look at it

Re: $$Excel-Macros$$ Vlookup query

-- is used to convert it to numeric value it can give the result of true to 1 and false to 0. you were not getting the result just because the numbers are stored as text which you are getting from the formula. Regards, MandeepBaluja Learningzmypassion. https://www.facebook.com/groups/825221420

Re: $$Excel-Macros$$ Vlookup query

Dear Ashish, Thanks for reply. Problem solved but I want to know ,what differece (-- ) this makes. Can you explain it please Regards Shrinivas On Sat, Jun 13, 2015 at 5:33 PM, Ashish Bhalara wrote: > Make a little changes in your formula as mention below, then lookup on > that value. > =--MID(

Re: $$Excel-Macros$$ Vlookup query

Make a little changes in your formula as mention below, then lookup on that value. =--MID(A9,FIND(1,A9,1),6) On Sat, Jun 13, 2015 at 1:07 PM, Shrinivas Shevde wrote: > > 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

Re: $$Excel-Macros$$ VLOOKUP QUEARY

Thanks Mandeep. -- 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, Urgen

Re: $$Excel-Macros$$ VLOOKUP QUEARY

Awesome ashish On Tuesday, November 11, 2014 1:11:31 PM UTC+5:30, Ashish Kumar wrote: > > Hi Saleem, > > PFA > > > Regards > Ashish > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.face

Re: $$Excel-Macros$$ VLOOKUP QUEARY

Hi Saleem, PFA Regards Ashish -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Pl

Re: $$Excel-Macros$$ VLOOKUP AND HLOOKUP and MACROS

s 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:* Kumar Kishore >> *To:* excel-macros@googlegroups

Re: $$Excel-Macros$$ VLOOKUP AND HLOOKUP and MACROS

l 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:* Kumar Kishore > *To:* excel-macros@googlegroups.com > *Sent:* Tuesday, October

Re: $$Excel-Macros$$ VLOOKUP AND HLOOKUP and MACROS

ou 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: Kumar Kishore >To: excel-macros@googlegroups.com >Sent: Tuesday, October 7

Re: $$Excel-Macros$$ VLOOKUP AND HLOOKUP and MACROS

Dear Sirs, Thank you so much. I Will learn from you. from today onwards. Regards, Kishore. On Mon, Oct 6, 2014 at 5:23 PM, Paul Schreiner wrote: > I can probably handle explaining Vlookup and Hlookup, > but to teach "macros"??? > > That's what this group is for! > The techniques of using macr

Re: $$Excel-Macros$$ VLOOKUP AND HLOOKUP and MACROS

I can probably handle explaining Vlookup and Hlookup, but to teach "macros"??? That's what this group is for! The techniques of using macros is a subject about which many books have been written and thousands (and thousands) of emails have been shared. There's really no single way to "teach ma

Re: $$Excel-Macros$$ Vlookup Issue

cheers!! On Tue, Sep 2, 2014 at 10:28 AM, Sunil Kumar Yadav wrote: > thank u so much...it's working completely. > > > *Thanks & Regards,Sunil Kumar Yadav* > > > On Mon, Sep 1, 2014 at 6:48 PM, Vaibhav Joshi wrote: > >> Check this.. >> >> Cheers!! >> >> >> On Mon, Sep 1, 2014 at 6:36 PM, Sunil

Re: $$Excel-Macros$$ Vlookup Issue

thank u so much...it's working completely. *Thanks & Regards,Sunil Kumar Yadav* On Mon, Sep 1, 2014 at 6:48 PM, Vaibhav Joshi wrote: > Check this.. > > Cheers!! > > > On Mon, Sep 1, 2014 at 6:36 PM, Sunil Kumar Yadav > wrote: > >> Hello Friends, >> >> i have a query, please guide me. >> >> i

Re: $$Excel-Macros$$ VLookup file reference using VBA

t; > *“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:* Nitin Balodi > *To:* "exce

RE: $$Excel-Macros$$ VLookup file reference using VBA

Hi Paul and Vaibhav, Thanks, it worked by giving spaces. Regards. Yours Sincerely,Nitin Balodi Date: Mon, 25 Aug 2014 05:45:45 -0700 From: schreiner_p...@att.net Subject: Re: $$Excel-Macros$$ VLookup file reference using VBA To: excel-macros@googlegroups.com The syntax error is probably because

Re: $$Excel-Macros$$ VLookup file reference using VBA

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: Nitin Balodi >To: "excel-macros@googlegroups.com" >Sent: Monday

RE: $$Excel-Macros$$ VLookup file reference using VBA

Hi Vaibhav, I had used this but it is still showing syntax error. Regards. Yours Sincerely,Nitin Balodi From: v...@vabs.in Date: Mon, 25 Aug 2014 17:45:09 +0530 Subject: Re: $$Excel-Macros$$ VLookup file reference using VBA To: excel-macros@googlegroups.com try: ActiveCell.FormulaR1C1

Re: $$Excel-Macros$$ VLookup file reference using VBA

.FormulaR1C1 = _ > "=VLOOKUP(RC[-3],'["&wrkbk&"]Sheet1'!C1:C8,8,0)" > > > Value of WrkBk is *ForecastLastUpdated_18 July 2014 15.45.xlsx* > > > Regards. > > Yours Sincerely, > *Nitin Balodi* > > > ---

RE: $$Excel-Macros$$ VLookup file reference using VBA

itin Balodi Date: Mon, 25 Aug 2014 16:25:31 +0530 Subject: Re: $$Excel-Macros$$ VLookup file reference using VBA From: v...@vabs.in To: excel-macros@googlegroups.com Hi Use: ActiveCell.FormulaR1C1 = _ "=VLOOKUP(RC[-3],'["&wrkbk&".xlsx]Sheet1'!C1:C8,8,0)"

Re: $$Excel-Macros$$ VLookup file reference using VBA

In order to understand what you're doing and work through your question, you need to understand what VBA is doing.   Your VBA line:   ActiveCell.FormulaR1C1 = _ "=VLOOKUP(RC[-3],'[ForecastLastUpdated_18 July 2014 15.45.xlsx]Sheet1'!C1:C8,8,0)" is essentially : ActiveCell.FormulaR1C1 = "some strin

Re: $$Excel-Macros$$ VLookup file reference using VBA

Hi Use: ActiveCell.FormulaR1C1 = _ "=VLOOKUP(RC[-3],'["&wrkbk&".xlsx]Sheet1'!C1:C8,8,0)" Cheers On Aug 25, 2014 4:18 PM, "Nitin Balodi" wrote: > Hi All, > > > > I have two files: File1 and File2. > > > > I need to apply Vlookup in File1 using references from File2. > > I have stored n

Re: $$Excel-Macros$$ Vlookup get numbers from different table

thanks vabs brother On Fri, May 2, 2014 at 12:20 PM, Vaibhav Joshi wrote: > Great work!! > > > On Fri, May 2, 2014 at 12:13 PM, amar takale wrote: >> >> thanks vabs brother >> >> I try to solve this issue & I wish to share this sheet with you. >> >> Regards >> Amar >> >> On Thu, May 1, 2014 at 1

Re: $$Excel-Macros$$ Vlookup get numbers from different table

Great work!! On Fri, May 2, 2014 at 12:13 PM, amar takale wrote: > thanks vabs brother > > I try to solve this issue & I wish to share this sheet with you. > > Regards > Amar > > On Thu, May 1, 2014 at 10:57 AM, Vaibhav Joshi wrote: > > Hi Amar, > > > > Yes it is possible, but Excel Name doesn

Re: $$Excel-Macros$$ Vlookup get numbers from different table

thanks vabs brother I try to solve this issue & I wish to share this sheet with you. Regards Amar On Thu, May 1, 2014 at 10:57 AM, Vaibhav Joshi wrote: > Hi Amar, > > Yes it is possible, but Excel Name doesnt accept spaces in between hence you > will be required to do more work to get it done.

Re: $$Excel-Macros$$ Vlookup get numbers from different table

Hi Amar, Yes it is possible, but Excel Name doesnt accept spaces in between hence you will be required to do more work to get it done. See att for ref. Cheers On Wed, Apr 30, 2014 at 6:11 PM, amar takale wrote: > Dear Vabs > > I have just idea for this issue but i dont know it is work or not

Re: $$Excel-Macros$$ Vlookup get numbers from different table

Dear Vabs I have just idea for this issue but i dont know it is work or not.If we give name range each table then formula like = name range match then vlookup search that value into that specific table only. how to write formula as per my idea OR it is possible? Regards Amar On Wed, Apr 30, 201

Re: $$Excel-Macros$$ Vlookup get numbers from different table

Dear Vabs, Super ... On Wednesday, 30 April 2014 12:23:46 UTC+5:30, amar takale wrote: > > Dear Vabs Brother > > Its really cool formula which you have sent me… There was a glow in my > face > > Thanks very very muchfor helping excel enthusiasts > voluntarily !! > > Regards

Re: $$Excel-Macros$$ Vlookup get numbers from different table

Dear Vabs Brother Its really cool formula which you have sent me… There was a glow in my face Thanks very very muchfor helping excel enthusiasts voluntarily !! Regards Amar On Tue, Apr 29, 2014 at 8:56 PM, Vaibhav Joshi wrote: > Hi, > > PFA > > Cheers!! > > > On Tue, Apr 29, 2

Re: $$Excel-Macros$$ Vlookup get numbers from different table

Hi, PFA Cheers!! On Tue, Apr 29, 2014 at 5:01 PM, amar takale wrote: > Dear friends > > I required output through vlookup from different table but it is > possible only for one table.How to get all numbers from each table > with data validation.PFA sheet. > > Pls suggest me any idea or other

Re: $$Excel-Macros$$ Vlookup problem

Share your workbook plz Thanks & regards, www.MrExcel4U.com On Thu, Mar 6, 2014 at 3:55 PM, Dileep Kumar wrote: > Hi Manish, > > Will you please elobrate with example data. > > > On Thu, Mar 6, 2014 at 3:52 PM, manish jaiswal > wrote: > >> >> using vlookup an

Re: $$Excel-Macros$$ Vlookup problem

Hi Manish, Will you please elobrate with example data. On Thu, Mar 6, 2014 at 3:52 PM, manish jaiswal wrote: > > using vlookup and requirement is pick data from other sheet. > I have data in 10 column and first column is unique column.i want pick > only limited column like 4 6 9 column.and requ

Re: $$Excel-Macros$$ vlookup query

I want to put vlookup in 7th to 9th row in column A to J from sheet 1. On Tuesday, December 17, 2013 5:42:18 PM UTC+5:30, ravinder negi wrote: > > What is the lookup value > > > > *From:* excel-...@googlegroups.com [mailto: > excel-...@googlegroups.com ] *On Behalf Of *Rajesh Agarwal > *Sent:*

RE: $$Excel-Macros$$ vlookup query

What is the lookup value From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Rajesh Agarwal Sent: Tuesday, December 17, 2013 5:34 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ vlookup query -- Rajesh Kumar Agarwal 9811063001 -- Are

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

try this =IF((ISERROR(VLOOKUP(B2,'C:\Users\admin\Downloads\[Master Sheet.xlsx]Sheet1'!$B:$B,1,0))),"Not Available","Available") and apply conditional formatting in col a or Sub sample() Dim wkb As Workbook Dim i As Long Set wkb = Workbooks.Open("C:\Users\admin\Downloads\Master Sheet.xlsx") For i

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

Hi Ashish, I have attached the sample sheets. assume Master sheet is saved in D folder. and Consolidated sheet is saved in E folder Thanks & Regards, Prabhu R On 24 November 2013 13:07, ashish koul wrote: > share some sample workbooks > > > On Sun, Nov 24, 2013 at 1:06 PM, Prabhu Pinky wrote:

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

share some sample workbooks On Sun, Nov 24, 2013 at 1:06 PM, Prabhu Pinky wrote: > saved in different workbook and in different location. can you help with > any example sheets. > > > Thanks & Regards, > Prabhu R > > > On 24 November 2013 12:35, ashish koul wrote: > >> saved in different workbo

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

saved in different workbook and in different location. can you help with any example sheets. Thanks & Regards, Prabhu R On 24 November 2013 12:35, ashish koul wrote: > saved in different workbook or in same workbook > > you can use application.worksheetfunction.vlookup > > MsgBox Application.

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

saved in different workbook or in same workbook you can use application.worksheetfunction.vlookup MsgBox Application.WorksheetFunction.VLookup("4AC", Sheets(2).Range("A:B"), 2, 0) On Sun, Nov 24, 2013 at 11:32 AM, Prabhu Pinky wrote: > Hi Experts, > > How to do vlookup in VBA. i have two she

Re: $$Excel-Macros$$ Vlookup query

Thanks to all problem solved On Thu, Nov 21, 2013 at 3:58 PM, Shrinivas Shevde wrote: > Dear Kartik > thans adn appretiate for the effort. > for the example its ok but for actual it will not work as in actual Column > B and Column D are totally different in column B there is PO no and in > Colum

Re: $$Excel-Macros$$ Vlookup query

Dear Kartik thans adn appretiate for the effort. for the example its ok but for actual it will not work as in actual Column B and Column D are totally different in column B there is PO no and in Column D there is PR no which are 2 different series at all .for Eg Pr no is 082364 and PO no is 001257

Re: $$Excel-Macros$$ Vlookup query

Hi Shrinivas, PFA, Let me know if you need any changes required Regards, Cartik On Wed, Nov 20, 2013 at 5:10 PM, Shrinivas Shevde 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:

Re: $$Excel-Macros$$ Vlookup query

Behalf Of *Shrinivas Shevde > *Sent:* Wednesday, November 20, 2013 5:29 PM > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Vlookup query > > > > Dear Ravindra > > thanks for reply > > VLOOKUP($J5,CHOOSE({1,2,3,4},$D$4:$D$7,$C$4:$C$7,$E$4:$E$7,$B$

RE: $$Excel-Macros$$ Vlookup query

Then you can use Match function to get the column number and put in yellow colored.. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Shrinivas Shevde Sent: Wednesday, November 20, 2013 5:29 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel

Re: $$Excel-Macros$$ Vlookup query

Dear Ravindra thanks for reply VLOOKUP($J5,CHOOSE({1,2,3,4},$D$4:$D$7,$C$4:$C$7,$E$4:$E$7,$B$4:$B$7),COLUMN(B$1),0) In the above formula in choose function you wrote (1,2,3,4)but I have more than 2000 records. then how to do regards Shrinivas On Wed, Nov 20, 2013 at 5:19 PM, Ravinder wrote: > pf

RE: $$Excel-Macros$$ Vlookup query

pfa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Shrinivas Shevde Sent: Wednesday, November 20, 2013 5:11 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Vlookup query Dear All Please find attached query. Is it possible to write a

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

Ok I even managed to modify this so that the "source" can go upto 1000 lines of "match" info (or more should I require it). This is a very powerful template that I can see multiple applications for. Thank You Very Much Kantila. MUCH appreciated ! On Wednesday, November 13, 2013 11:22

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

PFA with range changed from 23rd to 100th lines. It is working fine. Alternatively you can use named range to make it more easy (Solution Attached ) As far as benefits / limitations are concerned array solutions are very powerful compared to non array. But I personally prefer array solutions only

Re: $$Excel-Macros$$ VLOOKUP Query

Please send me the file I have the solution without changing your data. On 12 Nov 2013 09:55, "Vinay Saraf" wrote: > You can insert one column which contain sum of all 40 column and you can > use vlookup on that column > On 12 Nov 2013 09:21, "Shrinivas Shevde" wrote: > >> Dear Vinay >> Thanks f

Re: $$Excel-Macros$$ VLOOKUP Query

It's very simple to Sum of more than one column. You can use SUM function by different type of range as mention below. =SUM(AV2:AV15)+SUM(AW2:AW15) =SUM(AV2:AW15) On Tue, Nov 12, 2013 at 9:55 AM, Vinay Saraf wrote: > You can insert one column which contain sum of all 40 column and you can > use

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

Kantila, Thanks for your effort. I appreciate it and everyone else's contribution. I have a question I want to add to this. So, I looked at the code and notice that you have defined everything to end at line 23 (except for the last past that says 22?). That's fine, I thought I could cha

Re: $$Excel-Macros$$ VLOOKUP Query

You can insert one column which contain sum of all 40 column and you can use vlookup on that column On 12 Nov 2013 09:21, "Shrinivas Shevde" wrote: > Dear Vinay > Thanks for reply > Actually I want to sum of more than 40 column > Regards > Shrinivas > > > On Mon, Nov 11, 2013 at 5:51 PM, Vinay S

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

PFA Non array solution CA Kantilal Badale On Tue, Nov 12, 2013 at 7:33 AM, Bill Q wrote: > PERECT Ravinder ! > > MANY thanks ! > > > On Monday, 11 November 2013 02:01:37 UTC-5, ravinder negi wrote: > >> pfa >> >> >> >> *From:* excel-...@googlegroups.com [mailto:excel-...@googlegroups.com]

Re: $$Excel-Macros$$ VLOOKUP Query

Dear Vinay Thanks for reply Actually I want to sum of more than 40 column Regards Shrinivas On Mon, Nov 11, 2013 at 5:51 PM, Vinay Saraf wrote: > You can use vlookup or sumif 3 times and add all three > On 11 Nov 2013 17:27, "Shrinivas Shevde" wrote: > >> Dear All >> In vlookup we are giving

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

PERECT Ravinder ! MANY thanks ! On Monday, 11 November 2013 02:01:37 UTC-5, ravinder negi wrote: > pfa > > > > *From:* excel-...@googlegroups.com [mailto: > excel-...@googlegroups.com ] *On Behalf Of *Bill Q > *Sent:* Sunday, November 10, 2013 10:55 PM > *To:* excel-...@googlegroups.co

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

Thanks Bruce On Monday, 11 November 2013 19:51:30 UTC-5, bruce wrote: > What is PFA?PFA is "Please Find Attached" > On Monday, November 11, 2013 3:49:38 PM UTC-8, Bill Q wrote: >> >> What does pfa mean ? >> >> >> On Monday, November 11, 2013 2:01:37 AM UTC-5, ravinder negi wrote: >> >>> pf

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

What is PFA?PFA is "Please Find Attached" On Monday, November 11, 2013 3:49:38 PM UTC-8, Bill Q wrote: > > What does pfa mean ? > > > On Monday, November 11, 2013 2:01:37 AM UTC-5, ravinder negi wrote: > >> pfa >> >> >> >> *From:* excel-...@googlegroups.com [mailto:excel-...@googlegroups.com]

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

What does pfa mean ? On Monday, November 11, 2013 2:01:37 AM UTC-5, ravinder negi wrote: > pfa > > > > *From:* excel-...@googlegroups.com [mailto: > excel-...@googlegroups.com ] *On Behalf Of *Bill Q > *Sent:* Sunday, November 10, 2013 10:55 PM > *To:* excel-...@googlegroups.com > *Subject

Re: $$Excel-Macros$$ VLOOKUP Query

You can use vlookup or sumif 3 times and add all three On 11 Nov 2013 17:27, "Shrinivas Shevde" wrote: > 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 c

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

pfa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Bill Q Sent: Sunday, November 10, 2013 10:55 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Vlookup - Price List Hi Guys, This seems simple and I am pretty certain that it is - b

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

Dear tawhid I tried your code, I don't any error. thanks Rupesh On Wed, Oct 30, 2013 at 4:12 PM, 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 Varian

Re: $$Excel-Macros$$ VLOOKUP doubt

you can use index match if you want to do this only with Vlookup You can try This =VLOOKUP(I2,CHOOSE({1,2,3,4},D:D,C:C,B:B,A:A),3,0) On Mon, Sep 23, 2013 at 11:09 AM, Satiqjaffar ali wrote: > Hello experts, > > I have some doubt in VLOOKUP, that how can i get lookup value from > previous cell?.

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

Thanks Ashwin, That was an interesting one. I never came across any such alternative. Thanks Again ! On Wed, Jul 17, 2013 at 12:21 AM, ashwani agnihotri < ashwani.agniho...@gmail.com> wrote: > hey plz go through this link for better understanding of using choose with > vlookup.. > > http://www.m

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

hey plz go through this link for better understanding of using choose with vlookup.. http://www.myonlinetraininghub.com/excel-vlookup-to-the-left-using-choose On Tue, Jul 16, 2013 at 5:20 PM, Ashish Kumar wrote: > > > Dear Seniors, > > kindly find attached vlookup query, I want get output thru

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

rry® from Vodafone > -- > *From: * NOORAIN ANSARI > *Sender: * excel-macros@googlegroups.com > *Date: *Tue, 16 Jul 2013 20:08:00 +0530 > *To: *excel-macros@googlegroups.com > *ReplyTo: * excel-macros@googlegroups.com > *Subject: *Re: $$Excel-Macros$$ V

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

@googlegroups.com Subject: Re: $$Excel-Macros$$ VLOOKUP (CHOOSE) QUERY - URGENT HELP REQ. Dear Sandeep, Your question is correct, why we are using choose function, because it is possible through only vlookup Function, no need to using choose Function. But As per Question of Mr. Ashish Kumar, He want to

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

te: *Tue, 16 Jul 2013 19:46:02 +0530 > *To: * > *ReplyTo: * excel-macros@googlegroups.com > *Subject: *Re: $$Excel-Macros$$ VLOOKUP (CHOOSE) QUERY - URGENT HELP REQ. > > Dear Ashish, > > Still Curious to know why do you use Choose here ? > > On Tue, Jul 16, 2013 at 7:40

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

: Tue, 16 Jul 2013 19:46:02 To: Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ VLOOKUP (CHOOSE) QUERY - URGENT HELP REQ. Dear Ashish, Still Curious to know why do you use Choose here ? On Tue, Jul 16, 2013 at 7:40 PM, Ashish Kumar wrote: > Dear Seniors, > > F

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

Specially thanks for Noorain Sir (Guru Dev). Regards, Kuldeep Singh Assistant Manager Quality Game Zone India Limited Phone.: +91-9716615535 || naukrikuld...@gmail.com || *Please* *Consider the environment. Please don't print this e-mail unless you really need to.* On Tue, Jul 16, 2013 at 7:40 PM

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

Dear Ashish, Still Curious to know why do you use Choose here ? On Tue, Jul 16, 2013 at 7:40 PM, Ashish Kumar wrote: > Dear Seniors, > > Formula is working fine. > Thanks for your help and support specially Noorain Sir, Kuldeep Sir and > kanwaljit sir. > > Thanks > Ashish > > > On Tuesday, July

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

Dear Seniors, Formula is working fine. Thanks for your help and support specially Noorain Sir, Kuldeep Sir and kanwaljit sir. Thanks Ashish On Tuesday, July 16, 2013 7:26:49 PM UTC+5:30, kanwal_no1 wrote: > > As told by Kuldeep Ji with a small change, which might be causing trouble > for you.

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

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

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

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

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

Dear Seniors, Thanks for your help, but again i'hve geting same error. querry attached please find. and help me to crack the query. I'hve getting wrigh output when i put the formula in Name Column, but when i paste the same formula in rest of fields like address, process, salary...!! the form

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

Hi Ashish, Formula is working fine. Please find the attachment. *Use formula with Ctrl + Shift + Enter (Select All Rows & Press Ctrl + Shift + Enter).* Regards, Kuldeep Singh Assistant Manager Quality Game Zone India Limited Phone.: +91-9716615535 || naukrikuld...@gmail.com || *Please* *Consider

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

Dear Seniors, Data Getting Error..please find the attached sheet for refrence. Thanks Ashish On Tuesday, July 16, 2013 5:37:03 PM UTC+5:30, NOORAIN ANSARI wrote: > > Dear Ashish, > > Please try it.. > > =VLOOKUP(I2,CHOOSE(*{1,2,3,4,5,6}* > ,$A$2:$A$7,$B$2:$B$7,$C$2:$C$7,$D$2:$D$7,$E$2:$E$7)

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

t on my BlackBerry® from Vodafone > -- > *From: * NOORAIN ANSARI > > *Sender: * excel-...@googlegroups.com > *Date: *Tue, 16 Jul 2013 17:37:03 +0530 > *To: *excel-...@googlegroups.com < > excel-macros@googlegroups.com > > *ReplyTo: * excel-

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

: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ VLOOKUP (CHOOSE) QUERY - URGENT HELP REQ. Dear Ashish, Please try it.. =VLOOKUP(I2,CHOOSE(*{1,2,3,4,5,6}* ,$A$2:$A$7,$B$2:$B$7,$C$2:$C$7,$D$2:$D$7,$E$2:$E$7),*{2,4,5,3,6}*,0) with CSE Note : Red Color is use for Index No. of Choose

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

Dear Ashish, Please try it.. =VLOOKUP(I2,CHOOSE(*{1,2,3,4,5,6}* ,$A$2:$A$7,$B$2:$B$7,$C$2:$C$7,$D$2:$D$7,$E$2:$E$7),*{2,4,5,3,6}*,0) with CSE Note : Red Color is use for Index No. of Choose Function and green Color is Columns Index no. of data On Tue, Jul 16, 2013 at 5:20 PM, Ashish Kumar w

Re: $$Excel-Macros$$ Vlookup function using with match & columns

Dear Murli, You can just give ref of column,,, for example if you want B column then put (B:B). =VLOOKUP($L24,$A$3:$D$6,COLUMN(B:B),0) On Wed, Jul 10, 2013 at 4:43 PM, Muralidhar E wrote: > Hi, > Dear friends, > > Thank u > > With the same i want to know using column & columns > > *2.Thi

Re: $$Excel-Macros$$ Vlookup function using with match & columns

Hi, Dear friends, Thank u With the same i want to know using column & columns *2.This is using columns or column function* =vlookup(lookup_value, Table array,*columns or column(array)*,range lookup). I want to know how can we use both these functions. 1. Shall we can get the left side result

Re: $$Excel-Macros$$ Vlookup function using with match & columns

Dear Murli, Find the same Regards, Prafull Jadhav. On Wed, Jul 10, 2013 at 3:59 PM, Muralidhar E wrote: > Dear friends, > > Good afternoon, > > I need a help and I want to know how to use vlookup function by using > match and columns function. How it is works? > Plz, share with me. > > *1.This

Re: $$Excel-Macros$$ Vlookup value with comments

ents part have been taken > place by cell colour. > > I cannot use VBA due to some internal IT restrictions. > > If the cell colour can be picked by vlookup it will be of much helpful. > -- > Regards > Santosh > santoshkumar.subu...@gmail.com > > Date: Wed, 15 May

RE: $$Excel-Macros$$ Vlookup value with comments

, 15 May 2013 16:53:06 +1000 Subject: Re: $$Excel-Macros$$ Vlookup value with comments From: da...@grugeon.com.au To: excel-macros@googlegroups.com It is possible using VBA. Please supply a sample workbook so we can understand exactly how your data is organised and how you want to look it up

Re: $$Excel-Macros$$ Vlookup value with comments

It is possible using VBA. Please supply a sample workbook so we can understand exactly how your data is organised and how you want to look it up. Regards David Grugeon On 15 May 2013 13:51, Prabhu Pinky wrote: > Nope. it is not possible.. > > > On 15 May 2013 01:14, santosh subudhi wrote: >

Re: $$Excel-Macros$$ Vlookup value with comments

Nope. it is not possible.. On 15 May 2013 01:14, santosh subudhi wrote: > Hi Group, > > Is it possible in excel to lookup the comments along with the value. > -- > Regards > Santosh > santoshkumar.subu...@gmail.com > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s

  1   2   3   4   >