I have a worksheet with a column (A) with dates. Some rows between dates are blank. I want to put a cell on another sheet that searches sheet1, column A for a particular date, and when that date is found, I want to get a value from another column, same row.
Example. I want to find date 7/1/12 in cells A2:A50 then show the result of column D, on that row, into another sheet. Can it be done?