The data looks like

A B C
1/1/06 crop 1 ryegrass
2/1/06 crop 1 ryegrass
7/1/06 crop 2 millett
12/5/06 crop 1 ryegrass

that data is generated in a query and changes greatly with each query but
will have no more than 2 crops and all crop numbers will remain consist
within each query. I need a function to allow me to lookup and return the
information from crop1 into a single cell and the same for crop2. since dta
is not sorted by crop lookup statements are not happy. any suggestions
regarding other functions or a way to pull the info out.