Recent content by miyage

Hi. Im a bit stuck on how to attack this problem in vba and im sure someone has a basic solution for this: In Sheet1, I have A1: Start Date and A2: End Date In Sheet2, is the look up sheet. Its sorted by ColumnA: ColumnA.......ColumnB.....ColumnC...ColumnD...

Hi. I hope someone can easily resolve my problem. I would like to create an input box/user form to accept a START DATE(dd/mm/yyyy) then another one to accept an END DATE(dd/mm/yyy). Using these dates as parameters, I would like to search my Table worksheet based on the dates inputed and copy...

Thank you very much for your help. I just enclosed the formula with IF(ISERROR()) and worked like a charm. You're a Legend!

Lets say that the date ranges for each person dont overlap... to make it simple. And they do not go on their separate result page. Results are all in the same sheet across in a row under their corresponding date. Its preferable to have it horizontal but if it can be done vertically, why...

Yes, as you said, I guess I can always take a different approach and get the same result without going into such headache. Looking at your recommendation, I guess it will work. We can take this a different and much simpler approach and get the same result. If I simplify and revised my data in...

Indeed. Thats the problem im having. I can vlookup the first criteria but I cant think of another way to embed another nested horizontal lookup in the found row. Is there and array formula that can solve this? Thanks in advance.

Im sure someone can tell me that there is a simple solution to this lookup problem that I'm having for days now. Here's what worksheets look like: SHEET 1 has: Cell A1 Cell B1 Cell C1 Cell D1 Cell E1 Cell F1 Start End Duration Actual...