HDTutorial
EN
How to use Conditional formatting with Vlookup() - MS EXCEL

Playback starts YouTube’s embedded player (privacy-enhanced mode).

How to use Conditional formatting with Vlookup() - MS EXCEL

26,345 views November 8, 2018 6:16

Watch on YouTube
ChannelMS Excel Simplified

Description from the creator

#MSEXCEL #VLOOKUP #MSEXCELSIMPLIFIED
VLOOKUP is an Excel function to lookup and retrieve data from a specific column. VLOOKUP supports approximate and exact matching, and wildcards (* ?) for partial matches. The "V" stands for "vertical". Lookup values must appear in the first column of the table, with lookup columns to the right.

=VLOOKUP (value, table, col_index, [range_lookup])
Arguments
value - The value to look for in the first column of a table.
table - The table from which to retrieve a value.
col_index - The column in the table from which to retrieve a value.
range_lookup - [optional] TRUE = approximate match (default). FALSE = exact match.

★★ FOLLOW ME BELOW: ★★
Blog ► learningexcel02.blogspot.in/
Twitter ► twitter.com/shekhar_shashan
Facebook ► facebook.com/MSExcelSimplified/
Google Plus Page ► plus.google.com/b/103106500897062423583/


How to use Conditional formatting with Vlookup() - MS EXCEL

About this tutorial

MS Excel Simplified published this 6:16 video tutorial on November 8, 2018. It has been watched 26,345 times on YouTube.

Category
Education
Duration
6:16
Published
November 8, 2018
Views
26,345
Likes
117

Tags

Share

This tutorial in other languages