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.
=INDEX(EmployeedIDs!B1:B20;MATCH(A1;EmployeedIDs!A1:A20;0))
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
MastahFez 
Register To Reply
Bookmarks