Search for employee ID, based on Employee Name
Hello Excel Forum Members
i have a somewhat easy problem for you guys to help me with. (hard for me, at the moment)
i have a list of Employee ID's in an excel spreadsheet (EmployeeIDs.xlsx)
it has Column A (name) Column B (ID)
on a separate excel spreadsheet i would like to be able to enter the the name of an employee and automatically populate the Employee ID field based on the EmployeeIDs.xlsx spreadsheet
how can i do this?
please help. thanks
Last edited by MastahFez; 04-16-2012 at 01:37 PM.
Hi
In A1, of your other Sheet, choose or type the Employed Name. In B1(or where you like, put this formula.
Hope, that helps you.
Please Login or Register to view this content.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
MastahFez,
Just in case you do not know, they use a semi-colon as a separator in Greek Excel, you will need to replace all ; in Fotis1991's formula with commas.
Originally Posted by Bob Phillips
thank you fotis for your help.
and thank you Bob for the clarification, i would have never got it to work without your help.
OOOHHHH!!!!
I always...., forget it!!!
@MastahFez. You are welcome! Glad, that helped, you.
We straddle the divide somewhat in the UK. We use a comma separator, but we are more aware of European differences than our US colleaguesOOOHHHH!!!!
I always...., forget it!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks