Help Needed (LookUp or Match)

[viswadevan]

Hi Guys,

I'm stuck in macro. as i'm a newbie...

i need help to choose which function to use.

I've data on A1 to A27.
Eg;A3 contains BGA16. I also have a sheet named BGA16.
I need to write the following formula =Countif(BGA16!g:g, LDY) into C3.

Product Ongoing LDY
BGA16 (Formula) (Formula)

PLease help me out... greatly need it.

[IMG]file:///C:/Documents%20and%20Settings/Viswa%20Devan%20Nair/My%20Documents/My%20Pictures/Test.jpg[/IMG]

[shrivallabha]

Welcome to VBAX.
You can use a formula like:

=COUNTIF(INDIRECT(A3&"!G:G"),"LDY")

[viswadevan]

Thanks alot bro...
it works well.