RE: $$Excel-Macros$$ Lookup variable sheet name

Paul, Thank you for your patience . . . I now see it! Steve From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Paul Schreiner Sent: Sunday, November 26, 2017 9:53 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Lookup variable

Re: $$Excel-Macros$$ Lookup variable sheet name

Are you trying to look up the date from J1? If so, wouldn't it be:=VLOOKUP($J$1,INDIRECT("'"&E2&"'!"&"$A$3:$F$3"),5,0) and, I'd suggest changing $F$3 to something like $F$1000 Paul- “Do all the good you can, By all the means you can, In all the ways you can,

Re: $$Excel-Macros$$ lookup and sum

This should be a simple =sumif() function: in Cell B2, use:=SUMIF(Sheet2!A:A,A2,Sheet2!B:B) and copy down. Paul- “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 peopl

Re: $$Excel-Macros$$ lookup and sum

Please find the attached sheet. On Tuesday, August 9, 2016 at 11:25:12 AM UTC+5:30, lakshm...@yahoo.com wrote: > > thanks > > > > > > On Tuesday, August 9, 2016 11:21 AM, Abhishek Jain > wrote: > > > PFA > > On Tue, Aug 9, 2016 at 11:11 AM, 'LAKSHMAN PRASAD' via MS EXCEL AND VBA > MACROS > wro

Re: $$Excel-Macros$$ lookup and sum

thanks On Tuesday, August 9, 2016 11:21 AM, Abhishek Jain wrote: PFA On Tue, Aug 9, 2016 at 11:11 AM, 'LAKSHMAN PRASAD' via MS EXCEL AND VBA MACROS wrote: Dear Expert, please help me out lookup and sum from sheet2 regardsLAKSHMAN-- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel?

Re: $$Excel-Macros$$ lookup and sum

PFA On Tue, Aug 9, 2016 at 11:11 AM, 'LAKSHMAN PRASAD' via MS EXCEL AND VBA MACROS wrote: > Dear Expert, > > please help me out lookup and sum from sheet2 > > regards > LAKSHMAN > > -- > 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 offici

Re: $$Excel-Macros$$ lookup from list or to find a cell contain any one of the item in the list

Please check the below formula will work for you, this will count and return a value above zero if existed in the list. =COUNTIF(mylist,RIGHT(A1,5)) Regards Faisal PK On Sat, Apr 2, 2016 at 6:38 PM, Ganesh N wrote: > Dear Team, > > Any one can help me out ? > > Thanks & Regards, > Ganesh N > >

Re: $$Excel-Macros$$ lookup from list or to find a cell contain any one of the item in the list

Dear Team, Any one can help me out ? Thanks & Regards, Ganesh N On Sun, Mar 27, 2016 at 9:15 PM, Ganesh N wrote: > Dear Team, > > Any update on my request ? > > Thanks & Regards, > Ganesh N > > On Sat, Mar 26, 2016 at 7:52 PM, Ganesh N wrote: > >> Dear Team, >> >> Kindly request to help me wi

Re: $$Excel-Macros$$ lookup from list or to find a cell contain any one of the item in the list

Dear Team, Any update on my request ? Thanks & Regards, Ganesh N On Sat, Mar 26, 2016 at 7:52 PM, Ganesh N wrote: > Dear Team, > > Kindly request to help me with some formula to find the cell contains any > item from the list. I have used search formula but it is not working if the > list of i

Re: $$Excel-Macros$$ lookup image from a folder

Many thanks guys :) 2016-01-29 14:18 GMT+00:00 Paul Schreiner : > Evidently, you don't understand the function (just kidding). > > In the Change Event, > I checked to see if the cell changed is where the filenames are defined: > > Targ.Column = 2 > > I defined the folder as: > > ImageFolder =

Re: $$Excel-Macros$$ lookup image from a folder

Evidently, you don't understand the function (just kidding). In the Change Event, I checked to see if the cell changed is where the filenames are defined: Targ.Column = 2 I defined the folder as: ImageFolder = "C:\temp\Images\" I read the image name as targ.valueThe location for the image is one c

Re: $$Excel-Macros$$ lookup image from a folder

If I understand well the function, I need to have the image in a excel file... but in my case, I have images in a folder. 2016-01-28 18:48 GMT+00:00 Paul Schreiner : > Oops, forgot the attachment. > > *Paul* > - > > > > > > > > *“Do all the good you can,By

Re: $$Excel-Macros$$ lookup image from a folder

Take a look at this.I created a change event macro that looks to the "B" column for changes to the filename.The image folder is hard-coded in that macro.You COULD put the folder name on the sheet and get it from there. The Event calls a macro that inserts the image and sizes it to fit the cell in

