Posted to microsoft.public.excel.worksheet.functions

external usenet poster

Posts: 34

Array Formula Help

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Find specific value in array of array formula	DzednConfsd	Excel Worksheet Functions	2	January 13th 09 06:19 AM
Array Formula	Gene L.	Excel Worksheet Functions	9	June 5th 08 04:32 PM
Array Formula	sharon t	Excel Discussion (Misc queries)	8	April 29th 08 04:44 PM
meaning of : IF(Switch; Average(array A, array B); array A)	DXAT	Excel Worksheet Functions	1	October 24th 06 06:11 PM
Array Formula - using LEFT("text",4) in formula	Andrew L via OfficeKB.com	Excel Worksheet Functions	2	August 1st 05 02:36 PM

All times are GMT +1. The time now is 08:29 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us