RE: $$Excel-Macros$$ match 2 columns

May 2012 1:50 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ match 2 columns Hi Sara, Please use.. =INDEX(Sheet2!$C$2:$C$7,MATCH(1,(Sheet2!$A$2:$A$7=Sheet1!B2)*(Sheet2!$B$2:$B $7=Sheet1!C2),0)) or =LOOKUP(2,1/((Sheet2!$A$2:$A$7=Sheet1!B2)*(Sheet2!$B$2:$B$7=Sheet1!C2)),Shee t2

Re: $$Excel-Macros$$ match 2 columns

Hi Sara, Please use.. * =INDEX(Sheet2!$C$2:$C$7,MATCH(1,(Sheet2!$A$2:$A$7=Sheet1!B2)*(Sheet2!$B$2:$B$7=Sheet1!C2),0)) *or * =LOOKUP(2,1/((Sheet2!$A$2:$A$7=Sheet1!B2)*(Sheet2!$B$2:$B$7=Sheet1!C2)),Sheet2!$C$2:$C$7) * with ctrl+shift+enter See attached sheet,,, -- Thanks & regards, Noorain Ansa

Re: $$Excel-Macros$$ match 2 columns

2012/5/7 ╰» ℓαℓιт мσαнη > Dear Sara, > > PFA > > *Regards,* > *Lalit Mohan* > *https://www.facebook.com/buzinesstransformation* > > > > On Sun, May 6, 2012 at 11:35 PM, Sara Lee wrote: > >> hi >> i would like to have wgt column in sheet 1 updated

Re: $$Excel-Macros$$ match 2 columns

Dear Sara, PFA *Regards,* *Lalit Mohan* *https://www.facebook.com/buzinesstransformation* On Sun, May 6, 2012 at 11:35 PM, Sara Lee wrote: > hi > i would like to have wgt column in sheet 1 updated based on whenever > there is a match on ozip

$$Excel-Macros$$ match 2 columns

hi i would like to have wgt column in sheet 1 updated based on whenever there is a match on ozip and dzip columns in sheet1 and sheet 2. Can u pls give exact formula? -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Plea