Re: $$Excel-Macros$$ lookup image from a folder

Oops, forgot the attachment. Paul- “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 ---

Re: $$Excel-Macros$$ lookup image from a folder

I want to show those pictures (located in a specific file) in the cells next to the product name (see attachment) 2016-01-28 17:33 GMT+00:00 Paul Schreiner : > really need more information than that. > > What do you mean by "look up"? > > Are your images simple .tif, .jpg, .bmp images? > > Is you

Re: $$Excel-Macros$$ lookup image from a folder

really need more information than that. What do you mean by "look up"? Are your images simple .tif, .jpg, .bmp images? Is your excel file just a list of filenames that you're wanting to check to see if the file exists in the folder? What is it you're wanting to know (return)? what is it you wish t

Re: $$Excel-Macros$$ Lookup

t;> >> I'm looking for Lookup function >> >> >> >> >> >> >> >> Thanks >> >> Manjunath >> >> >> >> *From:* Prince [mailto:prince...@gmail.com**] >> *Sent:* 11 January 2013 09:10 >> *To:* exc

Re: $$Excel-Macros$$ Lookup

cel-...@googlegroups.com > *Cc:* Manjunath Narayanappa > *Subject:* Re: $$Excel-Macros$$ Lookup > > > > Hi Manjnnath: > > > > > > this link describe lookup with good description please se it: > > > > http://msdn.microsoft.com/en-us/lib

RE: $$Excel-Macros$$ Lookup

Thank you prince….. I'm looking for Lookup function [cid:image001.png@01CDEFE9.B0D749D0] Thanks Manjunath From: Prince [mailto:prince141...@gmail.com] Sent: 11 January 2013 09:10 To: excel-macros@googlegroups.com Cc: Manjunath Narayanappa Subject: Re: $$Excel-Macros$$ Lookup Hi Manj

Re: $$Excel-Macros$$ Lookup

Hi Manjnnath: this link describe lookup with good description please se it: http://msdn.microsoft.com/en-us/library/office/dd797422(v=office.12).aspx and from my side: Vlookup(lookup value,Lookup range,columnsNo, Match type) regards prince On Friday, January 11, 2013 2:21:49 PM UTC+5:30,

Re: $$Excel-Macros$$ Lookup and Replace

here is the solution  On Thu, 1/3/13, Awal wrFrom: Awal Subject: $$Excel-Macros$$ Lookup and Replace To: excel-macros@googlegroups.com Date: Thursday, January 3, 2013, 8:47 AM Hello,I would like to wish y'all a Happy New year... I am still learning VBA and I really need help:I want to be able to

Re: $$Excel-Macros$$ Lookup and Replace

PFA On Thu, Jan 3, 2013 at 10:27 AM, The Viper wrote: > slightly modified your code. > check the attachment > > > On Thu, Jan 3, 2013 at 8:47 AM, Awal wrote: > >> Hello, >> I would like to wish y'all a Happy New year... >> I am still learning VBA and I really need help: >> I want to be able to

Re: $$Excel-Macros$$ Lookup and Replace

slightly modified your code. check the attachment On Thu, Jan 3, 2013 at 8:47 AM, Awal wrote: > Hello, > I would like to wish y'all a Happy New year... > I am still learning VBA and I really need help: > I want to be able to look up for an item and change its price. > See attached file.Can some

RE: $$Excel-Macros$$ lookup values with 2 conditions

Could you please explain the formula used? Best Regards, Amit From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of >>Excel Beginner<< Sent: 22 December 2012 18:45 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ lookup values with

Re: $$Excel-Macros$$ lookup values with 2 conditions

Thanks dear Its really fast. Regards Amit On Sat, Dec 22, 2012 at 6:45 PM, >>Excel Beginner<< wrote: > Hi Amit, > > Please find the attachment. > > > > > -- > *Regards,* > * > * > *Excel Beginner* > On Sat, Dec 22, 2012 at 4:56 PM, Amit Gandhi wrote: > >> Hi Experts >> >> I am atta

Re: $$Excel-Macros$$ lookup values with 2 conditions

Hi Amit, Please find the attachment. -- *Regards,* * * *Excel Beginner* On Sat, Dec 22, 2012 at 4:56 PM, Amit Gandhi wrote: > Hi Experts > > I am attaching an excel file, where I have applied LOOKUP/INDIRECT > function in sheet "backup". But its very slow in working/opening. And >

Re: $$Excel-Macros$$ lookup based on multiple dates.

Hi, please see the attachment. On Mon, Dec 3, 2012 at 8:10 PM, AK wrote: > Hi All, > > I have a question, looking for solution through formula (but VBA is fine > if not possible through formula :) )...I have 2 sheets in a workbook i.e > "Cust data" and "Review"... > > > In the Cust data s

