PDA

View Full Version : Help Needed (LookUp or Match)



viswadevan
06-12-2011, 01:08 AM
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.

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

shrivallabha
06-12-2011, 01:35 AM
Welcome to VBAX.
You can use a formula like:

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

viswadevan
06-12-2011, 06:10 PM
Thanks alot bro...
it works well.