Hi,
I've been tasked with producing a Excel 2003 spreadsheet that looks at what remedial building works are outstanding and compares their asset numbers to a wallplanner which tells us when the next maintenance is due at each facilty. We want to do remedial jobs at the same as time as maintenance and there are hundreds, so it's not convenient to go through them one by one. Formulas are my weakness and unfortunately I've been playing with V and H Lookups and MATCH for days and am getting nowhere.
The formula needs to do the following:
Step 1 - Look at the asset numbers in the 'Outstanding Jobs' worksheet and find matches in the 'Wallplanner' worksheet.
Step 2 - Once a match is found in the 'Wallplanner' worksheet, look across the row for the nearest non-blank cell.
Step 3 - Return the date (which is the column title of the non-blank cell) under 'Maintenance Next Due Date' on the 'Outstanding Jobs' worksheet.test2.xls
Bookmarks