Help with { character entry in a formula

  • Thread starter Thread starter Dave
  • Start date Start date
D

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

I did click the yes

Max said:
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
Click to expand...
 
All is good. One question though, I am having a hard time remembering, this
formula is an array represented by the { }, correct?

Dave
 
Back
Top