VLOOKUP FORMULAS

P

PB

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

Gord Dibben

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
 
Top