look-up values horizontally and reflect them vertically

Originally Posted by Ksenia

But why if I click in the cell with the formula, the content disappears then?

Its an array formula. When you will enter formula or change it hit Ctrl+Shift+Enter. Hitting only Enter will give you an error.