Format the cell as General - it sound like it is formatted text
Then double kick the cell to recommit the formula
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"George" wrote in message
...
Greetings,

I am having trouble with the VLOOKUP Function.

In Excel 2003 I have a workbook with two sheets, Report and Roster.

I want to lookup data in Roster and have it return data in Report.

=VLOOKUP(A5,Roster!A1:C1500,2,FALSE)

All I get back is the formula itself, as if I have typed it in as text.
Any
ideas?

--


Who else but,
George Hogge

MCSE, MCDBA, MCSA
CCNA, CSP
Checkpoint CA
Citrix CA