Dear Indian,no offence, but i can do that with a combination of different formulas but is there any other way of doing it since i would have to apply the formula in 2000 rows which would slow down the sheet.
I have to depend a lot on the reports send by people to me. They generally get the employee codes and names wrong (as in misspell it). So want to them to work in a sheet given by me. Where in if they insert the employee code the name and the designation would pop up in the right side. I can then...