$$Excel-Macros$$ Vlookup with multiple lookup value

Hi friends, Please find the below video to learn how to use multiple lookup value in single vlookup formula. https://youtu.be/SpmnZmfJSVo Regards Prabhu.R -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this fo

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.

$$Excel-Macros$$ Vlookup Sensitive Case

Dear All, Kindly help to resolve the attached file of Sensitive Case. find the data by Vlookup between *Capital* & *Small* letters *(Eg. A & a)* *Thank & Regards*

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

$$Excel-Macros$$ Vlookup Matching Issue

Hi, PSA. Trying to do a simple vlookup. I cleaned up the data by trimming, but still cannot get a match. I manually entered in data in B2 in order to get a match. I never encountered anything like this before. Not certain how to fix. Anyone ? Thanks. -- Are you =EXP(E:RT) or =NOT(EXP

$$Excel-Macros$$ vlookup formula

can anyone teach me the formula in the attach file thanks in advance -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread

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

Hi, -- ​Some one help me in finding the Slab with vlookup in getting percentage..​ Regards Yogananda Muthaiah Ph : 9343 666 888 -- 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.faceboo

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

$$Excel-Macros$$ Vlookup from ms access and sqlite

Hi Expert's, need help. It will great appreciated if someone can send me the macro i have data in ms access & sqlite multiple files regularly i received data in excel ms access & sqlite data received once in a month i convert access & sqlite data which data present in excel than use vlookup

$$Excel-Macros$$ VLOOKUP Query

Dear All I am using vlookup and facing following problem File attached thanks in advance -- Shrini -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES

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

ll 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: Izhar To: excel-macros@googlegroups.com Sent: Wednesday, October 7, 2015 12:57 AM Subject: $$Excel-Macros$$ VLOOKUP NOT WORKI

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

bhishek Bhalla > > > > > > > From: "Izhar"izharra...@gmail.com > Sent:Wed, 07 Oct 2015 10:28:25 +0530 > To: excel-macros@googlegroups.com > Subject: $$Excel-Macros$$ VLOOKUP NOT WORKING > > in the workbook, i have two worksheet i.e. SHEET1 & SHEET2, i want to

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

From: "Izhar"izharra...@gmail.com Sent:Wed, 07 Oct 2015 10:28:25 +0530 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ VLOOKUP NOT WORKING in the workbook, i have two worksheet i.e. SHEET1 & SHEET2, i want to look the quantity in SHEET2 which does not exist in SHEET

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

$$Excel-Macros$$ Vlookup query

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

$$Excel-Macros$$ Vlookup Help required

Dear Experts, pl suggest any formula which can help me to get valeus for K2 & L2 from raw sheet against B2 & C2 Note:- kindly Refer the hours which stand within StartTime & EndTime sheet attached for reference Thnaks in advance. rakesh Sharma -- Are you =EXP(E:RT) or =NOT(EXP(E:RT))

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

$$Excel-Macros$$ VLOOKUP QUEARY

Dear All, Please Solve my Query On Urgent Basic. ASAP Please Find The Attachment. Thanks & Regards? ​​ *​* *Saleem Ansari* *Logicash Solutions Pvt. Ltd.* *A-79| Sector-4| Noida| Gautam Budh Nagar (U.P) 201301* *Email Id :-* *saleem.logic...@gmail.com * *Mobile : - +91 7840096219* The i

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

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

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

xcel-macros@googlegroups.com >Sent: Sunday, October 5, 2014 6:13 AM >Subject: $$Excel-Macros$$ VLOOKUP AND HLOOKUP and MACROS > > > >Dear Masters, > >Please teach the following functions:- > >1. VLOOKUP >2. HLOOKUP and >3. MACROS > > > >Thank in adva

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

Dear Masters, Please teach the following functions:- 1. VLOOKUP 2. HLOOKUP and 3. MACROS Thank in advance Regards, Kishore -- 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.

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

you can.” - John Wesley --------- From: Nitin Balodi >To: "excel-macros@googlegroups.com" >Sent: Monday, August 25, 2014 6:47 AM >Subject: $$Excel-Macros$$ VLookup file reference using VBA > > > > >Hi All, >

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

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

Hi All, I have two files: File1 and File2. I need to apply Vlookup in File1 using references from File2. I have stored name of File2 in a string wrkbk and need to apply vlookup using this. Recording Macro gives: ActiveCell.FormulaR1C1 = _ "=VLOOKUP(RC[-3],'[ForecastLastUpdat

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

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

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 formula. Thanks Amar -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you

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

$$Excel-Macros$$ Vlookup problem

using vlookup and requirement is pick data from other sheet. I have data in 10 column and first column is unique column.i want pick only limited column like 4 6 9 column.and requirement is only one time use vlookup formula and pick all data in other sheet by unique column. -- Are you =EXP(E:RT

$$Excel-Macros$$ vlookup in sheet2

Hello Sir I want to put vlookup in sheet2 as per mention in the sheet from sheet1 Thanks -- *Rajesh Kumar Agarwal* *9811063001* -- 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.c

Re: $$Excel-Macros$$ vlookup query

ajesh Agarwal > *Sent:* Tuesday, December 17, 2013 5:34 PM > *To:* excel-...@googlegroups.com > *Subject:* $$Excel-Macros$$ vlookup query > > > > > > -- > *Rajesh Kumar Agarwal* > > *9811063001* > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel

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

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

$$Excel-Macros$$ vlookup help.

Hi Experts, How to do vlookup in VBA. i have two sheets saved in different locations. i need to do vlookup in sheet1 by referring another sheet saved in different location. please help. Thanks & Regards, Prabhu R -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s

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

at 5:19 PM, Ravinder wrote: 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

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

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

$$Excel-Macros$$ Vlookup query

Dear All Please find attached query. Is it possible to write aformula as per my requirement -- Shrini -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RU

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

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

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

; >>>> pfa >>>> >>>> >>>> >>>> *From:* excel-...@googlegroups.com [mailto:excel-...@googlegroups.com] *On >>>> Behalf Of *Bill Q >>>> >>>> *Sent:* Sunday, November 10, 2013 10:55 PM >>>>

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

>> 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:* Sun

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

googlegroups.com [mailto:excel-...@googlegroups.com] *On >> Behalf Of *Bill Q >> >> *Sent:* Sunday, November 10, 2013 10:55 PM >> *To:* excel-...@googlegroups.com >> >> *Subject:* $$Excel-Macros$$ Vlookup - Price List >> >> >> >> Hi Guys, &

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

0:55 PM > *To:* excel-...@googlegroups.com > *Subject:* $$Excel-Macros$$ Vlookup - Price List > > > > Hi Guys, > > > > This seems simple and I am pretty certain that it is - but I am stumped. > Please refer to attached. > > > > - This is a simple price list esti

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

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

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

el-...@googlegroups.com [mailto:excel-...@googlegroups.com] *On >> Behalf Of *Bill Q >> *Sent:* Sunday, November 10, 2013 10:55 PM >> *To:* excel-...@googlegroups.com >> *Subject:* $$Excel-Macros$$ Vlookup - Price List >> >> >> >> Hi Guys, >>

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

cel-...@googlegroups.com > *Subject:* $$Excel-Macros$$ Vlookup - Price List > > > > Hi Guys, > > > > This seems simple and I am pretty certain that it is - but I am stumped. > Please refer to attached. > > > > - This is a simple price list estimator. > &

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

$$Excel-Macros$$ VLOOKUP Query

Dear All In vlookup we are giving the column no from which value should be picked up . I want to get the summation of 3 column is it possible? For Eg I want to get the summation of column 9,10,12 Can anyone tell me how to do it Thanks in advance -- Shrini -- Are you =EXP(E:RT) or =NOT(EXP(E:RT

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

$$Excel-Macros$$ Vlookup - Price List

Hi Guys, This seems simple and I am pretty certain that it is - but I am stumped. Please refer to attached. - This is a simple price list estimator. - There are 2 worksheets. (1 = work, that you work from) (2 = static information/vlookup table) I cannot figure out how to return values base

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

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

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 Dim col As Integer Dim found As Variant Set lookFor = Me.TextBox1 Set rng = Sheets("MSR_Input").Columns("A

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

$$Excel-Macros$$ VLOOKUP doubt

Hello experts, I have some doubt in VLOOKUP, that how can i get lookup value from previous cell?. please find the attached sheet and advice.. thanks a lot. Thanks Satiq -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook pag

Fwd: $$Excel-Macros$$ Vlookup with Round - HELP REQUIRE ???

You can change as follows :- =ROUND(VLOOKUP(F3:F1000,$I$3:$J$100,2,0)*(1+($J$1/100)),0) Regards Pravin Gunjal. -- Forwarded message -- From: SAJID MEMON Date: Tue, Aug 6, 2013 at 2:10 PM Subject: $$Excel-Macros$$ Vlookup with Round - HELP REQUIRE ??? To: Sundarvelan Natarajan

$$Excel-Macros$$ Vlookup with Round - HELP REQUIRE ???

Dear experts, I have attached a small query of rounding method in vlookup formulla, please guide me to complete my project. only 2% works is pending to complete my project awaiting your response RegardsSajid memon -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) i

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

  1   2   3   4   5   >