Hi Gyanesh
PFA the solution u want!!
Regsrds,
Deepak Rawat
On Mon, Sep 7, 2009 at 11:46 PM, gyanesh jain wrote:
>
> Hi friends,
> I have some Query related with Lookup. its in attachment.
>
> can any provide the solution?
>
> --
> Thanks,
> Gyanesh Jain, BE, MBA (Finance)
> +91 98868 68488
>
Hi Gyanesh,
Attached query has been solved using two options. Select which you like.
Thanks.
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On 9/8/09, gyanesh jain wrote:
>
>
> Hi friends,
>
> I have some Q
use the formula
=INDEX(C6:G6,MATCH(LARGE(C7:G7,1),C7:G7,0))
On Tue, Sep 8, 2009 at 12:16 PM, gyanesh jain wrote:
>
> Hi friends,
> I have some Query related with Lookup. its in attachment.
>
> can any provide the solution?
>
> --
> Thanks,
> Gyanesh Jain, BE, MBA (Finance)
> +91 98868 68488
> P
Enter the following formula in cell J7 and copy it down:
=INDEX($C$6:$G$6,MATCH(I7,C7:G7,0))
Norman
On Tue, Sep 8, 2009 at 2:46 AM, gyanesh jain wrote:
>
> Hi friends,
> I have some Query related with Lookup. its in attachment.
>
> can any provide the solution?
>
> --
> Thanks,
> Gyanesh Jain,
Hi,
See if attached gives you what you need.
Regards - Dave.
From: gyanjai...@gmail.com
Date: Tue, 8 Sep 2009 12:16:25 +0530
Subject: $$Excel-Macros$$ Lookup Query
To: excel-macros@googlegroups.com
Hi friends,
I have some Query related with Lookup. its in attachment.
can any provide the soluti
