Complex Excel Vlookup or Other Solutions Welcome

[hscott82]

Hello, I am trying to create a solution to point out employees on a spreadsheet that need to be researched for hours processing. When they have over 40 hours they go on a spreadsheet we have to look at their worked location and hours columns.

I was thinking either a Vlookup or maybe even a Conditional Formatting that will highlight the Differences.

First, I need to look at their Base Rate (Column J) on Sheet 1, compare to their REG1 (out of other codes) Column N on Sheet 2 to see if they have a higher Rate paid in Column P; their could be multiple values.

Next I need to compare their Home Location (Column E) on Sheet 1 to their worked location on Sheet 2 (Column U).

I have images if it helps!

 

[DanteAmor]

As I mentioned in the previous post, the images are very small and cannot be seen.
It would help if your explanation is accompanied with sample data. That is to say:
- to look up the Employee - 12345, (number 12345 must be clearly seen in the sheet)
And so you continue with the whole explanation: description - data.

You can try uploading a range of excel sheet:

Upload an excel range:
XL2BB - Excel Range to BBCode

 

[hscott82]

Look Up Employee ID (B2), Home (D2) and Base (I2) all on "Research" tab compare to "Orig" Tab
Employee ID (C), Work Location (U) and Rate (P) and show if there is a difference...Employees on Orig tab are not always on the same line.

 

[DanteAmor]

I help you with the images.
Assuming you have your data like this on each sheet. In cell L2 I put a formula, I hope that works for you.

Book1
	A	B		D					I			L	M
1		Employee ID		Home					Base			Result
2		123		2					9.5			1
3
Research

Cell Formulas
Range	Formula
L2	L2	=COUNTIFS(Orig!$C$2:C$20,B2,Orig!$U$2:$U$20,D2,Orig!$P$2:$P$20,I2)

Book1
	A	B	C													P					U	V
1			SW#													Rate					Work
2			123													9.5					2
3
Orig

----------------------------------------------------
If your data is not like that, then let's start with those examples, tell me what data I change for which other data and I am updating the formula.