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("'"&"'!"&"$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 in sheet2 is found in Sheet1, then copy entire sheet 1 row and

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

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

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

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 >

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

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

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

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

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

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

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

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

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

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,

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

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

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

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 Manjnnath

Re: $$Excel-Macros$$ Lookup

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

Re: $$Excel-Macros$$ Lookup

:* Prince [mailto:prince...@gmail.com**] *Sent:* 11 January 2013 09:10 *To:* excel-...@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

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

here is the solution  On Thu, 1/3/13, Awal malaw...@gmail.com wrFrom: Awal malaw...@gmail.com 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

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

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

slightly modified your code. check the attachment On Thu, Jan 3, 2013 at 8:47 AM, Awal malaw...@gmail.com 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

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 excelbegin...@gmail.com wrote: Hi Amit, Please find the attachment. -- *Regards,* * * *Excel Beginner* On Sat, Dec 22, 2012 at 4:56 PM, Amit Gandhi silkyro...@gmail.com wrote:

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 2 conditions Hi

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

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 silkyro...@gmail.com wrote: Hi Experts I am attaching an excel file, where I have applied LOOKUP/INDIRECT function in sheet backup. But its very slow in

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

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 exce...@gmail.com wrote: Hi All, I have a question, looking for solution through formula (but VBA is fine if not possible through

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

Hi, please see the attachment. On Mon, Dec 3, 2012 at 8:10 PM, AK exce...@gmail.com 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

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 yogiyogi...@gmail.com wrote: Hi all.. i have a

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 @

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

, 2012 3:21:53 PM 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

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

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 koul.ash...@gmail.com 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 mreed1...@gmail.com

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

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 rakeshks@gmail.comwrote: Hi Experts, I need the actual remit amt agnst tracking on sheet2 when data was found repeated on sheet1 with positive or nigative

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,

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 rakeshks@gmail.comwrote: Dear Manoj, I have to pick actual remit amt with vlookup or any other formula. Amt is remitted

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

[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$$ Lookup data when there are repeated data with diff amt

Re: $$Excel-Macros$$ lookup formula

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

Re: $$Excel-Macros$$ lookup formula

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

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,

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

Re: $$Excel-Macros$$ Lookup problem

Thanks bro.. On Mon, Jun 25, 2012 at 1:05 PM, Kal xcel kalx...@gmail.com 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

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

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

RE: $$Excel-Macros$$ Lookup problem

-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

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.com On Fri, Jun

Re: $$Excel-Macros$$ Lookup fomular

** ** ** ** ** ** ** ** *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$$ Lookup fomular ** ** Find Attached Sheet On Fri, Jun 15, 2012

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

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

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

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

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

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

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

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 prkha...@gmail.com wrote: Thanks. But it is showing Yes for

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

,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

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

@googlegroups.com Subject: RE: $$Excel-Macros$$ Lookup and return 2nd occurrance =INDEX($A$1:$B$10,MAX(--($A$1:$A$10=A2)*ROW($A$1:$A$10)),2) with CSE Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of hilary lomotey

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

a...@lovetour.info Sender: excel-macros@googlegroups.com Date: Sun, 3 Jun 2012 02:42:58 To: excel-macros@googlegroups.com 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

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 prkha...@gmail.com wrote: Hello

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

@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 but the last

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

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@googlegroups.com Subject: Re: $$Excel-Macros$$ Lookup and return 2nd occurrance ** ** Thanks guys I have figured

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

@googlegroups.com Subject: 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

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

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

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

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 haseeb.avarak...@gmail.com 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)

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

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

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

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

-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 Thanks guys I have figured it out with index and match and countif. Thanks Sent from my BlackBerryR

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

Subject: $$Excel-Macros$$ LOOKUP Formula for Two Table Variables Excel Teachers, I need a formula that will look at a data table (typical; left-hand column and column header row are the two variables of the lookup) and give the intersecting value. My data tables sometimes contain numbers

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

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

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 some condition in list

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 some condition in list

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

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

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

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

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

...@gmail.com *From:* Krishnan Moorthy krishnanm2...@gmail.com *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 lookup formula. I have some min

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

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

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

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

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

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

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 noorain.ans...@gmail.comwrote: 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)

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

Subject: 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 noorain.ans...@gmail.comwrote: Dear Krishnan, Don SAM's solutions are excellent. apart of this you

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 samde...@gmail.comwrote: Public Function MultiResultLookedUp(varLookupValue, rngRange As

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

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 samde...@gmail.comwrote: Just specify the column index Public Function MultiResultLookedUp(varLookupValue, rngRange As Range, Optional lngCol As Long) As

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

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 samde...@gmail.comwrote: Is this just for whims?

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 aamirshahza...@gmail.com wrote: SAM this is working marvelous from left side but tell me

  1   2   >