Hello,

I need some help to write a statement in the code below:

------------------------
Private Function VLookup(JobID, TotalHours)
SLAComp = "No"
If JobID = "twoworkingday" Then
If TotalHours < 48 Then
SLAComp = "Yes"
End If
ElseIf TotalHours < 8 Then
SLAComp = "Yes"
End If
VLookup = SLACompliance(JobID, TotalHours)
End Function
--------------------------

"twoworkingday" is the name of a range of cell from
another worksheet. How do I write the code in the
line "If JobID = "twoworkingday" Then"?

Thanks for your assistance.

Sheela