Hi
This is my first attempt at array formulas, and I'm not having much luck.

My formula is:
{=SUM(VLOOKUP(GOAFCF,RelImpact,9,FALSE))} (accepted with the CSE, not just
Enter)

I want to lookup up the values in each cell in the GOAFCF table (5 rows, 7
columns), compare them to the values in the RelImpact table , and add up the
returned values in the 9th column.

The tables (named ranges) are on different worksheets than the answer
worksheet.

The GOAFCF table has a value in each cell.

The RelImpact table contains lookup values from 1 to 8 inclusive and merged
cells in columns 6 & 7 and 9 & 10. The lookup values are sorted ascending.
Each cell in the 9th column has a value in it, with one value being zero.

For example, if the GOAFCF table has 2 lookup values of 3, and one lookup
value of 4, it will return respective values of 2,500*2 and 5,000*1, giving a
total of 10,000. The remaining lookup values are 1, and return a value of
zero.

What am I missing, or am I misunderstanding what array formulas can do?

Thanks in advance
Zach T