Posted by John on April 07, 2001 9:04 PM
I have a list where there are four columns on Sheet 1.
A=Name, B=Phone, C=Company X Employee ID, D=Company Y Employee ID
Name Phone Company X Company Y
Mark 123-456-7890 888 222
John 103-555-0000 555 777
Then on Sheet 2, I have some cells with various data:
J2=Company Name which could be either Company X or Y.
I would like to create a formula in J3 that says look at J1, then with that employees name pick up the name of the Company in J2, then using that tell me the code of that employee under the respective column of company name.
J2= Company Y
J3 then equals 222.
I tried and tried working on this formula for several years as I have run into this problem before, but never found a solution myself, yet I do believe there to be a simple one with the help of a more advanced Excel user than myself. Thanks in advance for anyone taking the time to read this and/or provide a solution.