VLOOKUP Shows formula not results.

  • Thread starter Thread starter George
  • Start date Start date
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
 
Format the cell as General - it sound like it is formatted text
Then double kick the cell to recommit the formula
best wishes
 
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

Lookup macro 3
Help needed with a formula or macro 1
Access Vlookup Help - access another workbook/sheets 0
Copy a formula using Vlookup 2
Loop to copy paste rows base on table arrays 0
VLOOKUP formula displays in cell, will not return data 1
VLOOKUP & IF used with > or < 7
Multiple columns using Vlookup 3

Back
Top