If/Then Formula Possibility

[El Dokablo]

I am relativly new to excel, but learning more everyday. I am stumped on whether there is a formula that is out there to help me for this issue.

I have information in columns B(employee id), E (Employee Listing), and P(Employee Group). Is there a formula that could be placed into column O (new employee id column) that would look something like this: If the information in P1 = the information that is in E1 (so the two employee names match) then the cell output in O would be the information that is in B1 (Employee Id)?

I am trying to auto populate the id from B1 which matches the name in E1 to show up in O1 when P1 matches the name in E1. I am sorry if this is confusing, I am just looking for an easy way to knock out the ID matching of 10k+ employees.

Thanks for any help.

[Marcol]

Hi El Dokablo

Welcome to the forum

You would do best to post a sample workbook showing Before and After.

It should clearly illustrate your problem and not contain any sensitive data.

You should also consider your thread title before the moderators get you....

Forum Rules here
http://www.excelforum.com/forum-rule...rum-rules.html

Cheers

[EDIT]

Ooops! to late

[teylyn]

If the information in P1 = the information that is in E1 (so the two employee names match) then the cell output in O would be the information that is in B1 (Employee Id)?

reading just this, maybe in O1

=if(P1=E1,B1,"")

[El Dokablo]

reading just this, maybe in O1

=if(P1=E1,B1,"")

That is it!!! Thank you so much.