Excel Halps Please

[halus]

I'm needing some help with Excel please.*

I've two worksheets. One is a list with customer identification numbers and phone numbers that go along with each customer number. The other is a list that has customer numbers but does not have the phone numbers.
Is there an easy way to combine the lists so that if the customer id number from the first list is present on the second list the phone number would be filled in on the second list?

It sounds like quite an easy sort of thing but I am no Excel .

*Helping me is good for intercontinental relations and will probably result in you being rewarded with cake, pie, or a pint. No, that does not say incontinent relations. You can go to a club if you want people to wee on you. I'm not gonna do it.

[amblin]

.

[buzzmong]

I would have also suggested a vlookup.

[FatherJack]

I'd use Access (or other database).

Code: Select all

SELECT NamesTable.ID, NamesTable.Name, PhonesTable.Phone
FROM NamesTable INNER JOIN PhonesTable ON NamesTable.ID = PhonesTable.ID;

[Hehulk]

Definatly vlookup

[spoodie]

I'd export them to a text file and do magic from a UNIX command line, but that's just me and I don't know any other way.

/sandals with socks

[MrGreen]

Ich würde sie in eine Textakte exportieren und Magie von einer UNIX Befehl Linie tun, aber die ist ich gerecht und ich kenne keine andere Weise.

/sandals with socks

Fix'd

EDIT: To attempt being helpful, I'd also go with vlookup

[HereComesPete]

*snip* + full size=go

No, that does not say incontinent relations. You can go to a club if you want people to wee on you. I'm not gonna do it.

Funny how fast you thought of golden showers, is it a favourite of berk's?


Oh wait yes, helpful, er, being an excel mong I'd say use vthingy.

/helpful (pffft).