When I enter the function in a cell, the result is correct in the set up.
When I hit enter, the only thing taht is up into the cell is the VLOOKUP
formula and not the result of the formula.

The cell may have been formatted as text, and thus Excel
doesn't recognize your formula as a true formula, only as
a text string. To fix it:

1. Select the cell.
2. Press <Ctrl<Shift<~.
3. Press F2.
4. Press <Enter.


HTH
Jason
Atlanta, GA

-----Original Message-----
When I enter the function in a cell, the result is
correct in the set up.
When I hit enter, the only thing taht is up into the
cell is the VLOOKUP
formula and not the result of the formula.
.