On Mar 24, 6:15 am, "Sandy Mann" wrote:
John,

=IF(B2="June",A1,"")

If by chance B2 contains an Excel date then use:

=IF(MONTH(B2)=6,A1,"")

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk

"John" wrote in message

...



I am trying to have excel evaluate one cell for a particular month and
return
the information found in a seperate cell if it is true. IE.

If B2 = "June", then return the information in A1 (which would be a name
"Thompson"). Also if it does not say "June" then it leaves it blank.

Thompson
Capt I Blue
ER Due June

Thank you
John- Hide quoted text -

- Show quoted text -

What if you have 12 months (Jan-dec) how do you pick the particular
month to show data for that month only?