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.
insert a code from a list of code if another cell equals a certain employee.
M
Mike H
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
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
G
Gary''s Student
See VLOOKUP() in Excel Help.
S
Sam Wilson
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
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
J
Jacob Skaria
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
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
P
Pete_UK
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
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
S
Sam Wilson
Roy,
The consensus seems to be VLOOKUP...
The consensus seems to be VLOOKUP...
Pete_UK said:
M
Mike H
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
which we have all assumed and it becomes a left lookup
Mike