For both site and locality, how about this...
Application.VLookup(range("F6"), Worksheets("List").Range("B3:C5"), 2,
False)
--
MattShoreson
------------------------------------------------------------------------
MattShoreson's Profile:
http://www.excelforum.com/member.php...fo&userid=3472
View this thread:
http://www.excelforum.com/showthread...hreadid=563633