lookup to another table

[duggo sluggo]

is it possible to take a value from a table and use it to look up a value in a second table? I have a table with about 1800 records containing just customer numbers. I would like to look up these customer numbers in a big (50,000 records) table to get the full name. is this possible?

P.S. you may have noticed that I am not a frequent (or ever) Excel user and the MS Excel help is pathetic.

 

[Aladin Akyurek]

On 2002-09-03 08:01, duggo sluggo wrote:
is it possible to take a value from a table and use it to look up a value in a second table? I have a table with about 1800 records containing just customer numbers. I would like to look up these customer numbers in a big (50,000 records) table to get the full name. is this possible?

P.S. you may have noticed that I am not a frequent (or ever) Excel user and the MS Excel help is pathetic.

In what range is the first table and in what range is the second table? And where is the full name in the second table?