Hi,
Also try...
=SUMIF(A7:A291,D7,B7:B291)
On Fri, May 18, 2012 at 8:10 AM, Seraj Alam seraj.ala...@gmail.com wrote:
Hi Ashish,
You can try below formula also...
=INDEX(B:B,MATCH(D7,A:A,0))
On Wed, May 16, 2012 at 6:03 AM, ashish damor damor.ash...@gmail.comwrote:
Dear Sir,
Thanks
Dear All,
I have a list of industry in one column and in corresponding column
the rates as per industry are given. I want to create a formula
whereby when i selected a specific industry from the dropdown list
automatically the corresponding rate is displayed in next cell. I am
enclosing my
Dear Ashish Damor,
solved, sheet attached.
=VLOOKUP(D7,$A$7:$B$291,2,0)
Thanks Regards,
Prajakt Pande
+971551388482
**
On Wed, May 16, 2012 at 1:48 PM, ashish damor damor.ash...@gmail.comwrote:
Dear All,
I have a list of industry in one column and in corresponding column
the rates
Dear Sir,
Thanks for your very useful and prompt reply.
I am really very grateful to you.
Take care.
With regards,
Ashish
On 5/16/12, Prajakt Pande prajakt.pa...@gmail.com wrote:
Dear Ashish Damor,
solved, sheet attached.
=VLOOKUP(D7,$A$7:$B$291,2,0)
Thanks Regards,
Prajakt Pande