Hello All,

It took me a while to figure out the following formula but it's not quite what I need: {=IFERROR(INDEX($C:$C,MATCH(1,(F$1=$B:$B)*($E2=$A:$A),0)),"")}

Column A is an integer
Column B is an integer
Column C is text (3 options, X,Y,Z)

Data will be added to columns A, B and C at the end of the week.

At the moment, the formula results in the table below but I would like something that would also add the additional results (e.g. 1,0 = XY rather than just X and 3,2 = XZ rather than X))

3 2 X 0 1 2 3 4 5
1 2 Y 0 X
1 0 X 1
4 4 Z 2 Y X
1 0 Y 3
3 2 Z 4 Z
5

The actual table is closer to 3500 x 70 and it takes forever for the formula to process (so long i've never waited for it to finish) so I'm hoping a macro will speed it up.

Thanks for any help.

N