Can Excel evaluate one cell and return the information in another?
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
|