Help with { character entry in a formula

[Dave]

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))}

 

[Max]

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

 

[John]

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]

Thanks

I did click the yes

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]

welcome, and thanks

 

[Dave]

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

Dave

 

[John]

Hi Dave
Yes, if you see those curlies, it's an array formula.
HTH
John