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