vlookups

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Contact Us About Resources Sign in

Solutions Through Learning

Excellent

Request Callback We will call you back 0207 987 3777 Call for assistance Your Basket Basket is empty

Solutions Through Learning

Callback

Sign in

Basket

Menu

Call us on 0207 987 3777 or Search our website

Courses
- Application Training
  - Excel
    - All Excel
    - Introduction
    - Intermediate
    - Advanced
    - Advanced - Formulas & Functions
    - Advanced - For Power Users
    - VBA
    - VBA Introduction
    - VBA Intermediate
    - VBA Advanced
    - Charting
    - Dashboards for Business Intelligence
    - Advanced Excel Dashboards
    - Forecasting & Data Analysis
    - Power Query
    - PivotTables
    - PowerPivot
    - Financial Modelling
    - Excel for Finance Professionals
  - Microsoft Office 365
    - 365 Adoption Program
    - 365 Explained
    - 365 Ambassadors
    - 365 End Users
    - OneNote
    - Teams
  - ChatGPT
  - Power Automate
  - Power BI
  - Powerpoint
  - Access
  - Word
  - MS Project
  - Sharepoint
  - Outlook
  - Visio
  - View all 200+ Courses
- Productivity Training Programs
- Professional Development
  - All Professional Development
  - Taking Minutes
  - Time Management
  - Organisational Skills
  - Negotiating Skills
  - Presentation Skills
  - Effective Communication Skills
  - Assertiveness At Work
  - View all 50+ Courses
- Management Training
  - All Management Training
  - Introduction to Management
  - Managing Teams Remotely
  - Mentoring
  - Managing Change
  - Leadership Development
  - View all 50+ courses
- Sales & Customer Service
  - All Sales & Customer Service
  - Customer Service Excellence
  - Excellent Account Management
  - Fundamentals of Selling
  - Selling Skills Programme
  - View all 20+ courses
- Financial Training
  - All Financial Training
  - Finance for Non Financial Managers
  - Effective Budgeting and Beyond
  - View all Courses
- Project Management
  - All Project Management
  - Project Management course
  - Microsoft Project
  - PRINCE 2 Foundation
  - PRINCE 2 Practitioner
  - View all 18+ courses
- eLearning Solutions
Promotions
- Promotions
- Excel Courses London
Schedule
- Public Schedule
- How to Book
- Reschedule
- Last Minute Deals
- What to Expect
- Venues and Equipment Hire
- Industry Leading Pricing model
Formats
- All Formats
- Public Scheduled Courses
- On-Site Training
- Productivity Training Programs
- Closed Company Events
- Online Classroom (Virtual)
- Consultancy
- One to One Training
- Training Needs Analysis
- Floor Walking
- Roll Out
- E Learning
- Executive Coaching
Our Clients
- Client List
- Online Reviews
- Client Testimonials
- Client Feedback
- Featured Case Studies
Contact Us
About us
Resources
Your account
Sign in

Home » Resources » Forum

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Vlookups and exact matches

Vlookups and exact matches

Resolved · Low Priority · Version 2007

Mon 7 Nov 2011, 15:58 Delegate Martha said...

Martha has attended:
Excel Introduction course
Excel Intermediate course
Excel Advanced course

Vlookups and exact matches

how to find an exact match with vlookups

Wed 9 Nov 2011, 14:13 Trainer Paul said...

RE: vlookups

to find an exact match you must place "false" as the 4th part of your vlookup function.

Does that answer your question?

thanks
Paul

Wed 16 Nov 2011: Automatically marked as resolved.

Excel tip:

Jumping Between Sheets in a Book

PgDn and PgUp keys scrolls up and down a screen page in most applications.

Ctrl+PgDn and Ctrl+PgUp keys jump from one sheet in your workbook to the next, up or down through the pages.

View all Excel hints and tips

TrustPilot
TrustScore 4.8 / 5 2234 reviews