MS Excel in Bangla > If condition VLOOKUP

What is VLOOKUP Exact

28.7k

Exact match - 0/FALSE looks for the first column's exact value. =VLOOKUP is an example ("Smith",A1:B100,2,FALSE).

  • In Excel, build an IF formula that compares the first two cells to compare two columns row by row.
  • The end outcome may resemble this:
  • =IF(EXACT(A2, B2), "Match", "")
  • =IF(AND(A2=B2, A2=C2), "Full match", "")

When set to 0, the match type parameter returns an exact match, whilst the other two types of values allow for an approximate match.

Learner's Ratings

4.7

Overall Rating

  • 84%
  • 9%
  • 5%
  • 2%
  • 0%

Reviews

M
MRIDHA MD MERAJ
5

Very good and Thank you so much

M
Md Mujahidul islam
5

This is a very good course.

M
Md Masud Rana
5

Good job

M
MD Yasin Khan
5

very helpfully for me thanke you learn vern team member

A
Abrar Hossen
5

I am happy for this course ....love you...I want to more course in bangla tutorial...from Bangladesh

M
Md Masud Rana
5

Good job

A
AB Nazim
5

good

I
Ibrahim Khalil
5

Very good

S
Sathi Nanda
5

Very good teaching quality

S
Soibol Debnath
5

It a very good course.

Show More
Course Content

  1. How to Work with Menu Bar
    5m 39s
  2. How to use LearnVern
    3m 20s
  3. What is Quick Access Toolbar and How to Work with it
    6m 33s
  4. How to Work with Formula Bar
    2m 35s
  5. What is Status Bar and How to Work With it
    5m 33s
  6. How to Navigate within Sheet and Workbook
    3m
  7. How to use Shortcuts
    4m 3s
  8. What is Format Painter and How to work with it
    2m 25s

  1. How to Enter Data in MS Excel
    4m 58s
  2. How to Use Autofill Functionality
    5m 32s
  3. How to Enter Date-Time
    6m 11s
  4. How to Use Undo-Redo
    5m 17s
  5. How to Work With Comments in MS Excel
    3m 29s
  6. How to Save Workbook in MS Excel
    4m 16s

  1. How to Create Formula in MS Excel
    7m 40s
  2. How to Copy Formula in MS Excel
    3m 31s
  3. How to Use Till Date Profit Formula
    3m 37s
  4. How to Work with Percentage Change Calculation
    5m 22s
  5. How to Use Absolute Value
    6m
  6. How to Use Sum Average
    5m 28s
  7. Which are the Common Functions
    7m 39s

  1. How to Format the Fonts
    3m 41s
  2. How to Adjust Rows and Columns
    3m 57s
  3. How to Use Alignment
    7m 3s
  4. How to Format the Borders
    2m 56s
  5. How to Format Numbers
    3m 52s
  6. How to Format Date-Time
    9m
  7. How to Use Conditional Formatting
    9m 6s
  8. How to Format Tables
    9m 1s
  9. How to Format Shapes
    6m 49s

  1. How to Resize Row & Column
    7m 2s
  2. How to Hide-Unhide Row & Column
    5m 23s
  3. How to Copy ,Move & Insert Data
    5m 28s
  4. How to Find and Replace Data
    6m 32s

  1. How to Print
    8m 33s
  2. What is Page Break Preview & How to Set Page
    5m 21s
  3. How to Set Page
    4m 57s

  1. How to create Charts
    7m 10s
  2. Which are the different types of Chart
    5m 37s
  3. How to Format Charts
    6m 31s
  4. Which are the Chart Elements
    7m 42s
  5. How to Use Spark lines
    7m 54s

  1. How to Freeze-Unfreeze the Row & Column
    7m 26s
  2. How to Split the Sheet
    6m 50s
  3. How to Use Outline
    6m 59s

  1. How to Manage Multiple Workbook
    6m 37s
  2. How to Use Rename Insert hide unhide sheets
    4m 38s
  3. How to Copy & Delete Sheets
    6m 30s
  4. How to Use Formula
    9m 4s
  5. How to Edit Links
    9m 12s

  1. What is IF Condition and How to Use it
    6m 25s
  2. What is VLOOKUP and How to Use It
    5m 59s
  3. What is VLOOKUP Exact
    4m 9s
  4. How to Use COUNT IF
    4m 23s

  1. How to Protect Sheet
    4m 52s
  2. How to Secure Workbook
    6m 7s
  3. How to Set Password in Workbook
    2m 19s
  4. How to Share Workbook
    3m 9s
  5. How to Track Changes
    5m 34s

  1. How to Perform Sorting
    6m 35s
  2. How to do Subtotals
    7m 26s
  3. How to Perform Filter
    5m 31s
  4. How to Spilt Data
    4m 20s
  5. How to Use Flash Fill
    3m 35s
  6. How to Remove Duplicate Data
    2m 34s
  7. How to Validate Data
    6m 51s

  1. How to Create Pivot Table in MS Excel
    11m 6s
  2. How to Manipulate Pivot Table
    8m 19s
  3. How to Add Slicers
    4m 36s
  4. How to Perform Grouping of Pivot Table
    4m 39s

  1. What is Macro And How to Use It
    7m 25s

  1. Assignment Q-1
    1m 10s
  2. Assignment Q-2
    21s
  3. Assignment Q-3
    34s
  4. Assignment Q-4
    50s
  5. Assignment Q-5
    48s
  6. Assignment Q-6
    37s
  7. Assignment Q-7
    47s
  8. Assignment Q-8
    45s
  9. Assignment Q-9
    37s
  10. Assignment Q-10
    32s
Enroll For Free