I am very much perfect in VLOOKUP().
But I dont want to show formulas in my excel sheet form. The form which I
am creating is multi user form.
The person using this form not aware of employee number. If he enter name,
he should get corresponding employee number.
This form keep on passing to different person.
Please help me if any body has solutions or macros


"bj" wrote:

If it for security or something else you dont want to use Vlookup()?
If it is for Security, You could potencially use a macro on your system
which would allow you to extract the Employee number and paste it into the
cell. If only you had access to the macro and database, then others would
not have to deny external file data updates to the data base when they open
the workbook.

"vishu" wrote:

Hi,

I have Employee name and employee number in one sheet.
In another sheet or another file if i type any employee name it shoud give
me employee number. I dont want to use Vlookup formula.
Is there any other way like validation or something else.
please help me...