Linking Columns

  • Thread starter Thread starter Michael
  • Start date Start date
M

Michael

Here is my issue. I have colmn "AA" as my names column and
column "AB" as the clock number for those in column "AA".
When a name is chose in column "AA", how can I get excel
to look at the number in column "AB" and put that number
in a cell automatically.

Thank You for your help and suggestions.

Michael
 
Hi Michael
not sure what you mean 'choose a name in column AA'. But if you want to
lookup the clock number for a specific employee try
=VLOOKUP(A1,AA1:AB999,2,0)
where A1 stores the employee name to search

HTH
Frank
 
Back
Top