Function doesn't run

J

Justin

In my spreadsheet, I have the following function
=VLookup(K16, zips, 2)
However, instead of returning a result, the function remains in the
cell. How do I fix this problem?
 
N

Niek Otten

Format the cell as General and re-enter the formula (F2, ENTER)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| In my spreadsheet, I have the following function
| =VLookup(K16, zips, 2)
| However, instead of returning a result, the function remains in the
| cell. How do I fix this problem?
|
 
G

Gord Dibben

If you are not in "view formulas" mode........CTRL + `(back quote) to toggle
on/off then the cell is probably formatted as text.

Format to General then F2 and ENTER.


Gord Dibben MS Excel MVP
 
D

Dave Peterson

And if you're looking for an exact match, you may want to use:

=vlookup(k16,zips,2,false)

(Zips sounded like zipcodes and I would guess that you would want an exact
match.)
 
Top