Thanks for reply.
With Regards,
Hitesh.
From: excel-macros@googlegroups.com
[mailto:excel-mac...@googlegroups.com] On Behalf Of ashish koul
Sent: Thursday, May 06, 2010 3:55 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Need Help to
t; excel-mac...@googlegroups.com]
> > On Behalf Of ashish koul
> > Sent: Wednesday, May 05, 2010 10:59 PM
> > To: excel-macros@googlegroups.com
> > Subject: Re: $$Excel-Macros$$ Need Help to pickup Rate List for formula
> >
>
59 PM
> To: excel-macros@googlegroups.com
> Subject: Re: $$Excel-Macros$$ Need Help to pickup Rate List for formula
>
>
>
> check the attachment
>
> On Wed, May 5, 2010 at 6:56 PM, vidyut more wrote:
>
> I have at
y 05, 2010 10:59 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Need Help to pickup Rate List for formula
check the attachment
On Wed, May 5, 2010 at 6:56 PM, vidyut more
wrote:
I have attached sample file. I want formula for picking up rate from
excel sheets. Thanks
You can use both Hlookup and match to solve your problem, try using
this formula in the E8 cell:
=HLOOKUP(D8,IF(B8="Party1",Party1!2:180,IF(B8="Party2",Party2!
2:180,IF(B8="Party3",Party3!2:180,0))),IF(B8="Party1",MATCH(C8,Party1!
A:A,0)-1,IF(B8="Party2",MATCH(C8,Party2!A:A,
0)-1,IF(B8="Party3",MAT
I have attached sample file. I want formula for picking up rate from
excel sheets. Thanks in advance
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com
