Using Excel 2000, and with a list created of two columns consisting of a
number as text in the first column and a corresponding name in the second.

In a new workbook, I need to enter one of the numbers in a column, and then
in the next column have the corresponding name automatically entered when I
press Enter.

Is this possible, please?

That's what the vlookup function does. If you enter the number in cell A2,
for example, the equation in B2 would be
=vlookup(A2,[FirstWorkBookName.xls]Sheet1!A:B,2,false). (Substitute your
name of your master list file for FirstWorkBookName, and change Sheet1 and
the columns as necessary).


"Lolly" wrote:

Using Excel 2000, and with a list created of two columns consisting of a
number as text in the first column and a corresponding name in the second.

In a new workbook, I need to enter one of the numbers in a column, and then
in the next column have the corresponding name automatically entered when I
press Enter.

Is this possible, please?

Thank you bpeltzer for this informarion. I will test it out and get back to
your message in the next couple of days.

"bpeltzer" wrote:

That's what the vlookup function does. If you enter the number in cell A2,
for example, the equation in B2 would be
=vlookup(A2,[FirstWorkBookName.xls]Sheet1!A:B,2,false). (Substitute your
name of your master list file for FirstWorkBookName, and change Sheet1 and
the columns as necessary).


"Lolly" wrote:

Using Excel 2000, and with a list created of two columns consisting of a
number as text in the first column and a corresponding name in the second.

In a new workbook, I need to enter one of the numbers in a column, and then
in the next column have the corresponding name automatically entered when I
press Enter.

Is this possible, please?

Brilliant bpeltzer - thank you once again.
Now I have another query. Is it possible to jump back one column in order to
access the column after entering the number, to then press Enter for the
corresponding name, and then jump forward two columns to continue entering
data? Unfortunately the records sheets we are using have the two columns in
question in reverse order.

"Lolly" wrote:


Thank you bpeltzer for this informarion. I will test it out and get back to
your message in the next couple of days.

"bpeltzer" wrote:

That's what the vlookup function does. If you enter the number in cell A2,
for example, the equation in B2 would be
=vlookup(A2,[FirstWorkBookName.xls]Sheet1!A:B,2,false). (Substitute your
name of your master list file for FirstWorkBookName, and change Sheet1 and
the columns as necessary).


"Lolly" wrote:

Using Excel 2000, and with a list created of two columns consisting of a
number as text in the first column and a corresponding name in the second.

In a new workbook, I need to enter one of the numbers in a column, and then
in the next column have the corresponding name automatically entered when I
press Enter.

Is this possible, please?