Change:

If Range("C5").Value = Locations(Cells(1)) Then ' <=== ???
'do stuff here
end if


TO:

If Range("C5").Value = Range("Locations")(1) Then
'do stuff here
end if

This will check to see if Sheet1.Range("C5") matches the first item in your
Locations list. If it matches, your 'do stuff' will execute.
"Corey ...." wrote:

I have a named range in sheet2 called "Locations"

In sheet 1 i use a validation dropdown list on required cells to list the
Location values.
I am trying to identify IF the value chosen was a particular item from the
"Locations" list.

"Locations" = Sheet2 A1-A12

I selected the first value in the list in the Validation List in Sheet1
(which is actally Sheet2 A1)

How can i capture the correct cell value chosen?
If Range("C5").Value = Locations(Cells(1)) Then ' <=== ???
'do stuff here
end if


Corey....