Lookup Function

J

Josh VM

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?
 
G

Gord Dibben

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
Edit>Replace

what: =
with: =

Replace All and OK.


Gord Dibben Excel MVP
 
Top