E
Excel Formula question
How do I set up a formula in a tab that can locate the same data as a
specific cell in that tab and match it to the other tab and the result giving
me infor in that same column? For example. Tab 1 contains: the following
columns: First Name, Last Name and Company...it is 15k lines. Tab 2 contains,
First Name, Last Name and Company, it has 1k lines. I want to make sure that
the companies in tab 2 matches what is in tab 1. Other than doing a search
and find with the last names in Tab 1 over a thousand times, is there a
formula that I can use? I tried =LOOKUP(A1,Tab1A1:A15,000,C1:C15,000) but
that did not give me the right answer. HELP!
specific cell in that tab and match it to the other tab and the result giving
me infor in that same column? For example. Tab 1 contains: the following
columns: First Name, Last Name and Company...it is 15k lines. Tab 2 contains,
First Name, Last Name and Company, it has 1k lines. I want to make sure that
the companies in tab 2 matches what is in tab 1. Other than doing a search
and find with the last names in Tab 1 over a thousand times, is there a
formula that I can use? I tried =LOOKUP(A1,Tab1A1:A15,000,C1:C15,000) but
that did not give me the right answer. HELP!