"If" function or similar

  • Thread starter Thread starter Roy
  • Start date Start date
R

Roy

I have a list of employees and cost codes. I'm wondering how I get a excel to
insert a code from a list of code if another cell equals a certain employee.
 
Roy,

Without knowing your data layout a precise answer is diffcult but almost
certainly what you want is Vlookup something like this:-

=VLOOKUP(E1,A1:B20,2,FALSE)

Where:- E1 is the employee in question

A1 - B20 is a list of employees (Col A) and cost codes (Col B)

Mike
 
Suppose you had the list of employees in sheet1 column A in rows 1 to 20, and
their codes in sheet1 column B, rows 1 to 20.

If in Sheet 2, you had an employee name in A1 then the following formula in
B1 would return their code:

=VLOOKUP(A1,Sheet1!A1:B20,2,false)

Is that what you mean?

Sam
 
Use VLOOKUP (). VLOOKUP stands for vertical lookup and search for a value in
the first column of a table array and returns a value in the same row from
another column in the table array. Try the below formulas with a similar data
and try changing the name in Cell C2

C2 = employee name
In D2 try the below formula
=VLOOKUP($C$2,$A$2:$B$10,2,FALSE)

ColA ColB ColC ColD
Employee CostCode QueryNameAnswer
Adam 32 Marie =formula
Marie 24
Francis 33
Joel 34
Susan 26
- -
- -



If this post helps click Yes
 
You would normally use VLOOKUP for this. Suppose your list of
Employees and codes is in Sheet1, columns A and B, and in Sheet2 A2
you enter an employee name, Then you can put this formula in B2 of
Sheet2:

=VLOOKUP(A2,Sheet1!A:B,2,0)

Hope this helps.

Pete
 
Roy,

The consensus seems to be VLOOKUP...


Pete_UK said:
You would normally use VLOOKUP for this. Suppose your list of
Employees and codes is in Sheet1, columns A and B, and in Sheet2 A2
you enter an employee name, Then you can put this formula in B2 of
Sheet2:

=VLOOKUP(A2,Sheet1!A:B,2,0)

Hope this helps.

Pete
Click to expand...
 
Until the OP tells us the columns of data are the opposite way around to that
which we have all assumed and it becomes a left lookup :)

Mike
 
Back
Top