Re: $$Excel-Macros$$ lookup and sum

2016-08-09 Thread Paul Schreiner
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 peopl

Re: $$Excel-Macros$$ lookup and sum

2016-08-09 Thread सचिन शर्मा
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 AND VBA > MACROS > wro

Re: $$Excel-Macros$$ lookup and sum

2016-08-08 Thread 'LAKSHMAN PRASAD' via MS EXCEL AND VBA MACROS
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 regardsLAKSHMAN-- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel?

Re: $$Excel-Macros$$ lookup and sum

2016-08-08 Thread Abhishek Jain
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 > =TIME(2,DO:IT,N:OW) ! Join offici

$$Excel-Macros$$ lookup and sum

2016-08-08 Thread 'LAKSHMAN PRASAD' via MS EXCEL AND VBA MACROS
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