t;> G3 is lookup_value
> >>
> >>
> >>
> >> =OFFSET(A2,MATCH(G3,A2:A13,0)-1,MATCH("total",A2:F2,0)-1)
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >> Warm Regards,
> >>
> >>
gt;>
>> =OFFSET(A2,MATCH(G3,A2:A13,0)-1,MATCH("total",A2:F2,0)-1)
>>
>>
>>
>>
>>
>>
>>
>> Warm Regards,
>>
>> Ravi Kumar.
>>
>>
>>
>> From: excel-macros@googlegroups.com [mailto:excel-macros@googlegro
ay, September 14, 2013 10:03 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Query on vlookup
>
> ** **
>
> Try this formula
>
> *=VLOOKUP(H3,A3:G13,MATCH("TOTAL",$A$2:$G$2,0),0)*
>
> On 14-09-2013 11:28, Shrinivas Shevde wr
cel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Query on vlookup
Try this formula
=VLOOKUP(H3,A3:G13,MATCH("TOTAL",$A$2:$G$2,0),0)
On 14-09-2013 11:28, Shrinivas Shevde wrote:
Dear All
Query on vlookup
Please look at the attached sheet.
Thanks in advance
--
Shrin
Try this formula
*=VLOOKUP(H3,A3:G13,MATCH("TOTAL",$A$2:$G$2,0),0)*
On 14-09-2013 11:28, Shrinivas Shevde wrote:
Dear All
Query on vlookup
Please look at the attached sheet.
Thanks in advance
--
Shrini
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
It’s =TIME(2,DO:IT,
=VLOOKUP(F3,A:E,MATCH("Total",$2:$2,0),0)
On Sat, Sep 14, 2013 at 9:58 AM, Shrinivas Shevde wrote:
> Dear All
> Query on vlookup
> Please look at the attached sheet.
>
> Thanks in advance
>
> --
> Shrini
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME
Dear All
Query on vlookup
Please look at the attached sheet.
Thanks in advance
--
Shrini
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use c
