Hello,
I am working on a sheet which sets up contact info based on a list,
such as:

Name.................
Address...........
City, State............
Phone...............

The "Name" cell is a drop down list, tied to data on another sheet.
The other contact cells are activated using a VLOOKUP function. I use
the following code in the "Address" box

=VLOOKUP(C12,vendors!A1:L1000,2,FALSE)

In one worksheet, this works perfectly. In another seemingly similar
worksheet, this same function doesn't work at all. After entering the
formula, as shown, the cell shows the formula as if I had entered it
as text.

Any suggestions?

thanks

Go to Edit - Format Cell - Number and switch from Text to General. Now go
to the cell and double click to get inot edit mode. Hit enter to exit edit
mode and you should be good to go...
--
HTH...

Jim Thomlinson


"Andrew" wrote:

Hello,
I am working on a sheet which sets up contact info based on a list,
such as:

Name.................
Address...........
City, State............
Phone...............

The "Name" cell is a drop down list, tied to data on another sheet.
The other contact cells are activated using a VLOOKUP function. I use
the following code in the "Address" box

=VLOOKUP(C12,vendors!A1:L1000,2,FALSE)

In one worksheet, this works perfectly. In another seemingly similar
worksheet, this same function doesn't work at all. After entering the
formula, as shown, the cell shows the formula as if I had entered it
as text.

Any suggestions?

thanks

Go to Edit - Format Cell - Number and switch from Text to General. Now go
to the cell and double click to get inot edit mode. Hit enter to exit edit
mode and you should be good to go...

--
HTH...

Jim Thomlinson


"Andrew" wrote:

Hello,
I am working on a sheet which sets up contact info based on a list,
such as:

Name.................
Address...........
City, State............
Phone...............

The "Name" cell is a drop down list, tied to data on another sheet.
The other contact cells are activated using a VLOOKUP function. I use
the following code in the "Address" box

=VLOOKUP(C12,vendors!A1:L1000,2,FALSE)

In one worksheet, this works perfectly. In another seemingly similar
worksheet, this same function doesn't work at all. After entering the
formula, as shown, the cell shows the formula as if I had entered it
as text.

Any suggestions?

thanks

This cell was formatted as text before you entered the formula. Just formatting afterwards doesn't help.

Format as general AND re-enter the formula (F2, ENTER)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"Andrew" wrote in message ...
| Hello,
| I am working on a sheet which sets up contact info based on a list,
| such as:
|
| Name.................
| Address...........
| City, State............
| Phone...............
|
| The "Name" cell is a drop down list, tied to data on another sheet.
| The other contact cells are activated using a VLOOKUP function. I use
| the following code in the "Address" box
|
| =VLOOKUP(C12,vendors!A1:L1000,2,FALSE)
|
| In one worksheet, this works perfectly. In another seemingly similar
| worksheet, this same function doesn't work at all. After entering the
| formula, as shown, the cell shows the formula as if I had entered it
| as text.
|
| Any suggestions?
|
| thanks

On Feb 12, 3:15 pm, "Niek Otten" wrote:
This cell was formatted as text before you entered the formula. Just formatting afterwards doesn't help.

Format as general AND re-enter the formula (F2, ENTER)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Andrew" wrote in ...

| Hello,
| I am working on a sheet which sets up contact info based on a list,
| such as:
|
| Name.................
| Address...........
| City, State............
| Phone...............
|
| The "Name" cell is a drop down list, tied to data on another sheet.
| The other contact cells are activated using a VLOOKUP function. I use
| the following code in the "Address" box
|
| =VLOOKUP(C12,vendors!A1:L1000,2,FALSE)
|
| In one worksheet, this works perfectly. In another seemingly similar
| worksheet, this same function doesn't work at all. After entering the
| formula, as shown, the cell shows the formula as if I had entered it
| as text.
|
| Any suggestions?
|
| thanks

Thanks everyone. I appreciate the help.