Re: $$Excel-Macros$$ lookup based on multiple dates.

Try something like this COUNTIFS(Review!A:A,'Cust data'!A2,Review!B:B,">=#"&'Cust data'!B2&"#",Review!B:B,"<=#"&'Cust data'!C2&"#") On Mon, Dec 3, 2012 at 8:10 PM, AK wrote: > Hi All, > > I have a question, looking for solution through formula (but VBA is fine > if not possible through formul

Re: $$Excel-Macros$$ Lookup

Dear Yogi, first u have to set the page,custom setting then as u go to another workbook in the page setup u can user the last custom setting which u had set before. Regards, Gawli Anil On Thu, Nov 22, 2012 at 12:35 PM, yogiyogi123 wrote: > Hi all.. > i have a doubt in excel qt > G

Re: $$Excel-Macros$$ Lookup

Hi all.. i have a doubt in excel qt General: Ex: in one folder its have five(5) different work book are there like "a',"b",c,d,e" and each work it has 3 sheets same data . how to get page setup in all work book at the same thanking you -- Join official Facebook page of this forum

Re: $$Excel-Macros$$ lookup or vLookup

Dear Simon, Pl share us a sample workbook. Regards Gawli Anil On Sat, Sep 15, 2012 at 10:12 AM, ashish koul wrote: > try this > VLOOKUP(A2,B:C,2,0) > remove extra spaces from the columns > > Regards > Ashish > > > > On Sat, Sep 15, 2012 at 12:51 AM, SimonCoder wrote: > >> I have a formula I'

Re: $$Excel-Macros$$ lookup or vLookup

try this VLOOKUP(A2,B:C,2,0) remove extra spaces from the columns Regards Ashish On Sat, Sep 15, 2012 at 12:51 AM, SimonCoder wrote: > I have a formula I'm trying to figure out and I can't seem to find any > good explainations of how to use Lookup or vLookup. > > Here is what I'm trying to d

Re: $$Excel-Macros$$ lookup or vLookup

So, your Column B and C is a list of unique item/description combinations? Not sure why you would end up with that, but the formula in D2 would be: =VLOOKUP(A2,B:C,2,FALSE)   Paul - “Do all the good you can, By all the means you can, In all the ways you ca

Re: $$Excel-Macros$$ Lookup data when there are repeated data with diff amt

Hi, Use this.. =INDEX(Sheet1!$D$2:$D$18,MATCH(Sheet2!A2,Sheet1!$B$2:$B$18)) Regards, Kuldeep Singh On Mon, Sep 3, 2012 at 7:02 PM, Rajan_Verma wrote: > *=SUMPRODUCT(N(Sheet1!$B$2:$B$18=Sheet2!A2),Sheet1!D2:D18)* > > * * > > * * > > *Regards* > > *Rajan verma* > > *+91 7838100659 [IM-Gtalk]* >

RE: $$Excel-Macros$$ Lookup data when there are repeated data with diff amt

=SUMPRODUCT(N(Sheet1!$B$2:$B$18=Sheet2!A2),Sheet1!D2:D18) Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Rakesh Kumar Sharma Sent: 03 September 2012 1:01 To: excel-macros@googlegroups.com Subject: $$

Re: $$Excel-Macros$$ Lookup data when there are repeated data with diff amt

Hi Rakesh, Please try this. =INDEX($D$5:$D$21,MATCH(K4,$B$5:$B$21)) Ctrl + Shift + Enter Regards, Kuldeep Singh On Mon, Sep 3, 2012 at 1:24 PM, Rakesh Kumar Sharma wrote: > Dear Manoj, > > I have to pick actual remit amt with vlookup or any other formula. Amt is > remitted for same tracking i

Re: $$Excel-Macros$$ Lookup data when there are repeated data with diff amt

Dear Manoj, I have to pick actual remit amt with vlookup or any other formula. Amt is remitted for same tracking in month of apr is 100, may -250, june 150 then when i use vlookup for this tracking should give remitted amt=0 becoz amt will be (+100-250+150)=0 On Mon, Sep 3, 2012 at 1:07 PM, Ma

Re: $$Excel-Macros$$ Lookup data when there are repeated data with diff amt

Dear Rakesh, Use *=SUMIFS(Sheet1!$D$2:$D$18,Sheet1!$B$2:$B$18,A2)* Regd Manoj On Mon, Sep 3, 2012 at 1:00 PM, Rakesh Kumar Sharma wrote: > Hi Experts, > > I need the actual remit amt agnst tracking on sheet2 when data was found > repeated on sheet1 with positive or nigative amt. > See the att

Re: $$Excel-Macros$$ lookup formula

Dear Noorain, Thank you very much. M Solaiyappan On Mon, Aug 27, 2012 at 2:18 PM, NOORAIN ANSARI wrote: > Dear Solaiya, > > Please find attached study material for basic VBA. > > -- > With Regards, > Noorain Ansari > http:// > noorainansari.com

Re: $$Excel-Macros$$ lookup formula

Dear Noorain, Thank^^^ you very much. M Solaiyappan On Mon, Aug 27, 2012 at 2:18 PM, NOORAIN ANSARI wrote: > Dear Solaiya, > > Please find attached study material for basic VBA. > > -- > With Regards, > Noorain Ansari > http:// > noorainansari.com

Re: $$Excel-Macros$$ lookup formula

*Ashish Koul,* * * *Tks, its work very well.* * * *i am new in this forum / vba program* * * *i want to know the basic things of vba & how to construct the macros / variables + formulas with simple examples - can you please help me in this regards.* * * *Thanks,* * * *M Solaiyappan* * * On Fri, Au

RE: $$Excel-Macros$$ Lookup problem

: $$Excel-Macros$$ Lookup problem Dear Rajan, I sincerely express my gratitude to you for your kind help and support that you have extended towards me. Noorain , Your excellent guidance over MS Excel has proved to be of immense help to me in implementing my work. All the three options

Re: $$Excel-Macros$$ Lookup problem

Thanks bro.. On Mon, Jun 25, 2012 at 1:05 PM, Kal xcel wrote: > Dear Rajan, > > I sincerely express my gratitude to you for your kind help and support > that you have extended towards me. > > > Noorain , > > Your excellent guidance over MS Excel has proved to be of immense help to > me in implem

Re: $$Excel-Macros$$ Lookup problem

Dear Rajan, I sincerely express my gratitude to you for your kind help and support that you have extended towards me. Noorain , Your excellent guidance over MS Excel has proved to be of immense help to me in implementing my work. All the three options that you have taught me are working smoothl

Re: $$Excel-Macros$$ Lookup problem

Dear Kalyan, Please use.. *=VLOOKUP("*"&MID(B25,7,2)&"*"&C25,$B$2:$C$21,2,0)* or *=INDEX($C$2:$C$21,MATCH("*"&MID(B25,7,2)&"*"&C25,B2:B21,0))* or *=LOOKUP(2,1/((RIGHT(B2:B21,7)="CE "&C25)),C2:C21)* -- Thanks & regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.co

RE: $$Excel-Macros$$ Lookup problem

Use this : =SUMPRODUCT(--(RIGHT(B2:B21,7)="CE "&C25),C2:C21) Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Kal xcel Sent: 22 June 2012 4:27 To: excel-macros@googlegroups.com Subject: $$Excel-Mac

RE: $$Excel-Macros$$ Lookup fomular

Dear Mary I try and it work ! Thanks you so much, Your help are appreciated for me From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Maries Sent: Friday, June 15, 2012 2:38 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Lookup fomular

Re: $$Excel-Macros$$ Lookup fomular

t; *Phone* : (+66) 038-210-129 #101 > > *Mobile phone*: (+66) 086-824-5045 > > ** ** > > ** ** > > ** ** > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Anil Gawli > *Sent:* Friday, June 15, 2012 1:36 PM > *To:* excel-mac

RE: $$Excel-Macros$$ Lookup fomular

: attapan_chainarongb...@ck-mail.com Phone : (+66) 038-210-129 #101 Mobile phone: (+66) 086-824-5045 From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Anil Gawli Sent: Friday, June 15, 2012 1:36 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros

Re: $$Excel-Macros$$ Lookup fomular

Find Attached Sheet On Fri, Jun 15, 2012 at 10:55 AM, wrote: > Dear all experts > > ** ** > > I’ve some questions to ask in my sheet > > The sheet put for the forecast date and quantity each per forecast date** > ** > > I need to get the lastest forecast date and the quantity of that,*

Re: $$Excel-Macros$$ Lookup Item No. from Stock.xls in Order.xls

Thanks Asa, Noorain and Vijayjith for your help. Works great. On Monday, June 4, 2012 5:59:40 PM UTC+4, vijayajith VA wrote: > Hi ,, > Then removie ..YES ..just give " " > > Thanks > > =IF(NOT(ISERROR(VLOOKUP(A7,'C:\Documents and Settings\user\My > Documents\Downloads\New Folder\[Stock.xls]

Re: $$Excel-Macros$$ Lookup Item No. from Stock.xls in Order.xls

Hi ,, Then removie ..YES ..just give " " Thanks =IF(NOT(ISERROR(VLOOKUP(A7,'C:\Documents and Settings\user\My Documents\Downloads\New Folder\[Stock.xls]Sheet1'!$C$5:$C$914,1,0))),"NO"," ") On Sun, Jun 3, 2012 at 10:11 PM, prkhan56 wrote: > Thanks. > But it is showing "Yes" for Blanks also

Re: $$Excel-Macros$$ Lookup and return 2nd occurrance

; > ** ** > > Asa > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *resp...@gmail.com > *Sent:* Sunday, June 03, 2012 4:23 AM > > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ L

Re: $$Excel-Macros$$ Lookup Item No. from Stock.xls in Order.xls

You can also use.. =*IF(ISBLANK(B2),"","formula")* On Sun, Jun 3, 2012 at 10:11 PM, prkhan56 wrote: > Thanks. > But it is showing "Yes" for Blanks also. > I wish to show Blank for Blanks. > > On Saturday, June 2, 2012 12:12:39 PM UTC+4, vijayajith VA wrote: > >> Hi Rashid >> As you requested..

Re: $$Excel-Macros$$ Lookup Item No. from Stock.xls in Order.xls

Hi Use one more *IF* condition with your formula to show blank as blank. =IF(A1="","",Formula) On Sun, Jun 3, 2012 at 9:41 AM, prkhan56 wrote: > Thanks. > But it is showing "Yes" for Blanks also. > I wish to show Blank for Blanks. > > On Saturday, June 2, 2012 12:12:39 PM UTC+4, vijayajith V

RE: $$Excel-Macros$$ Lookup and return 2nd occurrance

cel-macros@googlegroups.com] On Behalf Of resp...@gmail.com Sent: Sunday, June 03, 2012 4:23 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Lookup and return 2nd occurrance Thanks for the explanation. What I like abt this formula is it actually picks not only the 2nd occurance bu

Re: $$Excel-Macros$$ Lookup Item No. from Stock.xls in Order.xls

Thanks. But it is showing "Yes" for Blanks also. I wish to show Blank for Blanks. On Saturday, June 2, 2012 12:12:39 PM UTC+4, vijayajith VA wrote: > Hi Rashid > As you requested.. Please find ...attached file...Thanks > > > On Sat, Jun 2, 2012 at 1:14 PM, Rashid Khan wrote: > >> Hello All >> >>

Re: $$Excel-Macros$$ Lookup and return 2nd occurrance

t; Sender: excel-macros@googlegroups.com Date: Sun, 3 Jun 2012 02:42:58 To: Reply-To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Lookup and return 2nd occurrance Hi Hilary, INDEX(NamesRange,1) returns the first row of the range (which is a single cell since the range is only

Re: $$Excel-Macros$$ Lookup and return 2nd occurrance

Thanks Raj. Will try this as well Sent from my BlackBerry® smartphone from Airtel Ghana -Original Message- From: "Rajan_Verma" Sender: excel-macros@googlegroups.com Date: Sun, 3 Jun 2012 12:33:08 To: Reply-To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$

RE: $$Excel-Macros$$ Lookup and return 2nd occurrance

2. Array formula: =INDEX($B$2:$B$13,SMALL(IF($A$2:$A$13=$A$17,ROW($A$2:$A$13)),2)-ROW($A$2)+1) Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of hilary lomotey Sent: Friday, June 01, 2012 1:34 AM To: excel-macros@googlegroups.com Subject

RE: $$Excel-Macros$$ Lookup and return 2nd occurrance

: Re: $$Excel-Macros$$ Lookup and return 2nd occurrance Thanks Asa Attached is what i attempted doing, but after testing my formula this morning with other examples i realised, its doesnt work for all, i will try your now. thanks On Fri, Jun 1, 2012 at 1:06 AM, Asa Rossoff wrote: Hi Hilary

Re: $$Excel-Macros$$ Lookup and return 2nd occurrance

Thanks Haseeb, will try now, very grateful On Fri, Jun 1, 2012 at 3:53 PM, Haseeb A wrote: > Hello Hilary, > > If you want to return the exact 2nd occurrance value, you can use VLOOKUP > like this, > > =VLOOKUP(A14,INDEX(A:A,MATCH(A14,A:A,0)+1):INDEX(B:B,65536),2,0) > > Regards, > Haseeb > > --

Re: $$Excel-Macros$$ Lookup and return 2nd occurrance

Hello Hilary, If you want to return the exact 2nd occurrance value, you can use VLOOKUP like this, =VLOOKUP(A14,INDEX(A:A,MATCH(A14,A:A,0)+1):INDEX(B:B,65536),2,0) Regards, Haseeb -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor threa

Re: $$Excel-Macros$$ Lookup and return 2nd occurrance

---it has >> less work to do. If there is no match it either returns an NA error or if >> the only match was on the very last row of the range, a REF error. >> >> >> =INDEX(NamesRange,MATCH(NameToFind,NamesRange,0)+MATCH(NameToFind,INDEX(NamesRange,MATCH(NameToFind,NamesRang

Re: $$Excel-Macros$$ Lookup and return 2nd occurrance

,INDEX(NamesRange,MATCH(NameToFind,NamesRange,0)+1):INDEX(NamesRange,ROWS(NamesRange)),0)) >> >> >> ** ** >> >> Asa >> >> ** ** >> >> -Original Message- >> From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroup

Re: $$Excel-Macros$$ Lookup and return 2nd occurrance

amesRange)),0)) > > > ** ** > > Asa > > ** ** > > -Original Message- > From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] > On Behalf Of resp...@gmail.com > Sent: Thursday, May 31, 2012 2:01 PM > To: excel-macros@googlegro

RE: $$Excel-Macros$$ Lookup and return 2nd occurrance

ually be slower since it has the added countif. { =IF(COUNTIF(NamesRange,NameToFind)mailto:excel-macros@googlegroups.com] On Behalf Of resp...@gmail.com Sent: Thursday, May 31, 2012 2:01 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Lookup and return 2nd occurrance Thank

Re: $$Excel-Macros$$ Lookup and return 2nd occurrance

Thanks guys I have figured it out with index and match and countif. Thanks Sent from my BlackBerry® smartphone from Airtel Ghana -Original Message- From: resp...@gmail.com Sender: excel-macros@googlegroups.com Date: Thu, 31 May 2012 19:42:32 To: Reply-To: excel-macros@googlegroups.com Su

Re: $$Excel-Macros$$ LOOKUP Formula for Two Table Variables

Try a combination of index and match function Sent on my BlackBerry® from Vodafone -Original Message- From: "John A. Smith" Sender: excel-macros@googlegroups.com Date: Thu, 1 Mar 2012 12:10:21 To: Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ LOOKUP Formula for Two

Re: $$Excel-Macros$$ Lookup value by fulfill some condition in list

Dear Ashish, Try this one =INDIRECT(ADDRESS((MATCH("*"&$B$3&"*",$B$9:$B$14,0)+8),3)) See attached sheet. On Thu, Dec 29, 2011 at 6:51 PM, Ashish Bhalara wrote: > Dear Experts, > > I need to use vlookup function to look value by fulfill some particular > condition. The example to understand the

RE: $$Excel-Macros$$ Lookup value by fulfill some condition in list

Try this: =INDEX($B$9:$C$14,MATCH("*"&B3,$B$9:$B$14,0),2) From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Aamir Shahzad Sent: Dec/Fri/2011 01:13 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Lookup value by fulfill som

RE: $$Excel-Macros$$ Lookup value by fulfill some condition in list

Try this : =OFFSET($B$9,MATCH("*"&B3,$B$9:$B$14,0),1,1,1) From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Aamir Shahzad Sent: Dec/Fri/2011 01:13 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Lookup value by fulfill som

RE: $$Excel-Macros$$ Lookup value by fulfill some condition in list

Try this: =VLOOKUP("*828",$B$9:$C$14,2,0) From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Aamir Shahzad Sent: Dec/Fri/2011 01:13 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Lookup value by fulfill some condition in li

Re: $$Excel-Macros$$ Lookup value by fulfill some condition in list

One solution is attached. Regards, Aamir Shahzad On Thu, Dec 29, 2011 at 6:21 PM, Ashish Bhalara wrote: > Dear Experts, > > I need to use vlookup function to look value by fulfill some particular > condition. The example to understand the problem is attached herewith. > > Thanks & regards > > A

Re: $$Excel-Macros$$ Lookup and summarize multiple values from another worksheet

Please !! Thanks Rohan. -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't po

Re: $$Excel-Macros$$ Lookup and summarize multiple values from another worksheet

Send file Don Guillett SalesAid Software dguille...@gmail.com -Original Message- From: Ometoon Sent: Monday, December 19, 2011 8:40 AM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ Lookup and summarize multiple values from another worksheet Hello, What I want the following

Re: $$Excel-Macros$$ Lookup for a cell between a range of values

Awesome... Thanks Noorian Best Regards! Sent on my BlackBerryŽ from Vodafone -Original Message- From: NOORAIN ANSARI Sender: excel-macros@googlegroups.com Date: Mon, 21 Nov 2011 12:35:25 To: Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Lookup for a cell

Re: $$Excel-Macros$$ Lookup for a cell between a range of values

Dear Krishnan, I hope your query will be solve by =LOOKUP(G3,B3:D11) On Mon, Nov 21, 2011 at 12:22 PM, NOORAIN ANSARI wrote: > Dear Krishnan, > > Don & SAM's solutions are excellent. > apart of this you can also use > =LOOKUP(2,(1/($B$3:$B$11=G3)),$D$3:$D$11) > =INDEX($D$3:$D$11,MATCH(G3,$B$3:$

Re: $$Excel-Macros$$ Lookup for a cell between a range of values

Dear Krishnan, Don & SAM's solutions are excellent. apart of this you can also use =LOOKUP(2,(1/($B$3:$B$11=G3)),$D$3:$D$11) =INDEX($D$3:$D$11,MATCH(G3,$B$3:$B$11,0)) =OFFSET(D2,MATCH(G3,$B$3:$B$11,0),0) -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*

Re: $$Excel-Macros$$ Lookup for a cell between a range of values

Works for me tooo... Don Guillett SalesAid Software dguille...@gmail.com From: Sam Mathai Chacko Sent: Sunday, November 20, 2011 12:43 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Lookup for a cell between a range of values Here the attachment with the formula Don was

Re: $$Excel-Macros$$ Lookup for a cell between a range of values

Sam and Don... Thanks so much!! I never knew that this could be solved using a simple vlookup :) I thought that some nested formula should be written to solve this...Thanks once again.. Warm Regards ! On Mon, Nov 21, 2011 at 12:13 AM, Sam Mathai Chacko wrote: > Here the attachment with the f

Re: $$Excel-Macros$$ Lookup for a cell between a range of values

Here the attachment with the formula Don was mentioning. Working fine as far as I can see! Sam On Mon, Nov 21, 2011 at 12:10 AM, Krishnan Moorthy wrote: > Don, thanks for your response.. > > I have tried Vlookup.. if I enter 99 in G3 it shows NA.. > > Let me rephrase my question once again...If

Re: $$Excel-Macros$$ Lookup for a cell between a range of values

Don, thanks for your response.. I have tried Vlookup.. if I enter 99 in G3 it shows NA.. Let me rephrase my question once again...If I enter any number between 1-900 it should pick the corresponding Value .. for example. if I enter 650 it should lookup for this value in my range (B3:D11) and it s

Re: $$Excel-Macros$$ Lookup for a cell between a range of values

Have you tried? =VLOOKUP(G3,$B$3D$11,3) Don Guillett SalesAid Software dguille...@gmail.com From: Krishnan Moorthy Sent: Sunday, November 20, 2011 11:43 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Lookup for a cell between a range of values Dear Excel Gurus, Need your help

Re: $$Excel-Macros$$ Lookup

Thanks you very much SAM. Aamir Shahzad On Sat, Oct 29, 2011 at 2:32 AM, Sam Mathai Chacko wrote: > 1 will look for matching values in the 1st column, and 3 will give results > from 3rd column! > > Sam > > > On Sat, Oct 29, 2011 at 3:00 AM, Aamir Shahzad > wrote: > >> SAM one last question is

Re: $$Excel-Macros$$ Lookup

1 will look for matching values in the 1st column, and 3 will give results from 3rd column! Sam On Sat, Oct 29, 2011 at 3:00 AM, Aamir Shahzad wrote: > SAM one last question is =MultiResultLookedUp(B3,*1*,$F$3:$H$42,3) > 3 is understandable that it's column 3 but what is 1 in Red font. > > Aami

Re: $$Excel-Macros$$ Lookup

SAM one last question is =MultiResultLookedUp(B3,*1*,$F$3:$H$42,3) 3 is understandable that it's column 3 but what is 1 in Red font. Aamir Shahzad On Sat, Oct 29, 2011 at 2:19 AM, Sam Mathai Chacko wrote: > Just change =MultiResultLookedUp(B3,2,$F$3:$I$42,*1*) to > =MultiResultLookedUp(B3,2,$F$

Re: $$Excel-Macros$$ Lookup

Just change =MultiResultLookedUp(B3,2,$F$3:$I$42,*1*) to =MultiResultLookedUp(B3,2,$F$3:$I$42,*3*) to look at second column and pick value from 3rd column Sam On Sat, Oct 29, 2011 at 2:46 AM, Aamir Shahzad wrote: > > SAM this is working marvelous from left side but tell me (SYNTAX) now to picked

Re: $$Excel-Macros$$ Lookup

SAM this is working marvelous from left side but tell me *(SYNTAX)* now to picked up the right side values from columns 2nd or 3rd. Because this code is not giving the values from right side now. On Sat, Oct 29, 2011 at 1:24 AM, Sam Mathai Chacko wrote: > Is this just for whims? Or are you just i

Re: $$Excel-Macros$$ Lookup

Is this just for whims? Or are you just intrigued? =MultiResultLookedUp(B3,2,$F$3:$I$42,1) will look at the second column and pick values from 1st column Public Function MultiResultLookedUp(varLookupValue, lngLookAtCol As Long, rngRange As Range, Optional lngCol As Long) As String Dim lngLoo

Re: $$Excel-Macros$$ Lookup

Now resolved thanks. Any possibility for pickup the left side values? Aamir Shahzad On Fri, Oct 28, 2011 at 11:20 PM, Sam Mathai Chacko wrote: > Just specify the column index > > Public Function MultiResultLookedUp(varLookupValue, rngRange As Range, > Optional lngCol As Long) As String > >

Re: $$Excel-Macros$$ Lookup

Just specify the column index Public Function MultiResultLookedUp(varLookupValue, rngRange As Range, Optional lngCol As Long) As String Dim lngLoop As Long Dim lngDefaultCol As Long: lngDefaultCol = 2 Dim varArray varArray = rngRange If lngCol <> 0 Then lngDefaultCol = lngCol

Re: $$Excel-Macros$$ Lookup

Good result but if 3rd 4th or other column required, this macro only give result of next column only. Need further enhancement. Regards, Aamir Shahzad On Thu, Oct 27, 2011 at 11:39 PM, Sam Mathai Chacko wrote: > Public Function MultiResultLookedUp(varLookupValue, rngRange As Range) As > String

Re: $$Excel-Macros$$ Lookup

Public Function MultiResultLookedUp(varLookupValue, rngRange As Range) As String Dim lngLoop As Long Dim varArray varArray = rngRange For lngLoop = LBound(varArray, 1) To UBound(varArray, 1) If varArray(lngLoop, 1) = varLookupValue Then If InStr(1, "/" & MultiResultLookedUp & "/", "/" & varAr

Re: $$Excel-Macros$$ Lookup a name and return a value

hi marcus see the attachment i tried to solve it with formulae let me know if you require the macro for it. On Tue, Feb 22, 2011 at 2:44 PM, Marcus wrote: > Hi > Can anyone assist me, fixing this macro? I want it to lookup each name > in Sheet1, find it in Sheet2 and return the ID number to Shee

Re: $$Excel-Macros$$ Lookup values in different sheets

Dear Amir, IFERROR will not work in excel 2003. Try this one =IF(ISNA(IF(ISNA(VLOOKUP(B6,$E$3:$F$3,2,0)),VLOOKUP(B6,$H$3:$I$3,2,0),VLOOKUP(B6,$E$3:$F$3,2,0))),VLOOKUP(B6,$K$3:$L$3,2,0),"") type the above formula anywhere in worksheet. cel (b6) is taken as lookup value. Thanks & Regards Thamu

Re: $$Excel-Macros$$ Lookup values in different sheets

Thanks Dave nice idea. Aamir Shahzad On Wed, Jan 26, 2011 at 6:08 AM, Dave Bonallack wrote: > Hi, > IFERROR can be stacked, just like IF can be. > Try this formula in C4, then copy down: > > > =IFERROR(VLOOKUP(B4,$E$3:$F$3,2,0),IFERROR(VLOOKUP(B4,$H$3:$I$3,2,0),VLOOKUP(B4,$K$3:$L$3,2,0))) > > R

RE: $$Excel-Macros$$ Lookup values in different sheets

Hi, IFERROR can be stacked, just like IF can be. Try this formula in C4, then copy down: =IFERROR(VLOOKUP(B4,$E$3:$F$3,2,0),IFERROR(VLOOKUP(B4,$H$3:$I$3,2,0),VLOOKUP(B4,$K$3:$L$3,2,0))) Regards - Dave Date: Tue, 25 Jan 2011 22:57:34 +0500 Subject: $$Excel-Macros$$ Lookup values in differen

Re: $$Excel-Macros$$ lookup function comparing 3 columns

HI, One of the alternative is: *=ROUND(C3,-1)* 110 110 110.5 110 111 110 111.5 110 112 110 112.5 110 113 110 113.5 110 114 110 114.5 110 115 120 115.5 120 116 120 116.5 120 117 120 117.5 120 118 120 118.5 120 119 120 119.5 120 120 120 On Fri, Sep 24, 2010 at 10:55 AM, Srinivasan Ethirajalu < sri

Re: $$Excel-Macros$$ lookup function comparing 3 columns

please find the excel with result of 3 column comparision: i have checked for isblank formula & assigned with weightage as 1,2,4 for col a,b,c On Fri, Sep 24, 2010 at 10:40 AM, Srinivasan Ethirajalu < srinivasan.ethiraj...@gmail.com> wrote: > Please clarify: > Below are all possibilities: > > *

  1   2   >