You don't need it to be sorted, use vlookup for an exact match

=VLOOKUP(Lookup_Value,Lookup_Table,2,0)


--
Regards,

Peo Sjoblom



"bbranch" wrote in message
...
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.