Hi,

I am using Index formula to find cell values but I also want to have same cell color. I am using this formula which finds only cell value not a cell color.

=IF(ISERROR(INDEX(Table3,SMALL(IF(Driver=$C48,ROW(Driver)),ROW(1:1)),4)),"",(INDEX(Table3,SMALL(IF(Driver=$C48,ROW(Driver)),ROW(1:1)),4)))

I will appreciate for your help.

Thanks....