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

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

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

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

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

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

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

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

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

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

$$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 <bhalla_...@rediffmail.com> >> *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

the times you can,To all the people > you can,As long as ever you can.” - John Wesley* > - > > -- > *From:* abhishek bhalla <bhalla_...@rediffmail.com > > *To:* excel-...@googlegroups.com > *Sent:* Wednesday, Oc

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

D VBA MACROS <excel-macros@googlegroups.com> Cc: schreiner_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 sus

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

l 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 <izharra...@gmail.com> To: excel-macros@googlegroups.com Sent: Wednesday, October 7, 2015 12:57 AM Subject: $$Excel-Ma

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

rediffmail.com> 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 colla

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

From: Izharizharra...@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 SHEET1, i applied

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

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 ashishbhalar...@gmail.com wrote: Make a little changes in your formula as mention below, then lookup

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.

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

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 shrinivas...@gmail.com wrote: Dear All I have a text in Column A4 ,I am extracting a number from that text in colum B4,using outcome

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

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 @

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,

$$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 saleem.logic...@gmail.com* *Mobile : -

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

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

.” - John Wesley* - *From:* Kumar Kishore kishore...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Tuesday, October 7, 2014 5:23 AM *Subject:* Re: $$Excel-Macros$$ VLOOKUP AND HLOOKUP and MACROS Dear Sirs, Thank you so much. I Will learn

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

-macros@googlegroups.com *Sent:* Tuesday, October 7, 2014 5:23 AM *Subject:* 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 schreiner_p

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

, 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 advance Regards, Kishore -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna

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

the times you can, To all the people you can, As long as ever you can.” - John Wesley - From: Kumar Kishore kishore...@gmail.com To: excel-macros@googlegroups.com Sent: Sunday, October 5, 2014 6:13 AM Subject: $$Excel-Macros$$ VLOOKUP AND HLOOKUP

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

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 advance Regards, Kishore -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you

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

Re: $$Excel-Macros$$ Vlookup Issue

cheers!! On Tue, Sep 2, 2014 at 10:28 AM, Sunil Kumar Yadav sk.yadav7...@gmail.com 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 v...@vabs.in wrote: Check this.. Cheers!! On Mon, Sep 1, 2014 at

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 v...@vabs.in wrote: Check this.. Cheers!! On Mon, Sep 1, 2014 at 6:36 PM, Sunil Kumar Yadav sk.yadav7...@gmail.com wrote: Hello Friends, i have a query,

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

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 nitinbal...@live.com wrote: Hi All, I have two files: File1 and File2. I need to apply Vlookup in File1 using references from File2. I have stored

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

: Monday, August 25, 2014 6:47 AM Subject: $$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

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

+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) Cheers On Aug 25, 2014 4:18 PM, Nitin Balodi nitinbal...@live.com wrote: Hi All, I

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

],'[wrkbk]Sheet1'!C1:C8,8,0) Value of WrkBk is *ForecastLastUpdated_18 July 2014 15.45.xlsx* Regards. Yours Sincerely, *Nitin Balodi* -- Date: Mon, 25 Aug 2014 16:25:31 +0530 Subject: Re: $$Excel-Macros$$ VLookup file reference using VBA From: v...@vabs.in

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

as ever you can.” - John Wesley - From: Nitin Balodi nitinbal...@live.com To: excel-macros@googlegroups.com excel-macros@googlegroups.com Sent: Monday, August 25, 2014 7:46 AM Subject: RE: $$Excel-Macros$$ VLookup file

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

nitinbal...@live.com *To:* excel-macros@googlegroups.com excel-macros@googlegroups.com *Sent:* Monday, August 25, 2014 7:46 AM *Subject:* RE: $$Excel-Macros$$ VLookup file reference using VBA Hi Vaibhav, Thanks for immediate response, but it is still showing me Syntax Error

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 v...@vabs.in 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

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

Great work!! On Fri, May 2, 2014 at 12:13 PM, amar takale amartak...@gmail.com 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 v...@vabs.in wrote: Hi Amar, Yes it is possible,

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

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

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 v...@vabs.in wrote: Hi, PFA Cheers!! On Tue, Apr

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 Amar

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,

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

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

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 manish88jais...@gmail.comwrote: 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

