thanks sir,but can u tell me that how to use in many columns, i means
how can i define column name because i have many columns in that i
have to apply vlookup request,can
u to plz send me the solution in excel file it will be very helpful
for me.one more thing iwant to ask u that i want a macro fo
thanks sir,but can u tell me that how to use in many columns, i means
how can i define column name because i have many columns in that i
have to apply vlookup request,can
u to plz send me the solution in excel file it will be very helpful
for me.one more thing iwant to ask u that i want a macro fo
Dim LookUp_value as variant
Dim LookupVector as range
Dim ColNum as Integer
Dim ans as Variant
'Assign the Values to Variables
Ans=WorksheetFunction.Vlookup(Lookup_Value,Lookup_Vector,Colnum,0)
On Sun, May 8, 2011 at 4:45 AM, STDEV(i) wrote:
> It would be easy for anyone in the group to respo
It would be easy for anyone in the group to respond, if you can send a set
of sample data.
On Sat, May 7, 2011 at 1:47 PM, maulik desai wrote:
> Hi All,
>
> I have excel database sheet
> I have created some excel output sheets (around 35 excel sheets) which
> gives me output data with the help
Hai
Will you send a copy of worksheet...
Thanks
On Sat, May 7, 2011 at 12:17 PM, maulik desai wrote:
> Hi All,
>
> I have excel database sheet
> I have created some excel output sheets (around 35 excel sheets) which
> gives me output data with the help of Vlookup fuction.
> But the problem is i
Hi All,
I have excel database sheet
I have created some excel output sheets (around 35 excel sheets) which gives
me output data with the help of Vlookup fuction.
But the problem is in every 3 months I have to change the database month
name & because of that I need to change the vlookup range also