I am assuming your zip codes in col A, row 2 of sheet2
try this in B2 of sheet2
=INDEX(Sheet2!A1:A10,MATCH(A2,Sheet2!$G$1:$G$10,0) )
this will pull the first name
in C2 of sheet2
=INDEX(Sheet2!B1:B10,MATCH(A2,Sheet2!$G$1:$G$10,0) )
this will pull the last name

Select B2 and C2, copy down
yoy can use whole column as your reference if you want to.
--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked

Thank You

cheers, francis

Am not a greek but an ordinary user trying to assist another



"BStacy" wrote:

No, the Zip Code is separate from the address.

The fields in Worksheet 1 look like:

FirstName, LastName, Address1, Address2, City, State, Zip, Phone, Specialty

Worksheet 2 only has a Zip Code field.



"Francis" wrote:

Is you zip codes in the full addresses? if yes, traditional Vlookup can't
get the result.

Post your formula and a small sample of your data in sheet1 and sheet2

--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked

Thank You

cheers, francis

Am not a greek but an ordinary user trying to assist another



"BStacy" wrote:

I have a spreadsheet with a worksheet with several thousand physician names,
addresses, etc.

In another worksheet in the same file I have a list of about 200 zip codes.

I need to pull all of the physicians from worksheet 1 that have office
addresses in the zip codes in worksheet 2.

I tried using VLOOKUP but I'm doing something wrong and it's not working.
Can someone tell me if VLOOKUP is the best function to use and how to use it
for this situation?