Find column and row heading of value in a grid
I've got a grid of activities, with dates and times associated with each. If I want to search for a value by typing it into cell B9, how can I get that to display the date in B10 and the time in B11? I've tried using Index/Match, but so far I'm getting #N/A because it's only letting me search within a specific column instead of across the entire range.
