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,

$$Excel-Macros$$ Lookup multiple columns data using vba

Hello, I need your help. I was wondering if someone would tweak it or better please help me with a solution to my problem. Here is what I would to achieve: For example: from row2 to the lastrow in Sheet2: If any combination of Ai&Ci&Di in sheet2 is found in Sheet1, then copy entire sheet 1 row an

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

$$Excel-Macros$$ lookup and sum

Dear Expert, please help me out lookup and sum from sheet2 regardsLAKSHMAN -- 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

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

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

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 item in different order. Working in one sheet and list are in another sheet If you have any concern kindly let me know. Thanks

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

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

Hi dears, I'd need some help regarding my excel file, I want to "lookup" images from a folder, basing on file name on a cell ... is it possible with a VBA code Many thanks guys :) Regards LMDIMANI Mustapha -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,

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,

$$Excel-Macros$$ Lookup

Dear All, How to use Lookup in Excel Worksheet. I need to know the formulas. Thanks Manjunath PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING THIS E-MAIL For Aon's standard conditions associated with this e-mail please visit http://www.aon.com/uk/en/email-fo

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

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

$$Excel-Macros$$ Lookup and Replace

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 someone please help? Thanks. -- Join official Facebook page of this forum @ https://www.facebook.com/discus

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 >

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

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 when data is large, it takes too much time for processing. Is there any better & fast way to get the same output? Please help me here. Regards Ami

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

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

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 sheet I have start date of the project i.e column B, column C is First review date and Column D i

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

Subject: $$Excel-Macros$$ lookup or vLookup 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 do:   A   |   B   |  C  |  D - 50   |   50  | 50desc  |  

$$Excel-Macros$$ lookup or vLookup

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 do: A | B | C | D - 50 | 50 | 50desc | ??? 52 | 51 | 51desc | ??? 50 | 52 | 52desc |

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

t; > *+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:* $$Excel-Macros$$

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

: $$Excel-Macros$$ Lookup data when there are repeated data with diff amt 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 attachment... -- Regards, Rakesh Kumar Sharma Contact: +91-9971024741

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

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

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 attachment... -- Regards, Rakesh Kumar Sharma Contact: +91-9971024741 -- Join official facebook page of this forum @ https://www.facebook.com/discu

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

bject: $$Excel-Macros$$ Lookup problem Dear Experts, Please help me to solve my query. Details is in attached sheet. -- Kalyan Chattopadhyay Executive Sales Coordinator R. S. H. Pvt. Ltd. -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate threa

$$Excel-Macros$$ Lookup problem

Dear Experts, Please help me to solve my query. Details is in attached sheet. -- *Kalyan Chattopadhyay* *Executive Sales Coordinator* *R. S. H. Pvt. Ltd.* -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please He

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

$$Excel-Macros$$ Lookup fomular

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, So, the result which fomular which I use are "Ok", but I think may be have better way to do that Ple

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

Subject: $$Excel-Macros$$ Lookup and return 2nd occurrance Hello Excel Masters if I have a list if names like below in column A and say I have corresponding different figures in column B. Hilary Rajan Maries Noorain Hilary Rajan Don Kris Asa And so on and I want to return for instance the

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

Hello Excel Masters if I have a list if names like below in column A and say I have corresponding different figures in column B. Hilary Rajan Maries Noorain Hilary Rajan Don Kris Asa And so on and I want to return for instance the second occurance of hilary with its corresponding figure. Kind

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 Formu

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

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

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 Ashish Bhalara -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor

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

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

Hello, What I want the following: In sheet 1 in cell B2 and C2 I want the corresponding totalization of sheet 2 per calendar month. I do not know how I can put this into a formula, so I like someone to ask how I can establish this. PS: Ifyou need the corresponding example sheet I can forward thi

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

barrassed smile]D$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 >>> *

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

il.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 with a

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

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

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

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

Dear Excel Gurus, Need your help with a lookup formula. I have some min and max numbers and next to it i have some values (see attached).. Now in column G3 if I enter any number for eg: 650 it should lookup for this value in my range (B3:D11) and it should populate "*G" *in cell *H3*because 650 c

  1   2   >