MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Addressing YTD data (with vlookup) on another sheet - please help !!


Posted by Stephen Giles on June 18, 2001 6:48 AM


Posted by IML on June 18, 2001 11:12 AM

Stephen,
I'm glad you are getting closer. While I don't know I way to combine the formulas, your results still should be accurate. I was assuming you would hide column E on the Overtime sheet (which changes based on YTD!B2). Are you getting incorrect numbers when you change the date?

You can try to email the file if you like, but I may have trouble accessing it from this account. If so, I will post an note here saying so.

Ian