Hello Niek and Zack..thanks for the replies.

Niek: I do not want the previous value found overwritten. I'll give you an
example of what I am trying to achieve.

If I have NEW YORK in A1 and A2 with values in b1, c1 and b2 and c2, I want
to be able to type in NEW YORK and get the values in:
b1 c1
b2 c2

Hope thats clearer. Thanks again!


"Zack Barresse" wrote:

Hello Scott,

Maybe you could look at the VLOOKUPNTH by petermoran...

http://vbaexpress.com/kb/getarticle.php?kb_id=8

HTH

--
Regards,
Zack Barresse, aka firefytr, (GT = TFS FF Zack)



"Scott" wrote in message
...
Hello,

How can I get VLOOKUP to continue searching a column after it finds the
value it is looking for? For example..we have the following in A1 (NEW
YORK)
and in A2 (NEW YORK). I am able to pull up the values in b1 (# of
employees)
and c1 (total # of phones), but it does not seem to search passed A1 once
the
value is found.

Thanks in advance!