First time poster, very new to excel… I have tried looking in the forums for an answer, but I don’t even know what I’m looking for, as evidenced by my post title. I’m hoping you can help me.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o
></o>
First off, I’m using XP and Excel 2007.
<o></o>
The Setup<o></o>
I have one workbook with 2 worksheets.
Sheet 1 contains a list of all employees in our organization, alphabetized by last name, with their email address in Column F.
Sheet 2 contains a list of all employees who have attended our basic leadership class, alphabetized by last name, with their email addresses in Column D.
<o></o>
The Need<o></o>
In Sheet 1, Column A, I want to write a formula that will look at each person’s email address(from Column F) in Sheet 1, and if that email address matches an email address in Column D of Sheet 2, then return a value “True”. (So that we know they did attend the class and meet the requirement.)
<o></o>
I know this is basic stuff, but I’m clueless. I really appreciate any help you can offer.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o></o>First off, I’m using XP and Excel 2007.
<o
></o>The Setup<o
></o>I have one workbook with 2 worksheets.
Sheet 1 contains a list of all employees in our organization, alphabetized by last name, with their email address in Column F.
Sheet 2 contains a list of all employees who have attended our basic leadership class, alphabetized by last name, with their email addresses in Column D.
<o
></o>The Need<o
></o>In Sheet 1, Column A, I want to write a formula that will look at each person’s email address(from Column F) in Sheet 1, and if that email address matches an email address in Column D of Sheet 2, then return a value “True”. (So that we know they did attend the class and meet the requirement.)
<o
></o>I know this is basic stuff, but I’m clueless. I really appreciate any help you can offer.
