I have a brain lock so I can't even do a search

I need the key strokes and terminology for this formula entry. I know it
takes a special key stroke entry but I can't remember it to fix the formula

Can someone help an old guy remember?

thanks

{=INDEX(Data!$D$2:$D$121,MATCH(1,($A$3=Data!$A$2:$ A$121)*($A7=Data!$C$2:$C$121),0))}

Click inside the formula bar, press CTRL+SHIFT+ENTER (CSE) to confirm the
formula. Excel will insert the curlies: { }. If you don't see the curlies
(I'd always do this visual check), re-do the CSE confirmation. Joy? thump the
YES below
--
Max
Singapore
---
"Dave" wrote:
> I have a brain lock so I can't even do a search
>
> I need the key strokes and terminology for this formula entry. I know it
> takes a special key stroke entry but I can't remember it to fix the formula
>
> Can someone help an old guy remember?
>
> thanks
>
> {=INDEX(Data!$D$2:$D$121,MATCH(1,($A$3=Data!$A$2:$ A$121)*($A7=Data!$C$2:$C$121),0))}
>
>

Hi Dave
Don't type the curly brace yourself, excel will put then in if you enter it
properly.
Just press Ctrl>Shift> Enter
HTH
John
"Dave" <(E-Mail Removed)> wrote in message
news:1D632F42-05D8-4910-A0B6-(E-Mail Removed)...
>I have a brain lock so I can't even do a search
>
> I need the key strokes and terminology for this formula entry. I know it
> takes a special key stroke entry but I can't remember it to fix the formula
>
> Can someone help an old guy remember?
>
> thanks
>
> {=INDEX(Data!$D$2:$D$121,MATCH(1,($A$3=Data!$A$2:$ A$121)*($A7=Data!$C$2:$C$121),0))}
>
>

Thanks :-)

I did click the yes

"Max" wrote:

> Click inside the formula bar, press CTRL+SHIFT+ENTER (CSE) to confirm the
> formula. Excel will insert the curlies: { }. If you don't see the curlies
> (I'd always do this visual check), re-do the CSE confirmation. Joy? thump the
> YES below
> --
> Max
> Singapore
> ---
> "Dave" wrote:
> > I have a brain lock so I can't even do a search
> >
> > I need the key strokes and terminology for this formula entry. I know it
> > takes a special key stroke entry but I can't remember it to fix the formula
> >
> > Can someone help an old guy remember?
> >
> > thanks
> >
> > {=INDEX(Data!$D$2:$D$121,MATCH(1,($A$3=Data!$A$2:$ A$121)*($A7=Data!$C$2:$C$121),0))}
> >
> >

welcome, and thanks
--
Max
Singapore
"Dave" <(E-Mail Removed)> wrote in message
news:960DD6B7-E3AD-45DD-85BE-(E-Mail Removed)...
> Thanks :-)
> I did click the yes

All is good. One question though, I am having a hard time remembering, this
formula is an array represented by the { }, correct?

Dave

"John" wrote:

> Hi Dave
> Don't type the curly brace yourself, excel will put then in if you enter it
> properly.
> Just press Ctrl>Shift> Enter
> HTH
> John
> "Dave" <(E-Mail Removed)> wrote in message
> news:1D632F42-05D8-4910-A0B6-(E-Mail Removed)...
> >I have a brain lock so I can't even do a search
> >
> > I need the key strokes and terminology for this formula entry. I know it
> > takes a special key stroke entry but I can't remember it to fix the formula
> >
> > Can someone help an old guy remember?
> >
> > thanks
> >
> > {=INDEX(Data!$D$2:$D$121,MATCH(1,($A$3=Data!$A$2:$ A$121)*($A7=Data!$C$2:$C$121),0))}
> >
> >
>
> .
>

Hi Dave
Yes, if you see those curlies, it's an array formula.
HTH
John
"Dave" <(E-Mail Removed)> wrote in message
news:B93EC238-CE21-4AF9-BB0F-(E-Mail Removed)...
> All is good. One question though, I am having a hard time remembering, this
> formula is an array represented by the { }, correct?
>
> Dave
>
> "John" wrote:
>
>> Hi Dave
>> Don't type the curly brace yourself, excel will put then in if you enter it
>> properly.
>> Just press Ctrl>Shift> Enter
>> HTH
>> John
>> "Dave" <(E-Mail Removed)> wrote in message
>> news:1D632F42-05D8-4910-A0B6-(E-Mail Removed)...
>> >I have a brain lock so I can't even do a search
>> >
>> > I need the key strokes and terminology for this formula entry. I know it
>> > takes a special key stroke entry but I can't remember it to fix the formula
>> >
>> > Can someone help an old guy remember?
>> >
>> > thanks
>> >
>> > {=INDEX(Data!$D$2:$D$121,MATCH(1,($A$3=Data!$A$2:$ A$121)*($A7=Data!$C$2:$C$121),0))}
>> >
>> >
>>
>> .
>>