Dear Ravinder
thanks you for replay, you are saying this formula will not work =
VLOOKUP(K2,A2:K494,6,FALSE), I sure you understand what i wants write, so
is there any alternate way to get output
thanks you
On Thu, Dec 19, 2013 at 2:24 PM, Ravinder wrote:
> Your look up value is K2 however
Your look up value is K2 however your range is starting from A2, So formula
should be =vlookup(a2,a2:k494,6,false)
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Rupesh Patil
Sent: Thursday, December 19, 2013 1:54 PM
To: excel-macros@googlegroups.com
Su
Dear Rupesh,
put $ sign in between the ranges
like this
=VLOOKUP(K2,$A$2:$K$494,6,FALSE) it will work
Warm Regards,
Gawli Anil
On Thu, Dec 19, 2013 at 1:54 PM, Rupesh Patil
wrote:
> Hi Experts,
>
> =VLOOKUP(K2,A2:K494,6,FALSE)
>
> Can any one suggest me, what is wrong with above formula
>
