Search for employee ID, based on Employee Name

Originally Posted by Bob Phillips

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.

thank you fotis for your help.
and thank you Bob for the clarification, i would have never got it to work without your help.