Match multiple values for a date to a single value date

Giganews Newsgroups
Subject: Match multiple values for a date to a single value date
Posted by:  RJG (no_ma…@nomail.biz)
Date: Sun, 29 Mar 2009

I have data for a year of patient visits that I want to match to the
on-call Doc for that date

Sheet 1 pt and visit date

Sheet 2 date and doc on call

My problem is that there are multiple patients for each date

I would like to create a column in sheet 1 that has the doc on call for
each patient

in english (more or less)

if [(worksheet1 cell a1)=(date x)] then [worksheet 1 cell b1=(worksheet
2 docOnCall for Date x)]

date x exists in both worksheets, but is a unique value in worksheet 2,
can occur multiple times in worksheet 1

Can anybody help me translate this into an excel function?

THanks in advance

RG

Replies