Why is vlookup showing the formula

An Excelchat Expert solved this problem in 28 mins! Countifs formula not working on mac - I have used it before, however somehow is not working. An Excelchat Expert solved this problem in 29 mins! Find not working. An Excelchat Expert solved this problem in 22 mins! This comment form is under antispam protection. Subscribe to Excelchat.

Try for free. Trusted by people who work at. To find out more, see here: Cookie Policy. Ok, Got It! Got it! Your question will be answered by an Excelchat Expert. Your email address will not be published. Save my name, email, and website in this browser for the next time I comment. Have a nice day! Simon Fixter on August 10, at pm. Analyst on August 10, at pm. You could have a space in one of the cells, which could be throwing the vlookup off!

The best way to test this is do a count of the number of characters in both cells. EC 2 EC 3 Reply. Fanny on February 2, at am. Hi I need help with Vlook I noticed that the Vlook popup no of column pop all over the sheet. Analyst on February 4, at pm. Hi Fanny If you have dozens of columns, the easiest thing to do would be to make a copy of the sheet you want to get the data from, then just keep the two columns you need for the vlookup to work.

Analyst Reply. Thank you very much. Analyst on December 27, at am. Glad we could help! Happy New Year when it comes around! Eric on February 1, at pm. I was so frustrated not knowing why it wont work!!! Chelsea on August 30, at pm. Was this reply helpful? Yes No. Sorry this didn't help. Thanks for your feedback. Check that the sheet has not been set to display formulas: activate the Formulas tab of the ribbon and look at the Show Formulas button in the Formula Auditing group. If this button is highlighted, click it to turn it off.

Make sure that the cells with the formulas have not been formatted as Text. If you enter a formula in a cell formatted as Text, the formula will become the cell value. Choose where you want to search below Search Search the Community. This thread is locked. You can follow the question or vote as helpful, but you cannot reply to this thread.