Can i use vlookup for text

Hello, Welcome to my profile. We provide tips, how to guide and also provide Excel solutions to your business problems. I earn a small commission if you buy any products using my affiliate links to Amazon. Contact Privacy Policy. Excel Formulas Excel Functions. Nehad Ulfat Sep 22, 0. Table of Contents hide. Download Practice Workbook. Concluding Words. You May Also Like to Explore. Save Saved Removed 0. Nehad Ulfat. Related Articles. Excel tutorials.

The only Excel books you will ever need. Download today. The only constantly updated Excel titles more… Thoroughly covers Power Pivot and Power Query more… Covers business intelligence and OLAP features more… Simple, easy, understandable, 2-page lessons more… Available as both printed books and e-Books more… Used by schools, colleges and universities more… Available for , , and Mac versions more….

Cells I4:J88 contain the data that needs to be searched. You can download a copy of the workbook showing the formulas in action. Sales First Quarter Last updated on July 25, Share this article. Share on facebook. Share on twitter. Share on linkedin.

Share on stumbleupon. Share on email. What if the data table itself is in text format, but your lookup values are in numerical format. You can also go through our other suggested articles —. Submit Next Question. By signing up, you agree to our Terms of Use and Privacy Policy. Forgot Password? This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy.

By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy. Popular Course in this category. Course Price View Course.