Re: $$Excel-Macros$$ Urgent- Query on lookup

in cell c3 add this formula and fill down =IF(UPPER(VLOOKUP(A3,E:F,2,0))<>UPPER(B3),"Error","") see if it helps On Sat, Sep 7, 2013 at 11:07 AM, ashwani agnihotri < ashwani.agniho...@gmail.com> wrote: > Hi, >> > > I just realized that if i can search the values of table 2 in table 1 it > will

Re: $$Excel-Macros$$ Urgent- Query on lookup

> > Hi, > I just realized that if i can search the values of table 2 in table 1 it will work for me i am not concerned with status now .. for ex...i want to search all the values( 121, 123, 124 ) present table 2 in table 1 ...please let me know the formula Regards, Ashwani -- Are you =EXP(E:R

Re: $$Excel-Macros$$ Urgent- Query on lookup

Hi, Provide the example output. ** * Best Regards, Ms Excel User * ** On Fri, Sep 6, 2013 at 9:07 PM, ashwani agnihotri < ashwani.agniho...@gmail.com> wrote: > Hi Kartik, > > > > Thanks for looking into this. The result is still not what I want. I have > tried to explain it

Re: $$Excel-Macros$$ Urgent- Query on lookup

Hi Kartik, Thanks for looking into this. The result is still not what I want. I have tried to explain it below Table 1 Table 2 *ID* *Status* *ID* *status* 121 = active 121= *Ok* 123= active 123= Ok 124= active 124= Ok 125= active 126= active So if ID 121 =active (statu

Re: $$Excel-Macros$$ Urgent- Query on lookup

Please find attachment, hope this is the result you are looking for. If i understood wrongly please let me know in breif Regards, Kartik On Fri, Sep 6, 2013 at 3:19 PM, ashwani agnihotri < ashwani.agniho...@gmail.com> wrote: > Thanks for reply guys , but the output I was looking was that if the

Re: $$Excel-Macros$$ Urgent- Query on lookup

Hi, Can someone please help me with this? Regards, Ashwani On Fri, Sep 6, 2013 at 3:19 PM, ashwani agnihotri < ashwani.agniho...@gmail.com> wrote: > Thanks for reply guys , but the output I was looking was that if the lookup > table has ID 121 with Status as “ Ok” but in original table ID 121

Re: $$Excel-Macros$$ Urgent- Query on lookup

Thanks for reply guys , but the output I was looking was that if the lookup table has ID 121 with Status as “ Ok” but in original table ID 121 status is “active” so I should come to know of the mismatch On Fri, Sep 6, 2013 at 1:01 PM, Kartik Dale wrote: > Hi Ashwani, > > Please find attachment.

Re: $$Excel-Macros$$ Urgent- Query on lookup

Hi Ashwani, Please find attachment. Just drag the formula in F column if you need it. Regards, Kartik On Fri, Sep 6, 2013 at 11:03 AM, ashwani agnihotri < ashwani.agniho...@gmail.com> wrote: > Hi, > > I have a query. I have two table named original and other. > > Now I want to look up for ID,s

RE: $$Excel-Macros$$ Urgent- Query on lookup

Hi, Try this.. Sub lookupconfirm() Range("F3").Formula = "=IFERROR(IF(VLOOKUP(E3,A3:A7,1,0)>0,""OK""),""Not OK"")" Range("F3").Copy Range("F3:F" & Cells(Rows.Count, 5).End(xlUp).Row).Select ActiveSheet.Paste Application.CutCopyMode = False End Sub Warm

Re: $$Excel-Macros$$ urgent query on dropdown list

very very thanks sir. i want the list in dropdown list in sorted order. On Thu, Dec 15, 2011 at 9:17 AM, NOORAIN ANSARI wrote: > Dear Sourabh, > > Please see attached sheet.. > > -- > Thanks & regards, > Noorain Ansari > *http://excelmacroworld.blogspot.com/*

Re: $$Excel-Macros$$ urgent query on dropdown list

thanks to all of you for help but in this sol name are repeating and not in sorted order On Thu, Dec 15, 2011 at 12:25 AM, Maries wrote: > Find the attachment... > > > On Wed, Dec 14, 2011 at 10:00 PM, Haseeb Avarakkan < > haseeb.avarak...@gmail.com> wrote: > >> Hi Sourabh, >> >> Used a dif

Re: $$Excel-Macros$$ urgent query on dropdown list

> > i have done everything with these fourmulas > =INDEX(sname,MATCH(0,COUNTIF($C$1:$C1,sname),0)) > =INDEX(eroll,MATCH(0,COUNTIF($B$1:$B1,eroll)+(sname<>image!$A$14),0)) > > > but the list is not in sorted order. > > plz explain the following fourmula > > *in the following formula plz explain t

Re: $$Excel-Macros$$ urgent query on dropdown list

thanks for help plz explain the following fourmula i have done everything with these fourmulas =INDEX(sname,MATCH(0,COUNTIF($C$1:$C1,sname),0)) =INDEX(eroll,MATCH(0,COUNTIF($B$1:$B1,eroll)+(sname<>image!$A$14),0)) but the list is not in sorted order. On Wed, Dec 14, 2011 at 5:26 AM, Sourabh Sa

Re: $$Excel-Macros$$ urgent query on dropdown list

*in the following formula plz explain the marked section how it become * {11;9;5;9;3;13;5;3;11;2;5;0;0;5}+1 * * *Convert text to numbers* =INDEX(List, MATCH(0, IF(MAX(NOT(COUNTIF($B$1:B1, List))*(*COUNTIF(List, ">"&List)+1*))=(COUNTIF(List, ">"&List)+1), 0, 1), 0)) COUNTIF(range,criteria) coun

Re: $$Excel-Macros$$ urgent query on dropdown list

through 2nd dropdown i want the extract the information of that student whose name & enroll no is selected. On Tue, Dec 13, 2011 at 11:35 PM, dguillett1 wrote: > You don’t say what you are to do with the SECOND drop down. Seems that > it should not be a drop down. > Anyway, a macro can: > 1.

Re: $$Excel-Macros$$ urgent query on dropdown list

Dear Saurabh Please visit below url. A similar case is neatly explained there. http://www.get-digital-help.com/2010/07/17/create-dependent-drop-down-lists-containing-unique-distinct-values-in-excel/ Regards Yahya On Tue, Dec 13, 2011 at 9:05 PM, dguillett1 wrote: > You don’t say what

Re: $$Excel-Macros$$ urgent query on dropdown list

You don’t say what you are to do with the SECOND drop down. Seems that it should not be a drop down. Anyway, a macro can: 1. make a list from your existing full list 2. As each name is selected, remove it from the created list. Or, if no longer needed, the original list. etc Don Guillett SalesA

Re: $$Excel-Macros$$ Urgent Query

many times in the sheet but with diff values. Luckily in my file same value is appearing 3 times in a row.   Regards, Shahina --- On Thu, 1/13/11, NOORAIN ANSARI wrote: From: NOORAIN ANSARI Subject: Re: $$Excel-Macros$$ Urgent Query To: excel-macros@googlegroups.com Cc: "Anubhav Somani&q

Re: $$Excel-Macros$$ Urgent Query

Hi, Please see the attachment, but ur requirement is not clear, u want result when ur value in alternative order or both of the columns has serial order, hope it will meet with ur requirement. Thanks & Regards ROHAN 9818247278, 8860567680 On Thu, Jan 13, 2011 at 4:43 PM, NOORAIN ANSARI wr

Re: $$Excel-Macros$$ Urgent Query

Dear Anubhav, Please see attachement.. Thanks, Noorain Ansari On Thu, Jan 13, 2011 at 1:45 AM, Anubhav Somani wrote: > Dear All, > > I have data for two years arranged in 2 columns respectively. > Example. > > *Yr1* > > *Yr 2* > > A > > A > > B > > B > > C > > C > > D > > D > > > > F > > > >