comparing 2 sheets
 

Hi

I have 2 excel spreadsheets with balance sheet data:
Assets Jan Feb March
Current Assets
Total Assets
Current Liab
Total Liab

Etc.

My Second Sheet is in the Same format but has more details, and
sometimes the Headings have very slight differences - might have an
additional space between words, or leading or trailing spaces.

Rather that manually tick the line items here, I am trying to find a
way to compare these 2 at the Total Levels. I have toyed with Vlookup
but because of the issue I have mentioned the results are not always
accurate. I have to do this for about 100 sheets.

Any ideas on what function I can best use to accomplish this, or how to
force vlookup to make the connections I an trying to get at.


Thanks
Fr


--
studentcog
------------------------------------------------------------------------
studentcog's Profile: http://www.excelforum.com/member.php...o&userid=31561
View this thread: http://www.excelforum.com/showthread...hreadid=512553

comparing 2 sheets
 

Apart from the function TRIM(), which removes leading, trailing and
multiple sequential spaces I cannot suggest anything more concrete as
"compare" is too vague. If you need to search a certain value in a
table, where this value might appear with additional spaces, you can do
the following:

=VLOOKUP(A1, TRIM(C2:C100), 2, 0)

This one needs to be array-entered (Shift+Ctrl+Enter).

On the other hand, if you are guaranteed the other table is free of
extra spaces but your current one might have some, you use the
opposite:

=VLOOKUP(TRIM(A1), C2:C100, 2, 0)

No need to array-enter this one.

Does this help?

Kostis Vezerides