How do I??
 

I have a worksheet that has 2 columns on it 1 is numbers and the others are
names. I want to be able to export a group of names from one of my programs
and then have excel match the name and dump the corresponding number into the
spreadsheet. I beleive I can use vlookup but I am not certain
--
SAH

How do I??
 

If you could give us some sample data and tell us what columns they are
located in, we could give you an equation that would work for you.

"Scott" wrote:

I have a worksheet that has 2 columns on it 1 is numbers and the others are
names. I want to be able to export a group of names from one of my programs
and then have excel match the name and dump the corresponding number into the
spreadsheet. I beleive I can use vlookup but I am not certain
--
SAH

How do I??
 

This is the reference sheet in a workbook called pub id's.

30380170 Collierville Herald
30376440 Elizabethton Star
30381380 Germantown News
11444920 Johnson City Press


This is the worksheet I am trying to perform the function on. I want excel
to match the name in the second column below, to the name in the second
column of the refernce sheet and then return the number it finds in the first
column of the refernce sheet to the corresponding cell below

The Anderson Journal
The Anson Record
Butner-Creedmoor News
Collierville Herald
The Courier News
Courier Times

Sp for example when I set it up it would look in hte first workshhet for the
"Collierville Herald" find it and then return the number 30380170 to the cell
to the left of the name in the second worksheet.







--
SAH


"Barb Reinhardt" wrote:

If you could give us some sample data and tell us what columns they are
located in, we could give you an equation that would work for you.

"Scott" wrote:

I have a worksheet that has 2 columns on it 1 is numbers and the others are
names. I want to be able to export a group of names from one of my programs
and then have excel match the name and dump the corresponding number into the
spreadsheet. I beleive I can use vlookup but I am not certain
--
SAH

How do I??
 

Hi Scott,

if I undestand your question you have

Col A Col B
1 John
2 Paul
3 Scott

and in another place you will have
Col A Col B
Scott Vlookup function to return 3

if it is correct my sugestion is create a C column on the original range
with =a2 (numbers) and copy it down (just to have the look figures on the
right column)

so the function should be =vlookup(a2,sheet1!b2:c100,2,0)

HTH
Regards from Brazil
Marcelo


"Scott" escreveu:

I have a worksheet that has 2 columns on it 1 is numbers and the others are
names. I want to be able to export a group of names from one of my programs
and then have excel match the name and dump the corresponding number into the
spreadsheet. I beleive I can use vlookup but I am not certain
--
SAH

How do I??
 

close
in your example

Col a Col b
1 John
2 Paul

are in a seprate worksheet


Then in the other worksheet it will look like this

Col A Col B
John
Paul



I want it to match John to John and return the value of 1 to Col A of the
second worksheet


--
SAH


"Marcelo" wrote:

Hi Scott,

if I undestand your question you have

Col A Col B
1 John
2 Paul
3 Scott

and in another place you will have
Col A Col B
Scott Vlookup function to return 3

if it is correct my sugestion is create a C column on the original range
with =a2 (numbers) and copy it down (just to have the look figures on the
right column)

so the function should be =vlookup(a2,sheet1!b2:c100,2,0)

HTH
Regards from Brazil
Marcelo


"Scott" escreveu:

I have a worksheet that has 2 columns on it 1 is numbers and the others are
names. I want to be able to export a group of names from one of my programs
and then have excel match the name and dump the corresponding number into the
spreadsheet. I beleive I can use vlookup but I am not certain
--
SAH

How do I??
 

OK Scott, try this

First ws
Col a Col b Col C
1 John =A2 returns 1
2 Paul =A3 returns 2

second ws
Col A
Col B
=vlookup(B2,Sheet1!$B$2:$C$3,2,0) returns 1 John

HTH



"Scott" escreveu:

close
in your example

Col a Col b
1 John
2 Paul

are in a seprate worksheet


Then in the other worksheet it will look like this

Col A Col B
John
Paul



I want it to match John to John and return the value of 1 to Col A of the
second worksheet


--
SAH


"Marcelo" wrote:

Hi Scott,

if I undestand your question you have

Col A Col B
1 John
2 Paul
3 Scott

and in another place you will have
Col A Col B
Scott Vlookup function to return 3

if it is correct my sugestion is create a C column on the original range
with =a2 (numbers) and copy it down (just to have the look figures on the
right column)

so the function should be =vlookup(a2,sheet1!b2:c100,2,0)

HTH
Regards from Brazil
Marcelo


"Scott" escreveu:

I have a worksheet that has 2 columns on it 1 is numbers and the others are
names. I want to be able to export a group of names from one of my programs
and then have excel match the name and dump the corresponding number into the
spreadsheet. I beleive I can use vlookup but I am not certain
--
SAH

How do I??
 

I tried it and it returns n/a
--
SAH


"Marcelo" wrote:

OK Scott, try this

First ws
Col a Col b Col C
1 John =A2 returns 1
2 Paul =A3 returns 2

second ws
Col A
Col B
=vlookup(B2,Sheet1!$B$2:$C$3,2,0) returns 1 John

HTH



"Scott" escreveu:

close
in your example

Col a Col b
1 John
2 Paul

are in a seprate worksheet


Then in the other worksheet it will look like this

Col A Col B
John
Paul



I want it to match John to John and return the value of 1 to Col A of the
second worksheet


--
SAH


