At witts end

[mjuarez]

I need to use v-check to compare two lists of employees, their start date, their hours, their hourly rate. (about 1600 names total but I only need to compare four columns) As this list changes monthly, I would like to be able to pull only the changes from one list to another. I have never used v-check in the past and was told this was the best way..Please help!

 

[xenou]

Hi,
perhaps by V-Check you mean a vlookup formula. Here is an example (for convenience these are small tables, side by side). In this case we found a change in F6, where the formula returns a "FALSE" value - meaning that the wage rates do not match.
More on vlookup: http://www.contextures.com/xlfunctions02.html

ξ

Excel Workbook
	A	B	C	D	E	F
3	EMP ID	Hourly Rate		EMP ID	Hourly Rate	TEST
4	1	$100.00		1	$100.00	TRUE
5	2	$85.00		2	$85.00	TRUE
6	3	$75.00		3	$95.00	FALSE
7	4	$75.00		4	$75.00	TRUE
8	5	$125.00		5	$125.00	TRUE
Sheet1

Excel 2003

Cell Formulas
Range	Formula
F4	=VLOOKUP(D4,$A$4:$B$8,2,0)=E4