Posted to microsoft.public.excel.worksheet.functions

external usenet poster

Posts: 2

How can I lookup when match has more than one value?

Hi Ray,

Use the SUMIF function:

=SUMIF(A:A, "a", C:C)

Have a great day!

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode 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
Match and Lookup	Biocellguy	Excel Worksheet Functions	1	July 6th 07 01:48 AM
using MATCH, and LOOKUP	harvey1649	Excel Worksheet Functions	9	May 7th 07 07:05 AM
match, lookup ???	skimpw	Excel Worksheet Functions	0	August 14th 06 03:16 PM
Lookup? Match? pulling rows from one spreadsheet to match a text f	cjax	Excel Worksheet Functions	3	July 21st 06 02:51 PM
Lookup or Match	Robbyn	Excel Worksheet Functions	2	February 8th 05 10:29 PM

All times are GMT +1. The time now is 12:55 PM.

About Us

"It's about Microsoft Excel"