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