K
klmiura
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))}
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))}