Not clear how you have arranged your data in Sheet2..Try the below test

In Sheet2 cell F1 enter the query date
In Sheet2 cell F2 enter the 'assigned letter'

Try the below formula in Sheet2....
=INDEX(Sheet1!A:A,MATCH(F2,OFFSET(Sheet1!A:A,0,
MATCH(F1,Sheet1!1:1)-1),0))

--
Jacob


"Kozmik" wrote:

Perhaps this will help
SHEET 1
DATE | 12/1 | 12/2 | 12/3
tom a | A | C | E
fred b | C | A | F
mary c | A | E | G
bill d | B | C | E

Would like the names retrieved and
dropped into the form {below} based on
assigned letter and by date I input

DUTIES DATE _12/1__

A | B | D | F |

A | B | E | F |

C | B | G | D |

Hope this makes more sense..