Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

You used curly brackets where ordinary parentheses atre needed.
Ther culy brackets around formulas enclose everything Including the =) and must not be entered, but are generated for display when the formula is entered for array-evaluation by Ctrl+Shift+Enter.

And you cannot do a horizontal lookup in a vertical array.

You used curly brackets where ordinary parentheses atre needed.
Ther culy brackets around formulas enclose everything Including the =) and must not be entered, but are generated for display when the formula is entered for array-evaluation by Ctrl+Shift+Enter.

And you cannot do a horizontal lookup in a vertical array.

Where did you get that flim-flam from?

You used curly brackets where ordinary parentheses atre are needed.
Ther The culy brackets around formulas enclose everything Including (including the =) and must not be entered, but are generated for display when the formula is entered for array-evaluation by Ctrl+Shift+Enter.

And you cannot do a horizontal lookup in a vertical array.

Where did you get that flim-flam from?