Hi Scott,

What do you wish Excel to do?
Overwrite the first values found?
Give more values and thereby possibly overwrite others formulas?

Please elaborate on what you're trying to achieve.

--
Kind regards,

Niek Otten

"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!