I have a 2008 trial balance (on its own worksheet) and in Column A consists
of all the GL codes.

In my 2007 trial balance (on its own worksheet), I also have Column A as all
the GL codes.

However, 2007's list of GL codes is not as long as 2008's list of GL codes.

Question: How can i make 2007's worksheet display all of 2008's GL codes and
keep the GL codes that overlap with 2007?

In 2007 Sheet Col B, cell B1 enter which will try to match the GL code of
2008 sheet and return "Exist" if it is found in 2008 list. Rename the
sheet2008 to whatever name you use

=IF(ISERROR(MATCH(A1,Sheet2008!A:A,0)),"","Exist")

If this post helps click Yes
---------------
Jacob Skaria


"Jonny54321" wrote:

I have a 2008 trial balance (on its own worksheet) and in Column A consists
of all the GL codes.

In my 2007 trial balance (on its own worksheet), I also have Column A as all
the GL codes.

However, 2007's list of GL codes is not as long as 2008's list of GL codes.

Question: How can i make 2007's worksheet display all of 2008's GL codes and
keep the GL codes that overlap with 2007?