VLookup, Array Formula Help

[pennynikkel]

Hi there,

I am looking for help on a formula.

On one worksheet I have a column of employee id's in A2. In B2, I have each employee id's promotion date.
On another worksheet, I have a list of the employee's in A2 and in B2 I have a list of pay dates. I would like a formula in cell C2 (Result column below) that tells me (yes or no) if the pay date is greater than the person's promotion date. I have some data below as an example.

Any help is much appreciated.

Sheet 1:
Employee Promotion Date
10000956 8/1/2012
04289551 9/1/2012

Sheet 2:
Employee Pay Date Result
10000956 6/15/2012 no
10000956 7/15/2012 no
10000956 8/15/2012 yes
10000956 9/15/2012 yes
04289551 6/15/2012 no
04289551 7/15/2012 no
04289551 8/15/2012 no
04289551 9/15/2012 yes
04289551 10/15/2012 yes

 

[Special-K99]

Untested

=IF(VLOOKUP(Sheet2!A2,Sheet1!A$2:B$3,2,0)>B2,"yes","no")
copy down Sheet2 column C

 

[Andrew Poulsom]

You can use the entire columns from Sheet1:

=IF(B2>=VLOOKUP(A2,Sheet1!A:B,2,FALSE),"yes","no")