Scribd Logo
Upload

Welcome to Scribd!

  • 6 views

    How To Use HLOOKUP With Structured Reference in Excel

    Uploaded by

    vinoth kumar

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    How To Use HLOOKUP With Structured Reference in Excel

    Uploaded by

    vinoth kumar
    6 views10 pages

    Original Title

    How-to-Use-HLOOKUP-with-Structured-Reference-in-Excel

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    6 views10 pages

    How To Use HLOOKUP With Structured Reference in Excel

    Uploaded by

    vinoth kumar

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    You are on page 1of 10

    Exact Match with HLOOKUP

    Date Whooper Cheeseburger Chicken Sliders Limeade


    3-Aug-2021 67 65 87 23 156
    4-Aug-2021 54 72 92 45 183
    5-Aug-2021 71 84 111 34 214
    6-Aug-2021 86 48 98 32 196
    7-Aug-2021 52 67 132 19 175
    8-Aug-2021 43 53 123 26 176
    9-Aug-2021 67 41 97 31 198

    Date 7-Aug-2021
    Item Chicken
    Sold 132
    Cancelled Items
    8
    4
    7
    3
    2
    6
    8
    Approximate Match with HLOOKUP

    Date Whooper Cheeseburger Chicken Sliders Limeade


    3-Aug-2021 67 65 87 23 156
    4-Aug-2021 54 72 92 45 183
    5-Aug-2021 71 84 111 34 214
    6-Aug-2021 86 48 98 32 196
    7-Aug-2021 52 67 132 19 175
    8-Aug-2021 43 53 123 26 176
    9-Aug-2021 67 41 97 31 198

    Date 7-Aug-2021
    Item Kitchen
    Sold 132
    Cancelled Items
    8
    4
    7
    3
    2
    6
    8
    HLOOKUP with MATCH Function

    Date Whooper Cheeseburger Chicken Sliders Limeade


    3-Aug-2021 67 65 87 23 156
    4-Aug-2021 54 72 92 45 183
    5-Aug-2021 71 84 111 34 214
    6-Aug-2021 86 48 98 32 196
    7-Aug-2021 52 67 132 19 175
    8-Aug-2021 43 53 123 26 176
    9-Aug-2021 67 41 97 31 198

    Date 8-Aug-2021
    Item Sliders
    Sold 26
    Cancelled Items
    8
    4
    7
    3
    2
    6
    8
    HLOOKUP with Wildcard Character

    Date Whooper Cheeseburger Chicken Sliders Limeade


    3-Aug-2021 67 65 87 23 156
    4-Aug-2021 54 72 92 45 183
    5-Aug-2021 71 84 111 34 214
    6-Aug-2021 86 48 98 32 196
    7-Aug-2021 52 67 132 19 175
    8-Aug-2021 43 53 123 26 176
    9-Aug-2021 67 41 97 31 198

    Date 7-Aug-2021
    Item Lime
    Sold 175
    Cancelled Items
    8
    4
    7
    3
    2
    6
    8
    Extracting Multiple Values from Array

    Date Whooper Cheeseburger Chicken Sliders


    3-Aug-2021 67 65 87 23
    4-Aug-2021 54 72 92 45
    5-Aug-2021 71 84 111 34
    6-Aug-2021 86 48 98 32
    7-Aug-2021 52 67 132 19
    8-Aug-2021 43 53 123 26
    9-Aug-2021 67 41 97 31

    Item Limeade

    Date 3-Aug-2021 4-Aug-2021 5-Aug-2021 6-Aug-2021

    Sold Err:504 Err:504 Err:504 Err:504


    Limeade
    156
    183
    214
    196
    175
    176
    198

    7-Aug-2021

    Err:504

    You might also like