I have a list of zipcodes, and I want to be able to place this list on one
sheet and in another type in a certain zip, lets say 77059 and in the cell
next to that Excel tells me "Houston". I have done it before (long time ago)
and can't remember how I did it. I thought it was a VLOOKUP funtion.

Thanks!

Hi, Jason. Perhaps this will jog your memory:
http://www.officearticles.com/excel/...soft_excel.htm

*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"Jason Spence" wrote in message
...
I have a list of zipcodes, and I want to be able to place this list on one
sheet and in another type in a certain zip, lets say 77059 and in the cell
next to that Excel tells me "Houston". I have done it before (long time
ago)
and can't remember how I did it. I thought it was a VLOOKUP funtion.

Thanks!

Helped a little, now I am getting a "#REF!" message in my return field.

Here is what I have, 1st worksheet named "Markets", in column A I have a
list of SCF codes (ex. 336) in column B I have the cooresponding names of the
SCF (ex Tampa) in Column C I have the state (ex. FL)

In worksheet 2 I have the same headers (Zip, Market, ST)
In A2 (where I would type in "336" or whatever)
In B2 (the formula, which should give me my return)
formula as follows: =VLOOKUP(A3,Markets!$A$1:$A$938,2,TRUE)

Can anyone please tell me why I am getting the weird return in B2 (#REF!)



"Anne Troy" wrote:

Hi, Jason. Perhaps this will jog your memory:
http://www.officearticles.com/excel/...soft_excel.htm

*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"Jason Spence" wrote in message
...
I have a list of zipcodes, and I want to be able to place this list on one
sheet and in another type in a certain zip, lets say 77059 and in the cell
next to that Excel tells me "Houston". I have done it before (long time
ago)
and can't remember how I did it. I thought it was a VLOOKUP funtion.

Thanks!

This formula:

=VLOOKUP(A3,Markets!$A$1:$A$938,2,TRUE)

Says to bring back column 2 of the range A1:A938, but there isn't a column 2!

So

=VLOOKUP(A3,Markets!$A$1:$B$938,2,TRUE)

and if you want A3 to find an exact match, maybe:

=VLOOKUP(A3,Markets!$A$1:$B$938,2,False)



Jason Spence wrote:

Helped a little, now I am getting a "#REF!" message in my return field.

Here is what I have, 1st worksheet named "Markets", in column A I have a
list of SCF codes (ex. 336) in column B I have the cooresponding names of the
SCF (ex Tampa) in Column C I have the state (ex. FL)

In worksheet 2 I have the same headers (Zip, Market, ST)
In A2 (where I would type in "336" or whatever)
In B2 (the formula, which should give me my return)
formula as follows: =VLOOKUP(A3,Markets!$A$1:$A$938,2,TRUE)

Can anyone please tell me why I am getting the weird return in B2 (#REF!)

"Anne Troy" wrote:

Hi, Jason. Perhaps this will jog your memory:
http://www.officearticles.com/excel/...soft_excel.htm

*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"Jason Spence" wrote in message
...
I have a list of zipcodes, and I want to be able to place this list on one
sheet and in another type in a certain zip, lets say 77059 and in the cell
next to that Excel tells me "Houston". I have done it before (long time
ago)
and can't remember how I did it. I thought it was a VLOOKUP funtion.

Thanks!




--

Dave Peterson

Jason,
You're problem is at the "A1:A938". This should include the other
columns, including the column you're looking up. So it should be
something like "A1:C938".

Jason Spence wrote:
Helped a little, now I am getting a "#REF!" message in my return field.

Here is what I have, 1st worksheet named "Markets", in column A I have a
list of SCF codes (ex. 336) in column B I have the cooresponding names of the
SCF (ex Tampa) in Column C I have the state (ex. FL)

In worksheet 2 I have the same headers (Zip, Market, ST)
In A2 (where I would type in "336" or whatever)
In B2 (the formula, which should give me my return)
formula as follows: =VLOOKUP(A3,Markets!$A$1:$A$938,2,TRUE)

Can anyone please tell me why I am getting the weird return in B2 (#REF!)



"Anne Troy" wrote:

Hi, Jason. Perhaps this will jog your memory:
http://www.officearticles.com/excel/...soft_excel.htm

*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"Jason Spence" wrote in message
...
I have a list of zipcodes, and I want to be able to place this list on one
sheet and in another type in a certain zip, lets say 77059 and in the cell
next to that Excel tells me "Houston". I have done it before (long time
ago)
and can't remember how I did it. I thought it was a VLOOKUP funtion.

Thanks!