Hey guys, I need some help with what would be the best way to design this.
So I have a workbook with 2 worksheets that I want to compare year-over-year. One set is from 2009 and one is from 2010. The 2 worksheets are sorted by name, and between 2009 and 2010 there have been different people working so it doesn't match up exactly.
I only want certain entries from these worksheets. There is a Name column (column D), an account column (column E) and a type column (F). I need to make sure these match perfectly. So for example, if the 2009 and 2010 sheet has
John Doe | Walmart | Cookies
I need to make sure it is verifying that all these 3 are the same. And then I want it to pull the corresponding row (G) which would be the amount.
However, if it is for example
John Doe | Walmart | Chocolate Cookies in 2009 and
John Doe | Walmart | Double Chocolate Cookies in 2010
I would not want that to show up.
The sheets have different names though because different people have been involved in between 2009 and 2010, so they do not match perfectly.
I was thinking of using an IF statement with an INDEX formula nested inside but I'm having trouble. Could anyone give me a hand?
So I have a workbook with 2 worksheets that I want to compare year-over-year. One set is from 2009 and one is from 2010. The 2 worksheets are sorted by name, and between 2009 and 2010 there have been different people working so it doesn't match up exactly.
I only want certain entries from these worksheets. There is a Name column (column D), an account column (column E) and a type column (F). I need to make sure these match perfectly. So for example, if the 2009 and 2010 sheet has
John Doe | Walmart | Cookies
I need to make sure it is verifying that all these 3 are the same. And then I want it to pull the corresponding row (G) which would be the amount.
However, if it is for example
John Doe | Walmart | Chocolate Cookies in 2009 and
John Doe | Walmart | Double Chocolate Cookies in 2010
I would not want that to show up.
The sheets have different names though because different people have been involved in between 2009 and 2010, so they do not match perfectly.
I was thinking of using an IF statement with an INDEX formula nested inside but I'm having trouble. Could anyone give me a hand?
