Or, if you need to match a date with a name:

=MIN(IF((B1:B10TODAY())*(A1:A10=C1),G8:G13))
again entered using CTRL+SHIFT+ENTER
where A1:A10 list of names,B1:B10 dates and C1 name to lookup

HTH
JG

"NUMBnut" wrote:

I need a formula that will pick the next appt. day from today in a column.

ex. one client has appts. for 1/9 1/17 and 1/20, and today is 1/12. I need
it to pull up the 1/17 date as the next appt. day.