I have two work sheets and I am trying to have it look up the data in column
A of worksheet 1 (text-Names) to Column M in worksheet 2 and return the value
in worksheet 2 Column N if it matches. I did the following array formula but
it is not working.

Worksheet 1 is named Tina
Worksheet 2 is named Aug 08

{=SUM(('Aug 08'!$M$10:$M$438=Tina!A7)*('Aug 08'!$N$10:$N$438))}