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

(xlUp).Row).Select ActiveSheet.Paste Application.CutCopyMode = False End Sub Warm Regards, Ravi Kumar. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of ashwani agnihotri Sent: Friday, September 06, 2013 11:04 AM To: excel-macros@googlegroups.co

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

Hi, I have a query. I have two table named original and other. Now I want to look up for ID,s and check for mismatch in the status in both table. For ex- If 121 is there in lookup table with status ok but the status of 121 in original table is active I should be able to detect the mismatch I a

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

at 4:27 AM, Sourabh Salgotra >> wrote: >> >>> 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: >>

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

AM, Sourabh Salgotra wrote: > >> 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 a

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

; > 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. make a list from your existing full list >> 2. As each name is se

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

t; *Sent:* Tuesday, December 13, 2011 11:21 AM > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ urgent query on dropdown list > > > Dear Sir, > plz download the attached file. detail query in file. > > > > -

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

gt; Don Guillett > SalesAid Software > dguille...@gmail.com > > *From:* Sourabh Salgotra > *Sent:* Tuesday, December 13, 2011 11:21 AM > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ urgent query on dropdown list > > > Dear Sir, >

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

SalesAid Software dguille...@gmail.com From: Sourabh Salgotra Sent: Tuesday, December 13, 2011 11:21 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ urgent query on dropdown list Dear Sir, plz download the attached file. detail query in file

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

Dear Sir, plz download the attached file. detail query in file. Thanks & Regards Sourabh Contact Numbers: +91-94630-49202 Website:http://adhurapyaar.co.cc -- FORUM RULES (934+ members already BANNED f

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

$$Excel-Macros$$ Urgent Query

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 H I Now i want is to make a combined list (lets say in column 3) but there should be no repetitions in this list (as in the above example, after combining, i should o