Because of the keys pressed to create the array formula, they are sometimes referred to as CSE formulas.
In cell D10, typeProject A.
The formula will look in this cell to find which project to match.
error means that the formula was not entered correctly as an array.
This is where the formula results will display.
throw in the following formula in the cell:
Press and hold theCtrlandShiftkeys.
Press theEnterkey to create the array formula.
The formula returns the value of 24365 ($24,365) in cell E10.
