Hi,

Try this array formula (Ctrl+Shift+Enter). C4:C8 holds the incident #,
D4:D8 holds the Note and C12 holds 101

=TRIM(MCONCAT(IF($C$4:$C$8=C12,$D$4:$D$8," ")))

You may copy this formula down.

Also, MCONCAT is not a standard Excel funtion. You would need to download
and install this addin to use MCONCAT -
http://www.download.com/Morefunc/300...-10423159.html

Hope this helps.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Steve Albert" wrote in message
...
I have a spreasheet with two columns. The first column has a list of
Incident
numbers and the scond column has notes about the Incident (Table 1). If
some
of the Incident numbers are the same, how can i write a lookup to
concatenate
all of the note fields for one incident number (Table 2)?

Table 1
Incident # Note
------------ -----
101 This was completed yesterday.
102 Still in process.
103 Will complete tomorrow.
102 Called person on 8-5-09.
103 Delay in completing.


Table 2

Incident # Note
----------- -----
101 This was completed yesterday.
102 Still in process. Called person on 8-5-09.
103 Will complete tomorrow. Delay in completing.