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?
41 Answer
You can use the VLOOKUP function, with the following data sets:
sheet1: A2:D50; dates present in col. A, result in col. D
sheet2: A1="date to be found", B1="result"
=VLOOKUP(A1;sheet1!A:D;4;0)
