VLOOKUP FORMULAS

I am using this formula in a spreadsheet and I keep getting the formula
returned as opposed the date the formula should be retrieving. I have used
this many times before without problems but this particular spreadsheet will
not return any data from formulas. I have reformatted the entire spreadsheet
to be general and still can't get it to perform.

=VLOOKUP(B5,VLU!$A$5:$G$109,7,FALSE)

PB

Sounds like the cell was pre-formatted as Text.

Simple re-formatting won't help.

Change the format to General then F2 and ENTER.

If you have many of these to do select all then re-format to General then
Edit>Replace

What: =
With: =

Replace all


Gord Dibben Excel MVP

On Thu, 24 Nov 2005 14:24:04 -0800, "PB" <[email protected]> wrote:

>I am using this formula in a spreadsheet and I keep getting the formula
>returned as opposed the date the formula should be retrieving. I have used
>this many times before without problems but this particular spreadsheet will
>not return any data from formulas. I have reformatted the entire spreadsheet
>to be general and still can't get it to perform.
>
>=VLOOKUP(B5,VLU!$A$5:$G$109,7,FALSE)