Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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?

share|improve this question
    
I'm using Excel 2010 –  pisces Dec 11 '12 at 9:32
1  
You need to be sure that only one particular date in mentioned; thus 7/1/12 exists only once! Is that the case? –  Jacob Jan Tuinstra Dec 11 '12 at 10:08
    
there is only a single instance of each day of the month –  pisces Dec 11 '12 at 10:51
    
That sounds logical..... –  Jacob Jan Tuinstra Dec 11 '12 at 10:52

1 Answer 1

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)
share|improve this answer
1  
I some locales, you must use comma (,) rather than semicolon (;) to separate arguments to Excel formula functions. –  Scott Dec 11 '12 at 18:02
    
That's for sure a regional thing. I'm in CEST, and there semicolons are used! –  Jacob Jan Tuinstra Dec 11 '12 at 18:57

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.