Thanks everyone for the suggestions! Helped a great deal!!!


"Alan Beban" wrote:

Scott wrote:
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!
For another approach:

Highlight a1:c10; click on Data|Filter|AutoFilter; click on the down
arrow for Column A and select NewYork (or whatever city you're
interested in.

Alan Beban