Lookup Function
 

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?

Lookup Function
 

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?