VLOOKUP Shows formula not results.

G

George

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
 
B

Bernard Liengme

Format the cell as General - it sound like it is formatted text
Then double kick the cell to recommit the formula
best wishes
 
G

George

You were right. The formula is now returning data, but it is data from the
row directly above the data it should be pulling. Any ideas on that?

--


Who else but,
George Hogge

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help needed with a formula or macro 1
Cell values not being properly evaluated by VLOOKUP() orSUMPRODUCT()... why? 1
Lookup macro 3
VLOOKUP Not working 3
VLOOKUP & Data Validation 0
VLOOKUP & IF used with > or < 7
Need help in Combining If formula with Vlookup 2
Using data from multiple worksheets in a formula 1

Top