# VLookup, Array Formula Help

#### pennynikkel

##### New Member
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

### Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).
Untested

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

You can use the entire columns from Sheet1:

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

Replies
3
Views
89
Replies
3
Views
97
Replies
27
Views
425
Replies
2
Views
94
Replies
6
Views
203

1,202,988
Messages
6,052,944
Members
444,619
Latest member
Pawar537

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back