Function doesn't run

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Justin - 08 Dec 2006 16:54 GMT

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?

Reply to this Message

Niek Otten - 08 Dec 2006 17:03 GMT

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

Signature

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?

Reply to this Message

Gord Dibben - 08 Dec 2006 17:10 GMT

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

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

Reply to this Message

Dave Peterson - 08 Dec 2006 19:27 GMT

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

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

Signature

Dave Peterson

Reply to this Message