Hi,
Thanks its working, but if we have to match the index
On Sun, Jan 13, 2013 at 7:02 PM, >>Excel Beginner<< wrote:
> Hi,
>
>Make use of this formula
>
> "=ABS(INDIRECT("'sheet1'!"&"C"&MATCH(C2,Sheet1!$B$1:$B$5,0))-INDIRECT("'sheet1'!"&"C"&MATCH(B2,Sheet1!$B$1:$B$5,0)))"
> or check attachm
why we have to press CTRL+SHIFT+ENTER.
Its taking a lot of time to process the same.
On Sun, Jan 13, 2013 at 2:46 PM, ashish koul wrote:
> try attached workbook
>
>
> On Sun, Jan 13, 2013 at 2:31 PM, Smitha S R wrote:
>
>> HI,
>> Tried but returns #VALUE
>>
>>
>> On Sun, Jan 13, 2013 at 2:26 P
Hi,
Make use of this formula
"=ABS(INDIRECT("'sheet1'!"&"C"&MATCH(C2,Sheet1!$B$1:$B$5,0))-INDIRECT("'sheet1'!"&"C"&MATCH(B2,Sheet1!$B$1:$B$5,0)))"
or check attachment.
On Sun, Jan 13, 2013 at 2:21 PM, Smitha S R wrote:
> Hi,
>
> PFA the statement and correct the formula I have used.
> Its s
try attached workbook
On Sun, Jan 13, 2013 at 2:31 PM, Smitha S R wrote:
> HI,
> Tried but returns #VALUE
>
>
> On Sun, Jan 13, 2013 at 2:26 PM, ashish koul wrote:
>
>> Try this
>>
>>
>>
>> =INDEX(Sheet1!C:C,MATCH(Sheet2!A2&Sheet2!C2,Sheet1!$A$1:$A$5&Sheet1!$B$1:$B$5,0))-INDEX(Sheet1!C:C,MATCH(
HI,
Tried but returns #VALUE
On Sun, Jan 13, 2013 at 2:26 PM, ashish koul wrote:
> Try this
>
>
>
> =INDEX(Sheet1!C:C,MATCH(Sheet2!A2&Sheet2!C2,Sheet1!$A$1:$A$5&Sheet1!$B$1:$B$5,0))-INDEX(Sheet1!C:C,MATCH(Sheet2!A2&Sheet2!B2,Sheet1!$A$1:$A$5&Sheet1!$B$1:$B$5,0))
>
>
> press CTRL+SHIFT+ENTER
>
>
Try this
=INDEX(Sheet1!C:C,MATCH(Sheet2!A2&Sheet2!C2,Sheet1!$A$1:$A$5&Sheet1!$B$1:$B$5,0))-INDEX(Sheet1!C:C,MATCH(Sheet2!A2&Sheet2!B2,Sheet1!$A$1:$A$5&Sheet1!$B$1:$B$5,0))
press CTRL+SHIFT+ENTER
On Sun, Jan 13, 2013 at 2:21 PM, Smitha S R wrote:
> Hi,
>
> PFA the statement and correct the f
Hi,
PFA the statement and correct the formula I have used.
Its showing sum errors
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem,
