Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP Shows formula not results.
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP Shows formula not results.
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 "Bernard Liengme" wrote: 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP Shows formula not results.
Not without seeing the data, sorry
-- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "George" wrote in message ... 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 "Bernard Liengme" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
When I enter a formula, Excel shows the formula not the results | Excel Worksheet Functions | |||
Formula shows not results | Excel Worksheet Functions | |||
function results shows 0 | Excel Worksheet Functions | |||
See results of VLookup formula | Excel Discussion (Misc queries) | |||
can vlookup place results in a different box than the formula? | Excel Worksheet Functions |