First, thanks to Peo for helping me truncate time AND lookup all in one formula.
Second, I'd like help with an 'intersection' formula, if possible. For example, I have 100 rows and 100 columns, where row 1 is dates, and column A is times, and within are numbers. On a second sheet I have a column (A) with random dates and another (B) with times. What I need is a third column (C)on the second sheet that looks at the date and time, finds the intersection on the first sheet, and returns the number found there.
Thanks in advance for any advice.
Kiley
Bookmarks