software

I have a column of city names in excel FILE A. In the column directly to the
right of the city, I want a formula to lookup from FILE B and enter the
correct county name from another work sheet column.

FILE B contains a column of all the possible city names and a column of
their county names.

I'd be so happy to have some help on this. Thanks.

=vlookup(a2,sheet2!a:b,2)
would be the basic formula.

You may want to read Debra Dalgleish's notes:
www.contextures.com/xlFunctions02.html

Wendy wrote:
gt;
gt; I have a column of city names in excel FILE A. In the column directly to the
gt; right of the city, I want a formula to lookup from FILE B and enter the
gt; correct county name from another work sheet column.
gt;
gt; FILE B contains a column of all the possible city names and a column of
gt; their county names.
gt;
gt; I'd be so happy to have some help on this. Thanks.

--

Dave Peterson

Thanks! With a little noodling, it worked.

quot;Dave Petersonquot; wrote:

gt; =vlookup(a2,sheet2!a:b,2)
gt; would be the basic formula.
gt;
gt; You may want to read Debra Dalgleish's notes:
gt; www.contextures.com/xlFunctions02.html
gt;
gt; Wendy wrote:
gt; gt;
gt; gt; I have a column of city names in excel FILE A. In the column directly to the
gt; gt; right of the city, I want a formula to lookup from FILE B and enter the
gt; gt; correct county name from another work sheet column.
gt; gt;
gt; gt; FILE B contains a column of all the possible city names and a column of
gt; gt; their county names.
gt; gt;
gt; gt; I'd be so happy to have some help on this. Thanks.
gt;
gt; --
gt;
gt; Dave Peterson
gt;

I just posted another question -- I want to format the results that returned
#N/A to white so I don't have to look at them. I expected the few #N/A
results because there were cities (from other states) that did not have
corresponding counties. Maybe and IF function? If there's a VLookup match, if
not, return a blank???

quot;Dave Petersonquot; wrote:

gt; =vlookup(a2,sheet2!a:b,2)
gt; would be the basic formula.
gt;
gt; You may want to read Debra Dalgleish's notes:
gt; www.contextures.com/xlFunctions02.html
gt;
gt; Wendy wrote:
gt; gt;
gt; gt; I have a column of city names in excel FILE A. In the column directly to the
gt; gt; right of the city, I want a formula to lookup from FILE B and enter the
gt; gt; correct county name from another work sheet column.
gt; gt;
gt; gt; FILE B contains a column of all the possible city names and a column of
gt; gt; their county names.
gt; gt;
gt; gt; I'd be so happy to have some help on this. Thanks.
gt;
gt; --
gt;
gt; Dave Peterson
gt;

=if(a2=quot;quot;,quot;quot;,if(iserror(vlookup(...)),quot;quot;,vlookup() )))

It's kind of redundant, but there's not a better way.
Wendy wrote:
gt;
gt; I just posted another question -- I want to format the results that returned
gt; #N/A to white so I don't have to look at them. I expected the few #N/A
gt; results because there were cities (from other states) that did not have
gt; corresponding counties. Maybe and IF function? If there's a VLookup match, if
gt; not, return a blank???
gt;
gt; quot;Dave Petersonquot; wrote:
gt;
gt; gt; =vlookup(a2,sheet2!a:b,2)
gt; gt; would be the basic formula.
gt; gt;
gt; gt; You may want to read Debra Dalgleish's notes:
gt; gt; www.contextures.com/xlFunctions02.html
gt; gt;
gt; gt; Wendy wrote:
gt; gt; gt;
gt; gt; gt; I have a column of city names in excel FILE A. In the column directly to the
gt; gt; gt; right of the city, I want a formula to lookup from FILE B and enter the
gt; gt; gt; correct county name from another work sheet column.
gt; gt; gt;
gt; gt; gt; FILE B contains a column of all the possible city names and a column of
gt; gt; gt; their county names.
gt; gt; gt;
gt; gt; gt; I'd be so happy to have some help on this. Thanks.
gt; gt;
gt; gt; --
gt; gt;
gt; gt; Dave Peterson
gt; gt;

--

Dave Peterson