Excel 2003
Someone set up a Lookup formula for me in one row of my spreadsheet. Now I
have to apply that formula to approximately 100 rows in each tab and 30 sheet
tabs. How do I do this? You can't just copy and paste. When I do I get the
infamous error #N/A. How else can this be done?

Thank you