How do I??

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Scott - 23 Jun 2006 19:03 GMT

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

Signature

SAH

Reply to this Message

Barb Reinhardt - 23 Jun 2006 19:16 GMT

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.

> 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

Reply to this Message

Scott - 23 Jun 2006 19:25 GMT

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.

Signature

SAH

> 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.
[quoted text clipped - 3 lines]
> > 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

Reply to this Message

Kevin Vaughn - 23 Jun 2006 20:47 GMT

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)

Signature

Kevin Vaughn

> This is the reference sheet in a workbook called pub id's.
>
[quoted text clipped - 26 lines]
> > > 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

Reply to this Message

Marcelo - 23 Jun 2006 19:28 GMT

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

Reply to this Message

Scott - 23 Jun 2006 19:36 GMT

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

Signature

SAH

> Hi Scott,
>
[quoted text clipped - 23 lines]
> > 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

Reply to this Message

Marcelo - 23 Jun 2006 19:43 GMT

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

> close
> in your example
[quoted text clipped - 41 lines]
> > > 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

Reply to this Message

Scott - 23 Jun 2006 19:53 GMT

I tried it and it returns n/a

Signature

SAH

> OK Scott, try this
>
[quoted text clipped - 55 lines]
> > > > 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

Reply to this Message

Marcelo - 23 Jun 2006 20:46 GMT

Hi, Scott, it is sound strage.

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

> I tried it and it returns n/a
>
[quoted text clipped - 57 lines]
> > > > > 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

Reply to this Message

Scott - 26 Jun 2006 13:06 GMT

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

Signature

SAH

> Hi, Scott, it is sound strage.
>
[quoted text clipped - 61 lines]
> > > > > > 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

Reply to this Message