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?
1 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)