"Marcelo" wrote:

Hi Scott,

if I undestand your question you have

Col A Col B
1 John
2 Paul
3 Scott

and in another place you will have
Col A Col B
Scott Vlookup function to return 3

if it is correct my sugestion is create a C column on the original range
with =a2 (numbers) and copy it down (just to have the look figures on the
right column)

so the function should be =vlookup(a2,sheet1!b2:c100,2,0)

HTH
Regards from Brazil
Marcelo


"Scott" escreveu:

I have a worksheet that has 2 columns on it 1 is numbers and the others are
names. I want to be able to export a group of names from one of my programs
and then have excel match the name and dump the corresponding number into the
spreadsheet. I beleive I can use vlookup but I am not certain
--
SAH

How do I??
 

Hi, Scott, it is sound strage.

try to check if the Johns are equal =sheet1!b2=B2 just to check it is true

"Scott" escreveu:

I tried it and it returns n/a
--
SAH


"Marcelo" wrote:

OK Scott, try this

First ws
Col a Col b Col C
1 John =A2 returns 1
2 Paul =A3 returns 2

second ws
Col A
Col B
=vlookup(B2,Sheet1!$B$2:$C$3,2,0) returns 1 John

HTH



"Scott" escreveu:

close
in your example

Col a Col b
1 John
2 Paul

are in a seprate worksheet


Then in the other worksheet it will look like this

Col A Col B
John
Paul



I want it to match John to John and return the value of 1 to Col A of the
second worksheet


--
SAH


"Marcelo" wrote:

Hi Scott,

if I undestand your question you have

Col A Col B
1 John
2 Paul
3 Scott

and in another place you will have
Col A Col B
Scott Vlookup function to return 3

if it is correct my sugestion is create a C column on the original range
with =a2 (numbers) and copy it down (just to have the look figures on the
right column)

so the function should be =vlookup(a2,sheet1!b2:c100,2,0)

HTH
Regards from Brazil
Marcelo


"Scott" escreveu:

I have a worksheet that has 2 columns on it 1 is numbers and the others are
names. I want to be able to export a group of names from one of my programs
and then have excel match the name and dump the corresponding number into the
spreadsheet. I beleive I can use vlookup but I am not certain
--
SAH

How do I??
 

Try this:

=INDEX(Reference!$A$3:$A$6,MATCH(A1,Reference!$B$3 :$B$6,0))

Note, I only saw one match between your reference data and your test data
(Collierville Herald)
--
Kevin Vaughn


"Scott" wrote:

This is the reference sheet in a workbook called pub id's.

30380170 Collierville Herald
30376440 Elizabethton Star
30381380 Germantown News
11444920 Johnson City Press


This is the worksheet I am trying to perform the function on. I want excel
to match the name in the second column below, to the name in the second
column of the refernce sheet and then return the number it finds in the first
column of the refernce sheet to the corresponding cell below

The Anderson Journal
The Anson Record
Butner-Creedmoor News
Collierville Herald
The Courier News
Courier Times

Sp for example when I set it up it would look in hte first workshhet for the
"Collierville Herald" find it and then return the number 30380170 to the cell
to the left of the name in the second worksheet.







--
SAH


"Barb Reinhardt" wrote:

If you could give us some sample data and tell us what columns they are
located in, we could give you an equation that would work for you.

"Scott" wrote:

I have a worksheet that has 2 columns on it 1 is numbers and the others are
names. I want to be able to export a group of names from one of my programs
and then have excel match the name and dump the corresponding number into the
spreadsheet. I beleive I can use vlookup but I am not certain
--
SAH

How do I??
 

I am a little confused. in sheet 2 in column b2 the name is let's say "john",
now in sheet one john could be in b108. I want thw funtion to find john in
sheet 1 and return the corresponding number in a108 on sheet 1 to a1 on sheet
two
--
SAH


"Marcelo" wrote:

Hi, Scott, it is sound strage.

try to check if the Johns are equal =sheet1!b2=B2 just to check it is true

"Scott" escreveu:

I tried it and it returns n/a
--
SAH


"Marcelo" wrote:

OK Scott, try this

First ws
Col a Col b Col C
1 John =A2 returns 1
2 Paul =A3 returns 2

second ws
Col A
Col B
=vlookup(B2,Sheet1!$B$2:$C$3,2,0) returns 1 John

HTH



"Scott" escreveu:

close
in your example

Col a Col b
1 John
2 Paul

are in a seprate worksheet


Then in the other worksheet it will look like this

Col A Col B
John
Paul



I want it to match John to John and return the value of 1 to Col A of the
second worksheet


--
SAH


"Marcelo" wrote:

Hi Scott,

if I undestand your question you have

Col A Col B
1 John
2 Paul
3 Scott

and in another place you will have
Col A Col B
Scott Vlookup function to return 3

if it is correct my sugestion is create a C column on the original range
with =a2 (numbers) and copy it down (just to have the look figures on the
right column)

so the function should be =vlookup(a2,sheet1!b2:c100,2,0)

HTH
Regards from Brazil
Marcelo


"Scott" escreveu:

I have a worksheet that has 2 columns on it 1 is numbers and the others are
names. I want to be able to export a group of names from one of my programs
and then have excel match the name and dump the corresponding number into the
spreadsheet. I beleive I can use vlookup but I am not certain
--
SAH