Function doesn't run

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

 

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

 

[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

 

[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.)