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