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