Hi All

I have a table that contains the following infromation in A2:FT6010
I need to lookup the information in FT witch is column 175 that matches critiera from A (date) and Name

If 1/2/05 and Kerry = 94.96%
EG
A[INDENT ]B[INDENT ]FT
1/02/2005[INDENT] Mathew[INDENT]100.00%
1/02/2005[INDENT] Kelly[INDENT ]98.25%
1/02/2005[INDENT] Paul[INDENT ]92.12%
1/02/2005[INDENT] Kerry[INDENT ]94.96%
1/02/2005[INDENT ]Rick[INDENT ]98.18%
2/02/2005[INDENT] Mathew[INDENT ]99.85%
2/02/2005[/NDENT ]Kelly[INDENT ]75.12%

Thanks