editing vlookup formula causes failure

  • Thread starter Thread starter laneman
  • Start date Start date
L

laneman

I tried to edit a simple vlookup formula in the formula bar. When done
the cell with the formula no longer displays the #N/A, it displays th
entire formula and does not work. Below is the formula, which work
fine until edited.

=VLOOKUP(B6,RelationshipTable!A2:C11,2,FALSE
 
Some possibilities:

Did you accidentally enter a space in front of the equal sign in the formula
bar?

Try <Ctrl> <~> a couple of times, to see if the "Formula View" was toggled.

Try <Ctrl> <Shift> <~> to format the cell to General, then hit
<F2> <Enter> to reset the formula.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

I tried to edit a simple vlookup formula in the formula bar. When done,
the cell with the formula no longer displays the #N/A, it displays the
entire formula and does not work. Below is the formula, which works
fine until edited.

=VLOOKUP(B6,RelationshipTable!A2:C11,2,FALSE)
 
Back
Top