Re: $$Excel-Macros$$ Get Value If Criteria Matched

2016-04-06 Thread Pravin Gunjal
Thank you sir.. On Tuesday, April 5, 2016 at 5:47:14 PM UTC+5:30, Paul Schreiner wrote: > > If you're wanting an Excel Function solution: > > In Sheet2, I'd create a "helper" column (A) > and concatenate the Customer Name, Code and Material columns. > Then, in Sheet1, Cell E2, use: > =IF(COUNTIF(S

$$Excel-Macros$$ Get Value If Criteria Matched

2016-04-05 Thread Pravin Gunjal
Hi, Greetings! I want the data in *column E (Sr.No.)* of sheet1 from sheet2, if column B, C & D are matches in both sheets. PFA file. Look forward for good formula. Thanks, Regards, *Pravin Gunjal* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,