Example Data

I am trying to turn ABCD into HIJK. from another forum i understand now =IFERROR(VLOOKUP(H1,A:B,2,FALSE),"") will find unique values, and i just apply this to both lists to find unique ones in both. But my problem now is the instance of "eric," which appears twice, and how to make this grab the correct $ amount (pay for eric 1 coming from 1 and pay for eric 2 coming from 2)

  • You provide just a table of stuff, with no explanation of what we're looking at or how the columns relate. It isn't obvious what the data represents or what the problem is. – fixer1234 Jan 12 at 17:09
  • I have companies (here “1”, “2”) with people who work at the companies underneath and their payrolls, which are in a separate column. Next to the company number, I have the total payroll, and then how that payroll is split between the employees. I get this data about the companies from two different sources, which are pulling different information for the companies (different employees, payrolls etc) which I am trying to reconcile to see where there are difference. – user983902 Jan 13 at 21:29
  • Welcome to SuperUser. Please refrain from asking the same question multiple times. – jrichall Jan 14 at 19:48

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Browse other questions tagged or ask your own question.