Hi there...I have two worksheets...both downloaded from different systems. I need to be able to look up the EMPID AND the question from worksheet 1 to pull the answers from worksheet 2. I don't want to have to concatenate columns Please help!
Worksheet 1
A B C D
1 EMPID What have I done What haven't I done What Can I do
2 10777
3 10778
Worksheet2
A B C
1 10777 What have I done Not alot
2 10777 What haven't I done Quite a bit
3 10777 What can I do As little as possible
4 10778 What have I done Been very Busy
5 10778 What haven't I done Done everything
etc (there are about 10000 lines)
Bookmarks