IF contains over multiple worksheets
This may be difficult to put into words, but I'm sure going to try!
I have two spreadsheets: one with Compensation Information and the other is an Attendance spreadsheet. I want the spreadsheet with Compensation information to calculate total Paid Vacation based on the following criteria: IF Cell C3 in Attendance - 2004.xls contains the same data as Cell C3 in Total Comp Report.xls, then I want it to calculate Attendance - 2004.xls Cell H6* Total Comp Report.xls Cell H2. Is this remotely possible? |
All times are GMT +1. The time now is 09:50 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com