cong05072012
New Member
- Joined
- Sep 24, 2014
- Messages
- 4
Good day. I am in the process of compiling 2 worksheets. Both have common information (first and last names) and I need the ID number and supervisor name from the other.
I copy-pasted the information to the same sheet. I have < ID #, last.name, first.name, supervisor > columns (N74:Q186 to be exact) and I want to move it to the sheet where it has < ID #, first.name, last.name, supervisor, location >.
First, I tried vlookup using the last name, but it pulls another employees information. Here's what I wrote:
=VLOOKUP(E74,$N$74:$Q$186,4)
Next I tried index/match based on the Mr.Excel article, but I just get an error. Here's what I wrote:
=INDEX($Q$74:$Q$186,MATCH(E74,$N$74:$Q$186,FALSE),1)
I am trying to match the employee's last name (E) to get the supervisor's name (Q). I have also used false and 0 but I still get the same error.
Thanks in advance!
I copy-pasted the information to the same sheet. I have < ID #, last.name, first.name, supervisor > columns (N74:Q186 to be exact) and I want to move it to the sheet where it has < ID #, first.name, last.name, supervisor, location >.
First, I tried vlookup using the last name, but it pulls another employees information. Here's what I wrote:
=VLOOKUP(E74,$N$74:$Q$186,4)
Next I tried index/match based on the Mr.Excel article, but I just get an error. Here's what I wrote:
=INDEX($Q$74:$Q$186,MATCH(E74,$N$74:$Q$186,FALSE),1)
I am trying to match the employee's last name (E) to get the supervisor's name (Q). I have also used false and 0 but I still get the same error.
Thanks in advance!