Re: $$Excel-Macros$$ Help Need for Vlookup Solution

2012-09-26 Thread Vabz
HI Inn short 5 & 10 is row no. in which Sam & Ram is written. Rgds//Vabs On Wednesday, September 26, 2012 1:31:47 PM UTC+5:30, amar takale wrote: > > Hello Vabz > Thanks for Logic based on your criterion formula But Can you explain > it.What is minus Row 5 & Row 10 logic.I cant Understand it.

Re: $$Excel-Macros$$ Help Need for Vlookup Solution

2012-09-26 Thread amar takale
Hello Vabz Thanks for Logic based on your criterion formula But Can you explain it.What is minus Row 5 & Row 10 logic.I cant Understand it.In my data there are 9 column & 13 Row but it is different for different name as per. I will use it but not work I use it & minus Row 8 in formula But formula

Re: $$Excel-Macros$$ Help Need for Vlookup Solution

2012-09-25 Thread amar takale
Need help. On Tue, Sep 25, 2012 at 2:38 PM, amar takale wrote: > Hi Vabz > I will try it but how to range criteria.Bcos after giving formula I used > data validation for name.If I click Name Then all other criteria show inone > shot. > > > On Tue, Sep 25, 2012 at 12:00 PM, Vabz wrote: > >> Dear

Re: $$Excel-Macros$$ Help Need for Vlookup Solution

2012-09-25 Thread amar takale
Hi Vabz I will try it but how to range criteria.Bcos after giving formula I used data validation for name.If I click Name Then all other criteria show inone shot. On Tue, Sep 25, 2012 at 12:00 PM, Vabz wrote: > Dear Amar > > You can use sumproduct for your query > > Rgds > > > On Monday, Septemb

Re: $$Excel-Macros$$ Help Need for Vlookup Solution

2012-09-24 Thread Vabz
Dear Amar You can use sumproduct for your query Rgds On Monday, September 24, 2012 7:01:25 PM UTC+5:30, amar takale wrote: > > Pls find attached below file > > See Attached file. > > On Mon, Sep 24, 2012 at 6:43 PM, amar takale > > wrote: > >> Dear Group Members, >> >> >> >> Please Solution

Re: $$Excel-Macros$$ Help Need for Vlookup Solution

2012-09-24 Thread David Grugeon
Hi Amar Why do you need to use Vlookup and Match, rather than VBA? Is this homework? If so you will need to find out about array formulas to work out the solution. If not, can you explain a bit more about the application, how it will be used, who will use it (Just you or other people?) whether

Re: $$Excel-Macros$$ Help Need for Vlookup Solution

2012-09-24 Thread amar takale
Pls find attached below file See Attached file. On Mon, Sep 24, 2012 at 6:43 PM, amar takale wrote: > Dear Group Members, > > > > Please Solution Need! > > > > I need to apply Vlookup+Match formula to get value in sheet1 (C5 to F5) > cell But it show same Output below. > > > > > > Sheet1 (C5 to

$$Excel-Macros$$ Help Need for Vlookup Solution

2012-09-24 Thread amar takale
Dear Group Members, Please Solution Need! I need to apply Vlookup+Match formula to get value in sheet1 (C5 to F5) cell But it show same Output below. Sheet1 (C5 to F5) cell& Below cell is the result cell where I want to use the formula to get the output from sheet2. Best Regards,