Re: Employee number and name

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Thanks Bill - I'll give it a try now!

"Bill Kuunders" <bill.kuunders@xxxxxxxxxx> wrote in message
news:%23WfDURCqFHA.3204@xxxxxxxxxxxxxxxxxxxxxxx
> You need to have a table of two columns (or more for other info) where the
> first column is the
> emplyee number and the second is the name.
>
> =vlookup(A5,F3:G60,2,false) will give you
> the name of the empl# in A5 from the table.
> 2 stands for the second column of that table.
>
> --
> Greetings from New Zealand
> Bill K
>
> "Dave S" <cadasco@xxxxxxxxxxxxxxxx> wrote in message
> news:3n1fokF1986ksU1@xxxxxxxxxxxxxxxxx
>> Is there some way that when I enter an employees number in to a cell it
>> will return the name?
>>
>> Thanks for your help - Dave
>>
>
>


.

Relevant Pages

  • RE: Printing wide columns
    ... > I have a spreadsheet that I want to print. ... but the second column is very wide. ... > able to print the first column. ... Prev by Date: ...
    (microsoft.public.excel.misc)
  • Re: Employee number and name
    ... first column is the ... emplyee number and the second is the name. ... > Thanks for your help - Dave ... Prev by Date: ...
    (microsoft.public.excel.newusers)
  • Re: Subtracting two columns from diff tables
    ... > the first column of each table when match the first in the second table ... > is to subtract the second column ... Prev by Date: ...
    (comp.databases.ms-sqlserver)
  • Re: Total
    ... >From the sample data you have given what result set are you expecting from ... >I was wondering if i have a table and in the first column ... > second column is the names of product... ... Prev by Date: ...
    (microsoft.public.access.queries)
  • RE: Sorting?
    ... if the first column is column A and the second column column D ... Column one is not in ascending or descending order and the order ... Prev by Date: ...
    (microsoft.public.excel.misc)