Should have mentioned that that is an array formula, so commit with
Ctrl-Shift-Enter.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Alison" wrote in message
...
I am wracking my brain here.
I need to formulate a function
that will search a database for several records that match alphabetic
criteria
created from a formula on the template,
then look at another field containing numeric info in those records
and return back to me the largest of those numeric values.

No such luck.

VLOOKUP returns the first one it sees (sorting is not an option in my
case).
MAX doesn't look at criteria.
IF hasn't worked the way I had it.
DMAX doesn't work and you have to have the database open.

PLEASE HELP!!!!
I've already tried what's at the below post:


http://www.microsoft.com/communities...2fc761-3f6b-40
2c-82f6-ba1a8875c1a7&lang=en&cr=&pt=&catlist=&dglist=&ptli st=&exp=&sloc=en-u
s&mid=14871180-c699-40be-ae67-0284e231fa7e