When using a lookup function, it is referencing the text of the formulas in
the table array cells instead of the result of the formulas. How do I
correct this?

Josh

Either you are in Formula View or the formula cells are formatted as text.

Changing the Format alone won't do the trick.

For the first, hit CTRL + `(back quote above TAB key) to toggle View Formulas
on/off.

For the second, Format the cells to General then F2 and ENTER to see results.

If you have already done a great whack of these formulas, select all and
EditReplace

what: =
with: =

Replace All and OK.


Gord Dibben Excel MVP

On Tue, 1 Nov 2005 09:19:44 -0800, "Josh VM"
wrote:

When using a lookup function, it is referencing the text of the formulas in
the table array cells instead of the result of the formulas. How do I
correct this?