Greetings Excel Gurus,
I submitted a post previously, and a forum guru responded with exactly what I was looking for by re-adjusting the layout of a workbook that I included and creating new working formulas. So as to understand the formula logic, I'm evaluating a part of a formula which uses MATCH. In my original workbook, I've copied the formula in cell G30 of the worksheet called Time Study (see attached WeekMonthTimeStudy.xls). Specifically:
=MATCH("Budget "&$A19&" hours:",'Weekly Status'!$D$13:$D$76,0)
But after copying it, the cell returns #VALUE!. However, that same formula (adjusted to reference the approriate cells) works perfectly in the spreadsheet that the guru gave me (i.e. Copy of WeekMonthTimeStudy.xls). When I copy that part of the formula in cell G28, specifically:
=MATCH("Budget "&$A16&" hours:",'Weekly Status'!$E$13:$E$72,0)
it returns the correct answer (i.e. "8").
I've compared the formatting between both spreadsheets and there's no difference. I would just use the new spreadsheet that I was given, but the layout is slightly different than the original "department standard". Excel Help points to a type mismatch, but if there is one, I can't find it. I'm sure it's an easy fix. Would someone be willing to compare the two spreadsheets to see what could be wrong?
Thanks much!
Emil
Bookmarks