Complicated Excel question... can anyone help?

[angrymissy]

<p>I'm usually pretty good with Excel, but this is stumping me.</p><p>I have one tab in my spreadsheet of zipcodes of certain customers.</p><p>I have another tab that has every zip code in the US in one column, then another column that shows the sales territory that is assigned to that zip code.</p><p>What I want to do is, on the first tab, make a 2nd column next to the list of customer zip codes, that will look up the zip code/sales territory information from the second tab, match up the right zip code, then return the Sales territory that is assigned to that zip code.</p><p>Is this possible?&nbsp; I think I would use the &quot;LOOKUP&quot; Function but am drawing a blank right now.</p>

<BR><img src="http://www.ronfez.net/imagestorage/tiggy.gif" width="300" height="100" border="1"><BR>
"To announce that there must be no criticism of the president, or that we are to stand by the president right or wrong, is not only unpatriotic and servile, but is morally treasonable to the American public." [ Theodore Roosevelt ]

[badorties]

<p>&nbsp;</p><p>real easy, you need the <a href="http://www.uncc.edu/sysdev/HowTos/Excel/Using%20VLookup.htm" target="_blank">VLOOKUP</a> function ...</p>

<p><font color="#ffffff">.</font></p>
<img src="http://scripts.cgispy.com/image.cgi?u=badorties" border="0" /><br />

[angrymissy]

<p>Ugh, I'm stumped.&nbsp; The way I have it laid out is:</p><p>Sheet 1: Column A is list of customer zipcodes</p><p>Sheet 2: Column A is list of zipcodes, Column B is Territory associated with that Zip Code</p><p>VLOOKUP is giving me errors... I need it to look at Sheet1 Column A Zipcode, Lookup that Zipcode is Sheet2ColumnA, Reference the associated territory in Sheet2ColumnB, then return that territory name in Sheet1columnB.&nbsp; I've tried the tutorials on the web and its not working...</p>

<BR><img src="http://www.ronfez.net/imagestorage/tiggy.gif" width="300" height="100" border="1"><BR>
"To announce that there must be no criticism of the president, or that we are to stand by the president right or wrong, is not only unpatriotic and servile, but is morally treasonable to the American public." [ Theodore Roosevelt ]

[walking joint]

maybe its HLOOKUP

<img src="http://hometown.aol.com/satelitecam/images/sig_wk.jpg">
thanks for the sig SatCam...and thanks for bringing it back Furie

[angrymissy]

<p>I got it to work by carefully following the instructions on that link.&nbsp; It was the function where you enter in 1, 2, 3 etc for the column to pull the data from that was confusing me.</p><p>Thanks, my boss thinks I'm a genius now</p><br /><img height="100" src="http://www.ronfez.net/imagestorage/tiggy.gif" width="300" border="1" /><br />&quot;To announce that there must be no criticism of the president, or that we are to stand by the president right or wrong, is not only unpatriotic and servile, but is morally treasonable to the American public.&quot; [ Theodore Roosevelt ]

<font color=black>This message was edited by angrymissy on 6-15-05 @ 1:34 PM</font>

[Knowledged_one]

<p>you may also be able to do IF/THEN statements, but you already have it figured out so...........</p><p>But learning to do IF/THEN's will increase what Excel can do</p>

<IMG SRC="http://img.ranchoweb.com/images/aggie2323/celticssig.jpg">
Kicking it old school on the board again

[badorties]

<p>&nbsp;</p><p>it's really a great function that's made my job a lot easier ...</p>

<p><font color="#ffffff">.</font></p>
<img src="http://scripts.cgispy.com/image.cgi?u=badorties" border="0" /><br />

[angrymissy]

oh, I am very familiar with IF/THEN,&nbsp;that is how I was originally going to do it, but since there are 3000 lines of zipcodes to match up, that would have been a hell of a long IF/THEN query

<BR><img src="http://www.ronfez.net/imagestorage/tiggy.gif" width="300" height="100" border="1"><BR>
"To announce that there must be no criticism of the president, or that we are to stand by the president right or wrong, is not only unpatriotic and servile, but is morally treasonable to the American public." [ Theodore Roosevelt ]

[Dan]

I did the exact same thing in my old office (enter a zipcode and it tells you what department the customer belongs to).&nbsp; I definitly used a Lookup function of some sort.&nbsp; Let me see if I can get my hands on the sheet and I'll email it to you.<div><br /></div><div>In the meantime, I suggest trying to put it all on one sheet.&nbsp; I find that I have a lot of errors when I use multiple sheets.</div>