Re: $$Excel-Macros$$ Vlookup problem

Share your workbook plz Thanks regards, www.MrExcel4U.com http://mrexcel4u.blogspot.com/ On Thu, Mar 6, 2014 at 3:55 PM, Dileep Kumar deepuk...@gmail.com wrote: Hi Manish, Will you please elobrate with example data. On Thu, Mar 6, 2014 at 3:52 PM, manish jaiswal

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

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 query

Agarwal *Sent:* Tuesday, December 17, 2013 5:34 PM *To:* excel-...@googlegroups.com javascript: *Subject:* $$Excel-Macros$$ vlookup query -- *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

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 koul.ash...@gmail.com wrote: share some sample workbooks On Sun, Nov 24, 2013 at 1:06 PM,

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

$$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 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 prabhupin...@gmail.comwrote: Hi Experts, How to do vlookup in

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 koul.ash...@gmail.com wrote: saved in different workbook or in same workbook you can use application.worksheetfunction.vlookup

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

Thanks to all problem solved On Thu, Nov 21, 2013 at 3:58 PM, Shrinivas Shevde shrinivas...@gmail.comwrote: 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

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

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

Re: $$Excel-Macros$$ Vlookup query

ravinderexcelgr...@gmail.comwrote: 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

RE: $$Excel-Macros$$ Vlookup query

at 5:19 PM, Ravinder ravinderexcelgr...@gmail.com 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

Re: $$Excel-Macros$$ Vlookup query

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$4:$B$7), COLUMN(B$1),0) In the above formula

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 shrinivas...@gmail.comwrote: Dear All Please find attached query. Is it possible to write aformula as per my requirement -- Shrini -- Are you =EXP(E:RT)

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

*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. - There are 2 worksheets. (1 = work, that you work from) (2 = static information/vlookup

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

Of *Bill Q *Sent:* Sunday, November 10, 2013 10: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

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

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 shrinivas...@gmail.com 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

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

-...@googlegroups.com javascript: *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. - There are 2 worksheets. (1 = work, that you work from) (2

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

Of *Bill Q *Sent:* Sunday, November 10, 2013 10: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

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

:* 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:* $$Excel-Macros$$ Vlookup - Price List Hi Guys, This seems simple and I am pretty certain that it is - but I am

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

-...@googlegroups.com javascript: *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. - There are 2 worksheets. (1 = work, that you

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 vi...@vinaysaraf.com wrote: You can use vlookup or sumif 3 times and add all three On 11 Nov 2013 17:27, Shrinivas Shevde shrinivas...@gmail.com wrote:

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

-...@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, This seems simple and I am pretty certain that it is - but I am stumped. Please refer to attached. - This is a simple

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 shrinivas...@gmail.com wrote: Dear Vinay Thanks for reply Actually I want to sum of more than 40 column Regards Shrinivas On Mon, Nov 11, 2013 at

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

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:* $$Excel-Macros$$ Vlookup - Price List Hi Guys, This seems simple and I am

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 vi...@vinaysaraf.com wrote: You can insert one column which contain sum of all 40

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 vi...@vinaysaraf.com 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

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

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

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

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 tawhid.ha...@gmail.com 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

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

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 satiqjaffar...@gmail.comwrote: Hello experts, I have some doubt in VLOOKUP, that how can i get lookup value

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

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 sajidwi...@hotmail.com Date: Tue, Aug 6, 2013 at 2:10 PM Subject: $$Excel-Macros$$ Vlookup with Round - HELP REQUIRE

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

Dear Seniors, kindly find attached vlookup query, I want get output thru vlookup choose function. please help me on this query and please explain me why we use {1,2,3,4,} in formula. Thanks in advance. Thanks Ashish -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?

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

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

@googlegroups.comexcel-macros@googlegroups.com Reply-To: 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

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

-...@googlegroups.com javascript: *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 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}*

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

  1   2   3   4   5   >