Re: Please can you help. I can not remember what the special formula step is.

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi Rick

If you are working with matrix formulas, you need to press:

CTRL + SHIFT + ENTER

every time the formula is changed.

Hopes it helps

//Per

"Rick" <maxtor@xxxxxxxxxxxx> skrev i meddelelsen news:q18ek.186933$jB5.74136@xxxxxxxxxxxxxxxx
some time ago a friend made a graph on a sheet for me.

Now he did something that to this day I have been unable to recall or find any documentation on, I can not even remember what is did in the sheet or how it worked.

All I know is all the formula did not work until he did this step.

I would imagine this will be easy if you know what it is this if just an example not the actual code.

The actual code used a number of if statements in it if I remember correctly.

Now this was the trick

The STD Code would look like this below.
=VLOOKUP(Sheet2!A1,Sheet3!A:E,2,0)


He then pressed two keys wile in the formula and the formula then looked like this.
Note " at the beginning and the end.
The formula did not work until he pressed the key combination and the formula was placed inside " ********* ".

"=VLOOKUP(Sheet2!A1,Sheet3!A:E,2,0)"

Can you explain this step and what is was doing.
Where is the documentation to this process in excel I am sure it must have a name.

Note
Just placing the formula inside " " does not work you have to press this key combination like ( Eg ctrl,shift,f2 ) this is not the actual key comb,

Thanks for your help.

Rick


.

Relevant Pages

  • Re: Nested if(and(or)) function?
    ... Similar to my previous array-entered formula... ... Rick ... > use ctrl + shift + enter ...
    (microsoft.public.excel.worksheet.functions)
  • Re: How do I read the registry?
    ... I started working with the OpenNETCF Registry stuff today. ... Rick ... > The CE.NET documentation is fine for those methods. ...
    (microsoft.public.dotnet.framework.compactframework)
  • GDM-17E10 Monitor - Ctrl-Button
    ... I have a 17E10 Monitor that works fine, ... documentation. ... It has an additional knob on the front labelled "CTRL". ...
    (comp.sys.sun.hardware)
  • Re: Neve Purepath "Channel in a box"
    ... Rick ... >> For Sale: ... >> Factory box and documentation. ...
    (rec.audio.pro)
  • Re: Java left shift and right shift operators.
    ... Sanny, please attribute your citations. ... shift using operators depending on shiftby is +ve or -ve? ... As for RTFMing, you will make zero progress as a programmer, in fact, you are not even a programmer unless you habitually and competently read and comprehend the documentation. ...
    (comp.lang.java.programmer)