MattShoreson Wrote:
when your code goes into debug.
Show the immediate window with ctrl+g.

Type....
?site<enter

what result do you get?

do the same for locality...

?locality

These show up as error 2042.
I googled this and it states that it's the equivelnet of #N/A

But if i run it on the sheet with:

=VLookup(F6,List!B3:C5,2,False)

It returns ok

--
thegoone
-----------------------------------------------------------------------
thegooner's Profile: http://www.excelforum.com/member.php...fo&userid=3661
View this thread: http://www.excelforum.com/showthread.php?threadid=56363