Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
The VLookup function displays the formula in the cell, not data.
I've been using the VLookup function with the wizard just fine for a few
hours. It suddenly began displaying the formula in the cell instead of returning the data. Here are some of the things I've known to be issues in the past and have already tried: -Made sure both columns of data were sorted in ascending order -Converted both to "text" using the text to column function -Copied and pasted into new spreadsheets -Made sure to tab through the wizard questions instead of pointing & clicking with the mouse -Used a range name. When that didn't work, clicked on the sheet and highlighted the data. -Trimmed the data to be certain there were no additional spaces in either column. Any other ideas? I love VLookup when it works. But when it doesn't, it drives me crazy! Thanks. -- Melanie |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
The VLookup function displays the formula in the cell, not data.
Hi Melanie,
Your cell was formatted as text before you entered the formula. Format it as General AND re-enter the formula (F2, ENTER) -- Kind regards, Niek Otten Microsoft MVP - Excel "MLVick" wrote in message ... | I've been using the VLookup function with the wizard just fine for a few | hours. It suddenly began displaying the formula in the cell instead of | returning the data. Here are some of the things I've known to be issues in | the past and have already tried: | | -Made sure both columns of data were sorted in ascending order | -Converted both to "text" using the text to column function | -Copied and pasted into new spreadsheets | -Made sure to tab through the wizard questions instead of pointing & | clicking with the mouse | -Used a range name. When that didn't work, clicked on the sheet and | highlighted the data. | -Trimmed the data to be certain there were no additional spaces in either | column. | | Any other ideas? I love VLookup when it works. But when it doesn't, it | drives me crazy! | | Thanks. | -- | Melanie |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
The VLookup function displays the formula in the cell, not dat
Thanks so much! It worked perfectly. I've gotten around it in the past by
playing around until it worked, but could never figure out what I did to make it work or why it stopped. Very helpful! -- Melanie "Niek Otten" wrote: Hi Melanie, Your cell was formatted as text before you entered the formula. Format it as General AND re-enter the formula (F2, ENTER) -- Kind regards, Niek Otten Microsoft MVP - Excel "MLVick" wrote in message ... | I've been using the VLookup function with the wizard just fine for a few | hours. It suddenly began displaying the formula in the cell instead of | returning the data. Here are some of the things I've known to be issues in | the past and have already tried: | | -Made sure both columns of data were sorted in ascending order | -Converted both to "text" using the text to column function | -Copied and pasted into new spreadsheets | -Made sure to tab through the wizard questions instead of pointing & | clicking with the mouse | -Used a range name. When that didn't work, clicked on the sheet and | highlighted the data. | -Trimmed the data to be certain there were no additional spaces in either | column. | | Any other ideas? I love VLookup when it works. But when it doesn't, it | drives me crazy! | | Thanks. | -- | Melanie |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula or function displays after edit and not its result | Excel Worksheet Functions | |||
AUTO SUM function returns 0.00 and formula displays =SUM() | New Users to Excel | |||
Valid formula result in Function Box but Cell displays #VALUE | Excel Discussion (Misc queries) | |||
Function isnt working, just displays the formula in cell?eg A2+B2 | Excel Discussion (Misc queries) | |||
Formula window displays correct answer while cell displays incorre | Excel Worksheet Functions |