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)

VLOOKUP FORMULAS
 

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
EditReplace

What: =
With: =

Replace all


Gord Dibben Excel MVP

On Thu, 24 Nov 2005 14:24:04 -0800, "PB" 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)