If account 2 will be the only one missing values,

copy Sheet1 to sheet3, and remove columns you don't need. next to account
1, use the vlookup function

in B2 or whatever column for the account 2 info

=if(isNA(Vlookup(A2,Sheet2!$A:$F,1,False)),"",Vloo kup(A2,Sheet2!$A:$F,1,Fals
e))

then drag fill down the column. Assume the account ID in book2 is

to get column F values change 1 to 6 in the 3rd argument to vlookup.

--
Regards,
Tom Ogilvy


"yalex " wrote in message
...
What I am trying to do is automatically compare totals in column F from
two different excel sheets according to their account ID. What I need
is to be able to pull both row F into the 3rd sheet and have the
account ID match side-by-side along with its corresponding total. The
reason is because sometimes Sheet 1 has an account that does not exist
in Sheet 2. The look I am trying to accomplish is manually displayed
below:

Account ID 1 Account ID 2
100 100
101 101
102
103 103
104 104

Thanks in advance for any assistance.

yalex


---
Message posted from http://www.ExcelForum.com/