wilmott.com

Im hoping someone here might be able to help me with an Excel issue I'm having. I have a particular cell that when you enter a date, it references all information relavent to that date. In Column 'A' I have dates and in Column D I have hours on sheet 'Hourly Data'.Im using the code: =OFFSET('Hourly Data'!A3,MATCH(A6,'Hourly Data'!A5:A6709,FALSE),13)A6 references the current date. The problem is this code only pulls up the first number referenced this date, but it is not sorting it by hour. So basically, it should say, if date = A6 and hour = B6 THEN pull up that referencing data from Hourly Data Column F, but I'm having a mental block. Any advice would be grateful!Sorry for the bad explination. A D F4/5/06 1 320004/5/06 2 500004/5/06 3 450004/7/06 1 50000

As per the instructions for the function "match", this only pulls up the number of the first cell that matches exactly. So if you have more than one cell that match, it will ignore the others.If you want to pick up the hours for all the cells that match that, you'll have to use a sumif, or an array formula.