Conditional formatting using VLOOKUP

[tamdunk]

Hi, I'm trying to set up conditional formatting where it's highlighted if someone has reached a certain number of checks in a column from another worksheet. I want it to check every row of column A and apply formatting if there has been more than 5 checks.

Sheet1
Column A is the users ID
Column F is where I want the conditional formatting to apply

Sheet 2
Column A is the users ID
Column H is the number of checks the user has had.

In the rule description for the conditional formatting I have used
=VLOOKUP(A:A, Sheet2!A2:H388, 8, FALSE) > 5

But it's not working. Does anyone know where I am going wrong?

 

[Scott T]

The lookup_value of vlookup can not be an array

=VLOOKUP([COLOR=#FF0000]A:A[/COLOR], Sheet2!A2:H388, 8, FALSE) > 5

Select the cells in F that you want to conditional format and use this formula. Since the lookup value of A2 is a relative reference it will change as CF moved to the next row to A3 then A4....

=VLOOKUP(A2,Sheet2!$A$2:$H$388,8,0)>5

 

[tamdunk]

Thanks a lot, that's great. Still trying to get my head around the lookup function.

 

[Joe4]

Still trying to get my head around the lookup function.

There are lots of great tutorials you can find out there with a basic Google search.
Here is one: https://www.techonthenet.com/excel/formulas/vlookup.php