Hi,
You can use below formulas:
*=VLOOKUP($A1,$F$1:$G$17,2,0)
*
*=INDEX($G$1:$G$17,MATCH($A1,$F$1:$F$17,0))
*
*=OFFSET($G1,0,0)*
Regards,
Kuldeep Singh
Info Edge India Limited (naukri.com)
Phone.: +91-0120-4841100, Extn.: 2467, 9716615535
naukrikuld...@gmail.com || www.naukri.com
*Please* *Consi
Dear
=VLOOKUP(A1,$E$1:$F$17,2,0)
get the result
Alpesh
On Wed, Apr 10, 2013 at 10:04 AM, अनिल नारायण गवली
wrote:
> Dear alanthomas,
>
> Put approximate match or exact match then the result will appear.
>
> =vlookup(value,range,columnno,true,false) or
> vlookup(value,range,columnno,1,0)
>
>
>
Dear alanthomas,
Put approximate match or exact match then the result will appear.
=vlookup(value,range,columnno,true,false) or
vlookup(value,range,columnno,1,0)
Warm Regards,
Gawli Anil
On Wed, Apr 10, 2013 at 6:43 AM, Sam Mathai Chacko wrote:
> If you want to look for exact matches, you mu
If you want to look for exact matches, you must use =VLOOKUP(Lookup_Value,
ArrayRangeToLookAt, Column_Index, Whether Approximate Match Or Not)
So try =VLOOKUP(A1,$E$1:$F$17,2,FALSE)
Regards
Sam Mathai Chacko
On Wed, Apr 10, 2013 at 5:51 AM, wrote:
> I am really confused about the behavior of
