View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
George George is offline
external usenet poster
 
Posts: 347
Default VLOOKUP Shows formula not results.

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