I am using Excel 2007. I have created a spreadsheet1 with a list of names and dates. The names and dates can be repeated. I have another spreadsheet 2 with names and formulas. Here the names are not repeated. The formulas adjust the dates for aging purposes. If the name on Spreadsheet 1 equals name on spreadsheet 2 I want the formula on Spreadsheet 2 to be used on Spreadsheet 1. The formulas are simple like E2+0
E2 being date 3/19/2009. Thank you for your help

Post up an an excerpt from both books and show us exactly what you mean.

Click on GO ADVANCED and use the paperclip icon to attach the sample workbooks.

I have attached a sample of both spreadsheets. The aging sheet changes daily. The customer sheet does not change it just has the formulas that apply to the customers for aging dates. I currently copy the formulas to the aging by customer name and number. I would like to somehow create a lookup that says if the name and customer number matches the list then use these formulas in column H-K on the aging sheet. Thanks for any help with this.

Note: I was not able to upload the file as a .xlsx file.

Your sheets and explanation are confusing. But what I think you are trying to say is that each customer has an aging factor. That factor is then added to the AsOf date to produce an aging date.

If that's what you want then, in your customer table, just add the factor. Then in your aging table use a formula like:

=E2+Vlookup(B2,Customers,x)

B2 is customer #, Customers is a name assigned to the Customers table, an x is the number of the column that contains the factor.

I wonder what you are gaining with these =+E2+0 formulas?

That's not the same thing as =E2 ?

=IF(+F2+0=0,"",+F2+0) ----> =IF(F20=0,"",F2)

Secondly, as Scott notes, your explanation and terms don't match. We've all done Aging reports, very common task. But your formulas don't appear to age anything, they just compare dates and hide/show them.

Aging means "How many months has this client been active?" Or, it means "How many months behind in payments is this client?"

Your sheet doesn't do either thing in the least. Confusing is the word.