Do I use a Look up?
 

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.

Do I use a Look up?
 

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

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

Wendy wrote:

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.

--

Dave Peterson

Do I use a Look up?
 

Thanks! With a little noodling, it worked.

"Dave Peterson" wrote:

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

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

Wendy wrote:

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.

--

Dave Peterson

Do I use a Look up?
 

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???

"Dave Peterson" wrote:

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

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

Wendy wrote:

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.

--

Dave Peterson

Do I use a Look up?
 

=if(a2="","",if(iserror(vlookup(...)),"",vlookup() )))

It's kind of redundant, but there's not a better way.



Wendy wrote:

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???

"Dave Peterson" wrote:

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

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

Wendy wrote:

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.

--

Dave Peterson


--

Dave Peterson