Hi Steve,

Am Tue, 14 Apr 2015 21:09:20 +0100 schrieb SteveRH:

Column A Column B Column C
Milestone Actvity Week
- Test 1 3
- test 2 2
- test 3 2
- test 4 3
Milestone test 5 1
- Test 6 3
Milestone Test 7 7
- Test 8 5
- Test 9 6
Milestone Test 10 4


Column F Column G
Week Milestone activity
1 test 5
2
3
4 Test 10
5
6
7 Test 7

in G2 try:
=IFERROR(INDEX(B:B,MATCH("Milestone"&F2,$A$1:$A$10 0&$C$1:$C$100,0)),"")
and insert the array formula with CTRL+Shift+Enter and copy down.


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional