Skip to content

excel_u_logo_stacked_grey_font

Start Here
Training
Publications
Blog

Chapter 7

By Jeff Lenning | August 8, 2013

Improve VLOOKUP with TEXT and VALUE

Excel Certification

Graduate Certification Program

Certification Program

Registration closes April 17, 2020

Learn Excel

Excel Course List

Free Sample Course

Free Learning Plan

Subscribe to Blog (free)

Email*
Name
First Last
Email
This field is for validation purposes and should be left unchanged.

Post Categories

Add-Ins (33)
Excel (350)
Features (186)
Functions (169)
Keyboard Shortcuts (25)
Techniques (65)
Training (46)
VBA (14)

Post Topics

Battle Breakout Chart CHOOSE CONCAT CONCATENATE Conditional Formatting COUNTIFS Data Model Data Validation Dynamic Arrays EOMONTH External Data FILTER Filters FlashFill Format Get & Transform Hacks Hyperlink IFERROR INDEX INDIRECT Macro MATCH Named Ranges Named References Names PivotTable Power Pivot Power Query SEQUENCE Sort Spill styles SUBTOTAL SUMIFS Tables TEXT TEXTJOIN UNIQUE VLOOKUP VSTACK Web Data XLOOKUP

Resources

Video Library
Download Library

About

Instructor List

Affiliate Program

Connect

Training

For Individuals

For College Professors

Related

Excel Consulting

Contact

+1 (949) 200-7688

[email protected]

Excel University
307 E Willow St #3, Harrisburg, SD 57032

MVP_Logo_Secondary_dark_grey_RGB_72_footer_150

MS_Cert_Trainer_logo_dark_grey_footer_150

NASBA_CPERegistry_logo_dark_grey_transparent_footer_150

Excel University | Copyright © 2012-2023 | All rights reserved