• Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us
Excel

Using the VLOOKUP function to find multiple results in Excel

0 Comments

Using the VLOOKUP function to find multiple results in Excel. Have you ever wanted to use VLOOKUP but display multiple matching results? The standard VLOOKUP formula in Excel has a limitation and it will only display the first matching result. But what if you need to see all the matches in one place? In this article, let me show you a simple formula to get all the matching results in a list format.

Using the VLOOKUP function to find results

Example:
We want to search for data in the Geography column based on the Sales Person data given by Husein Augar in the Sales Person column.

VLOOKUP function 1You will use VLOOKUP to search for the object: =VLOOKUP(G3,sales,2,0)
Explanation: G3: the object to search for.
sales: the named data range.
2: the column position to return the result.
However, in your data range, there may be multiple matches but the VLOOKUP function only displays the limit of one result. Therefore, the FILTER function will be a useful solution for you.
Using the FILTER function to find multiple results
The FILTER function helps you to return multiple results in a data range.
Syntax:
=FILTER(array,include,[if_emty])
Where: array: the data range to filter (not required to have headers).
include: the condition to filter, located in which column (simultaneously determining both factors).
if_empty: What value to return if there are no results? (not required to enter).
Example:
I have a data table as shown below. And instead of using the VLOOPKUP function to find results, you will use the FILTER function!
=FILTER($B$2:$B$37,$A$2:$A$37=$G$3)

VLOOKUP function 2Explanation: $B$2:$B$37: the column of data to return the result.
$A$2:$A$37: the column of data that contains the condition, and the condition is: $G$3.

Using the FILTER VLOOKUP function to return a data range

In addition to returning a result column as above, the FILTER function also returns the data range containing the desired results.
With the following formula: =FILTER(sales,sales[Geography]=”USA”)

VLOOKUP function 3Explanation: Sales: the named data range to filter.
Sales[Geography]: the named column of data that contains the condition and the condition is: “USA”.
I hope you successfully carry out this article and don’t forget to rate the article for Buffcom!

Rate this post
32
265 Views
How to Cut Images in Word: Extremely Simple and Detailed InstructionsPrevHow to Cut Images in Word: Extremely Simple and Detailed InstructionsMarch 16, 2023
3 Reverse Data Tricks in Excel Using Formulas, Easy-to-Understand Illustrated ExamplesMarch 16, 20233 Reverse Data Tricks in Excel Using Formulas, Easy-to-Understand Illustrated ExamplesNext

Leave a Reply Cancel reply

You must be logged in to post a comment.

Buy Windows 11 Professional MS Products CD Key
Buy Office 2021 Professional Plus Key Global For 5 PC
Top rated products
  • Trend Micro Internet Security 3 Devices 1 Year Key GLOBAL Trend Micro Internet Security 3 Devices 1 Year Key GLOBAL
    Rated 5.00 out of 5
    $17.00
  • Windows 11 Pro Key Global Windows 11 Pro Key Global
    Rated 5.00 out of 5
    $6.00
  • AVG Internet Security 2021 10 Devices 2 Years Global AVG Internet Security 2021 10 Devices 2 Years Global
    Rated 5.00 out of 5
    $42.20
  • Trend Micro Maximum Security 3 Devices 1 Year key Global Trend Micro Maximum Security 3 Devices 1 Year key Global
    Rated 5.00 out of 5
    $15.00
  • Windows 11 Home Key Global 2021 Windows 11 Home Key Global 2021
    Rated 5.00 out of 5
    $6.00
Products
  • AVG Internet Security 2021 10 Devices 1 Year Global AVG Internet Security 2021 10 Devices 1 Year Global
    Rated 5.00 out of 5
    $30.00
  • Kaspersky Small Office Security 20 PCs + 20 Mobiles + 2 Servers 1 Year Kaspersky Small Office Security 20 PCs + 20 Mobiles + 2 Servers 1 Year $284.73
  • Avast Premium Security 2021 10 Devices 1 Year Global Avast Premium Security 2021 10 Devices 1 Year Global
    Rated 5.00 out of 5
    $28.00
  • Office 2019 Professional Plus Key Global Bind to your Microsoft Account Office 2019 Professional Plus Key Global Bind to your Microsoft Account
    Rated 4.97 out of 5
    $49.00
  • Kaspersky Small Office Security 10 PCs + 10 Mobiles + 1 Server 1 Year Kaspersky Small Office Security 10 PCs + 10 Mobiles + 1 Server 1 Year
    Rated 5.00 out of 5
    $164.50
  • Windows 11 Pro Key Global Windows 11 Pro Key Global
    Rated 5.00 out of 5
    $6.00
  • Windows Server 2025 Remote Desktop Services 50 Device Connections Windows Server 2025 Remote Desktop Services 50 Device Connections $25.00
  • Windows Server 2016 Remote Desktop Services 50 USER Connections Key Global Windows Server 2016 Remote Desktop Services 50 USER Connections Key Global
    Rated 4.74 out of 5
    $15.00
  • AVG Ultimate 2021 with Antivirus + Cleaner, Secure VPN 10 Devices 1 Year AVG Ultimate 2021 with Antivirus + Cleaner, Secure VPN 10 Devices 1 Year
    Rated 4.91 out of 5
    $34.00
  • Windows Server 2025 Standard Windows Server 2025 Standard $30.00
Product categories
  • Anti Virus
  • Microsoft Office
  • Microsoft Project
  • Microsoft Visio
  • Microsoft Visual
  • Microsoft Windows
  • Other Software
  • Uncategorized

Buffcom.net always brings the best digital products and services to you. Specializing in Office Software and online marketing services

BIG SALE 50% IN MAY

Microsoft Office
Microsoft Windows
Anti-Virus
Contact Us

Visit Us:

125 Division St, New York, NY 10002, USA

Mail Us:

buffcom.net@gmail.com

TERMS & CONDITIONS | PAYMENT GUIDE  | SHIPPING POLICY  | REFUND POLICY

Copyright © 2019 buffcom.net  All Rights Reserved.