Oh ya... It is working SAM and ashish... Thanks to you both buddy... :)
On Sun, Dec 1, 2013 at 10:06 PM, Sam Mathai Chacko wrote:
> As Ashish mentioned, you need to correct the dates on the top row.
>
> Regards,
> Sam Mathai Chacko
>
>
> On Sun, Dec 1, 2013 at 8:58 PM, manish mishra wrote:
>
>>
Will be really thankful if you can attach the sheet as well.., along the
formatting to be done ?/
On Sun, Dec 1, 2013 at 8:50 PM, ashish koul wrote:
>
> =INDEX(Sheet2!$B$1:$CC$80,MATCH(Sheet1!$A2,Sheet2!$A:$A,0),MATCH(Sheet1!B$1,Sheet2!$B$1:$CC$1,0))
>
> change dates in top row
>
> On Sun, Dec
=INDEX(Sheet2!$B$1:$CC$80,MATCH(Sheet1!$A2,Sheet2!$A:$A,0),MATCH(Sheet1!B$1,Sheet2!$B$1:$CC$1,0))
change dates in top row
On Sun, Dec 1, 2013 at 8:48 PM, manish mishra wrote:
> When i am dragging it towards right why is it copying all ??
>
>
>
> On Sun, Dec 1, 2013 at 8:46 PM, manish mishra wro
When i am dragging it towards right why is it copying all ??
On Sun, Dec 1, 2013 at 8:46 PM, manish mishra wrote:
> can it be done with index match ??
>
>
>
> On Sun, Dec 1, 2013 at 8:37 PM, ashish koul wrote:
>
>> try this
>> =VLOOKUP($A2,Sheet2!$A$1:$CC$80,MATCH(Sheet1!B$1,Sheet2!$1:$1,0),0
can it be done with index match ??
On Sun, Dec 1, 2013 at 8:37 PM, ashish koul wrote:
> try this
> =VLOOKUP($A2,Sheet2!$A$1:$CC$80,MATCH(Sheet1!B$1,Sheet2!$1:$1,0),0)
>
> On Sun, Dec 1, 2013 at 7:52 PM, manish mishra wrote:
>
>> Whats Wrong with the applied formulae in the sheet attached ??
>>
try this
=VLOOKUP($A2,Sheet2!$A$1:$CC$80,MATCH(Sheet1!B$1,Sheet2!$1:$1,0),0)
On Sun, Dec 1, 2013 at 7:52 PM, manish mishra wrote:
> Whats Wrong with the applied formulae in the sheet attached ??
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:O
