How To Fix Excel When Formula Shows Instead of Result - VLOOKUP Troubleshooting Tip
Try these 3 Excel troubleshooting tips when your formula displays in the cell instead of the desired result. There can be a few reasons why your formula is visible and showing up instead of the value. In this video we will cover what to check to fix this issue using a VLOOKUP formula example that is showing in the cell instead of the data it is supposed to pull in.
📺 Watch Next:
• Match Names on Two Excel Sheets with ... Match Names in 2 Sheets / Excel VLOOKUP Tutorial
• VLOOKUP Excel Tutorial for HR Profess... VLOOKUP Excel Tutorial
__________
TIMESTAMPS ⏰
00:00 Intro - Excel Shows Formula But Not Result
00:24 Excel Troubleshooting Tips
02:29 Super Thanks
__________
CONNECT WITH ME 📎
Visit my website: https://www.sharonsmithhr.com for more information, tools and resources.
LinkedIn: / sharonsmithhr
Twitter: / sharonsmithhr
__________
GEAR
🎙 Blue Yeti USB Microphone: https://amzn.to/2W4SbzV (Great for recording professional sounding audio for your videos!)
🖱 Silent Mouse: https://amzn.to/3pxpc25 (This is a really cool mouse!)
🎥 Screen Recording Software: https://techsmith.z6rjha.net/NZG5b
📗 Green Screen: https://amzn.to/2DnHsY2
📸 Camera: https://amzn.to/39KvpQA
🔌 Live Stream Tool: https://amzn.to/2VFJyID (Turns your DSLR into a top notch webcam)
RESOURCES
✏️ JotForm: https://www.jotform.com/pricing/?utm_...
📑Adobe: https://clk.tradedoubler.com/click?p=...
📑 Wondershare PDFelement (PDF Editor): https://bit.ly/31QEkA8
💻 PresenterMedia: https://shareasale.com/r.cfm?b=417324...
Some links included here are affiliate links. If you click on these links and make a purchase, I may earn a small commission at no additional cost to you. Thanks for supporting this channel!
__________
TEMPLATES
Check out my helpful list of templates available for purchase: https://www.etsy.com/listing/87584666...
Thank you for supporting my channel!
(Scroll down for a link to my free resources)
__________
NOTE: If you found this content helpful, please consider donating to my channel from this PayPal link: https://www.paypal.com/cgi-bin/webscr.... Your donation, no matter what amount, is greatly appreciated and goes towards producing content that enhances your productivity and elevates your skills. Thanks for supporting this channel!
__________
FREE DOWNLOADS
✦ Visit https://mailchi.mp/6a0859ea0844/sharo... to sign-up for my e-mail list and get FREE downloads of super helpful spreadsheet formulas, dashboards and Org Chart templates for HR professionals.
__________
KEYWORDS: #msexcel
Excel Formula Showing As Text, Excel Shows Formula But Not Result, Excel Shows Formula Instead of Result (How To Fix), Formula Text Displayed Instead of Result, Excel Formula Not Calculating: Just Showing Formula | Formulas Not Calculating Automatically, Fix Excel Formula Not Showing Result, Formula Result Is Not Showing (Formula Visible In Cell), Sharon Smith HR, #SharonSmithHR
__________
PLAYLISTS:
➤ Jotform Tutorials: • Jotform Tutorials
➤Creating Fillable Forms: • How To Create A Fillable Form In Micr...
➤PowerPoint Tutorials for HR: • PowerPoint Tutorials
➤ Excel Tutorials for HR: • Microsoft Excel Tutorials
➤ Excel Quickies (Around 2 Minutes): • Excel Tips & Tricks
➤ Word Tutorials for HR: • Microsoft Word Tutorials
➤ Welcome | About Me: • Playlist