• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

My Online Training Hub

Learn Dashboards, Excel, Power BI, Power Query, Power Pivot

  • Courses
  • Pricing
    • Free Courses
    • Power BI Course
    • Excel Power Query Course
    • Power Pivot and DAX Course
    • Excel Dashboard Course
    • Excel PivotTable Course – Quick Start
    • Advanced Excel Formulas Course
    • Excel Expert Advanced Excel Training
    • Excel Tables Course
    • Excel, Word, Outlook
    • Financial Modelling Course
    • Excel PivotTable Course
    • Excel for Customer Service Professionals
    • Multi-User Pricing
  • Resources
    • Free Downloads
    • Excel Functions Explained
    • Excel Formulas
    • Excel Add-ins
    • IF Function
      • Excel IF Statement Explained
      • Excel IF AND OR Functions
      • IF Formula Builder
    • Time & Dates in Excel
      • Excel Date & Time
      • Calculating Time in Excel
      • Excel Time Calculation Tricks
      • Excel Date and Time Formatting
    • Excel Keyboard Shortcuts
    • Excel Custom Number Format Guide
    • Pivot Tables Guide
    • VLOOKUP Guide
    • ALT Codes
    • Excel VBA & Macros
    • Excel User Forms
    • VBA String Functions
  • Members
    • Login
  • Blog
  • Excel Webinars
  • Excel Forum
    • Register as Forum Member

VLOOKUP Multiple Criteria

You are here: Home / Excel Formulas / VLOOKUP Multiple Criteria
VLOOKUP Multiple Criteria
February 15, 2012 by Mynda Treacy

I had an email from Bobcat today asking how to lookup data that is spread across multiple columns.

 

Table 1 has data with the name in just one column:

VLOOKUP Multiple Values

And Table 2 has the name across 3 columns (D, E and F):

vlookup multiple criteria

We want to find the Employee number from Table 1 and put it in column G of Table 2.

The solution is quite simple. We just need to join together the cells containing the name in Table 2, before looking them up in Table 1.

We can do this within a VLOOKUP formula like this:

=VLOOKUP(D6&" "&E6&" "&F6,table_1,2,FALSE)

Note: Β table_1 in the above formula is the named range for cells A6:B11

excel lookup multiple criteria

See in the formula bar how I’ve joined the text from columns D, E and F together using the ampersand symbol. I’ve also added a space between the text by inserting double quotes with a space between.

excel lookup multiple values

The VLOOKUP formula is resolving the D6&" "&E6&" "&F6 arguments of the formula like this:

=VLOOKUP(William J Oxley,table_1,2,FALSE)

Thanks for your question Bobcat.

VLOOKUP Multiple Criteria

More Vlookup Posts

vlookup in power query using list functions

VLOOKUP in Power Query Using List Functions

Use List functions to do VLOOKUPS in Power Query as an alternative to merging tables. Sample data and file available to download
VLOOKUP Multiple Values in Multiple Columns

VLOOKUP Multiple Values in Multiple Columns

Excel VLOOKUP Multiple Sheets

Excel VLOOKUP Multiple Sheets

Excel Factor 17 Lookup and Return Multiple Matches

Excel Factor 17 Lookup and Return Multiple Matches

Excel Factor 16 Dynamic Lookup

Excel Factor 16 Dynamic Lookup

Excel VLOOKUP Multiple Values

Excel VLOOKUP Multiple Values

Excel Wildcards in your SUMIF, COUNTIF and VLOOKUP

Excel Wildcards in your SUMIF, COUNTIF and VLOOKUP

Excel VLOOKUP with Dynamic Column Reference

Excel VLOOKUP with Dynamic Column Reference

Excel VLOOKUP with Dynamic Column Reference allows you to copy the formula across columns and have the column reference automatically update.
Excel VLOOKUP to the Left Using CHOOSE

Excel VLOOKUP to the Left Using CHOOSE

VLOOKUP to the left with this clever use of CHOOSE to trick Excel into looking up a column to the left.
hlookup function

Excel HLOOKUP Formulas Explained

How to use Excel HLOOKUP formula, including examples and workbook download.

More Excel Formulas Posts

top excel functions for data analysts

Top Excel Functions for Data Analysts

Must know Excel Functions for Data Analysts and what functions you don’t have to waste time learning and why.
excel advanced formula environment

Excel Advanced Formula Environment

Excel Advanced Formula Environment is a long awaited, new improved way to write, name and store Excel formulas.
Pro Excel Formula Writing Tips

Pro Excel Formula Writing Tips

Must know Excel formula writing tips, tricks and tools to make you an Excel formula ninja, including a new formula editor.
excel shaping arrays

New Array Shaping Excel Functions

The Excel Shaping Array Functions makes it easier than ever to reshape arrays and ranges using these purpose built functions
excel nested if functions what not to do

Excel IF Formulas and What Not To Do

Excel IF formulas can get out of hand when you nest too many IFs. Not only do they become unwieldy they’re difficult for anyone to understand
excel image function

Excel IMAGE Function

The Excel IMAGE Function enables you to embed images in a cell using a formula. It supports BMP, JPG/JPEG, GIF, TIFF, PNG, ICO, and WEBP files

Excel VSTACK and HSTACK Functions

New Excel VSTACK and HSTACK functions makes combining arrays of cells easy and with some clever tricks we can extend their capabilities.
identify overlapping dates and times in excel

Identify overlapping dates and times in Excel

How to identify overlapping dates and times in Excel with a formula that checks a range of cells. Works with Dates and Times.
New Excel Text Functions

TEXTSPLIT, TEXTBEFORE and TEXTAFTER Functions

TEXTAFTER, TEXTBEFORE and TEXTSPLIT are exciting new Excel Text functions. They’re fairly self-explanatory, however TEXTSPLIT has some cool features.

Top 10 Intermediate Excel Functions

Take your Excel skills to the next level with this top 10 intermediate Excel functions. These are must know functions for all Excel users.
Category: Excel FormulasTag: vlookup
Previous Post:Excel Data Validation With Dependent ListsExcel Data Validation With Dependent Lists
Next Post:Excel Evaluate Formula ToolExcel Evaluate Formula Tool

Reader Interactions

Comments

  1. Nigel Payne

    January 29, 2020 at 7:53 pm

    I want to invest 30000 per annum for 10 years at 10% per annum but want to allow the value invested of 30000 annually to be depreciated by 9% per annum to allow for currency inflation and provide a realistic value result

    Reply
  2. Mommar

    January 30, 2019 at 6:07 pm

    if there is anything that can help me to find 6 values with target sum out 150 or more values???

    Reply
    • Catalin Bombea

      February 1, 2019 at 7:22 am

      Hi Mommar,
      If you have 1000 values, there are 1368173298991500 possible combinations of 6 values:=COMBIN(1000,6)
      You will need a user defined function to build all possible combinations, and list those where their sum is above 150. You will need a powerful computer to do those calculations, a regular computer might take a while to process that.

      Reply
  3. noorullah

    October 23, 2016 at 4:50 pm

    i want to know allot about excel..

    Reply
    • Philip Treacy

      October 23, 2016 at 8:05 pm

      Hi,

      Hopefully we can help you out. Just browse though our blog, there’s plenty to learn there. Or take one of our Excel courses.

      Regards

      Phil

      Reply
  4. DIGVIJAY SINGH

    March 9, 2016 at 9:27 pm

    NO THIS FORMULA NOT WORK WHEN TABLE_2 NOT ARRANGED LIKE TABLE_1
    WE SHALL HAVE TO USE VLOOKUP WITH CHOOSE IN ARRAY FORMULA

    Reply
    • Mynda Treacy

      March 10, 2016 at 10:17 am

      Not necessarily. INDEX & MATCH can handle lookups where the order of columns is not suitable for VLOOKUP. I would only use an array formula as a last resort.

      Mynda

      Reply
  5. Mike Kinsey

    February 19, 2015 at 10:36 am

    I have a similar situation I have one table that is in a file named Shelby Name ID.xlsx , it has 2 columns. Column A has the first and last name in it and Column 2 is an ID

    I have another Table in a file named IndividualExport.csv , it has numerous columns with the first name, middle name, and last name in columns H,I and J respectfully. The first column of this Table is labeled LInk ID.

    I am trying to put the Link ID number from the IndividualExport.csv to the 3rd column in the Shelby Name ID.xlsx

    When I try your formula I keep getting #VALUE!. I am familiar with the vlookup function but not with tables so I think I am writing the formula wrong. Here is the formula I am using and it is in the 3rd column of the Shelby Name ID file;

    =VLOOKUP([@Name],IndividualExport.csv!Table1[@First]&” “&IndividualExport.csv!Table1[@Middle]&” “&IndividualExport.csv!Table1[@Last],1,FALSE)

    Reply
    • Catalin Bombea

      February 19, 2015 at 4:01 pm

      Hi Mike,
      As you already know, VLOOKUP function has 4 arguments:
      -lookup_value, table_array, col_index_num, and range_lookup.
      In this article, the name is concatenated into the lookup_value argument, then the function is searching a match for the resulting string in table_array argument. In your formula, you are concatenating 3 columns of data into the table_array argument, which is totally different from concatenating 3 cells, as the tables do have multiple rows. The formula turns into an array formula, which needs to be entered as an array formula, with CSE (Ctrl+Shift+Enter), not just Enter after editing the formula. If the correct combination of keys is entered (Ctrl+Shift+Enter), then you will see that in the formula bar, the formula is wrapped into a set of curly brackets: { }
      These should not be entered manually, they are automatically introduced when CSE is pressed, and they represent array formulas.
      Cheers,
      Catalin

      Reply
  6. Anthony

    November 13, 2014 at 12:31 am

    I am trying to lookup a column from a different tab, but it has to match two different criteria in order to return the correct value. For example, I have item “1” going to “A” and “B” at two different prices. The two different tabs are not formatted the same way, but they both have the same information to return the correct value if I could just figure out the formula.

    Thanks.

    Reply
    • Catalin Bombea

      November 13, 2014 at 1:21 am

      Hi Anthony,
      You can upload a sample workbook with your calculations on our Help Desk system, i will gladly help you if you provide clear details.
      Catalin

      Reply
      • Anthony

        November 13, 2014 at 3:36 am

        Will I be charged for going through the help desk?

        Reply
        • Catalin Bombea

          November 13, 2014 at 3:38 am

          Of course not, you’re safe there πŸ™‚

          Reply
  7. Hemant Sharma

    August 7, 2014 at 3:19 pm

    Catalin, It worked, Thank You very much.
    Please if you can help me with this, Suppose A4 is $100, B4 is $40, C4 is $50, F4 is $25. G4 is$20. I need to have 5% of the lower of B4 and G4 in column D4.

    Reply
    • Catalin Bombea

      August 7, 2014 at 3:34 pm

      Hi Hemant,
      MIN function (MAX also) allows you to refer up to 255 numbers or ranges, like:
      =MIN(B4:C4,E4:G4)*0.05
      Catalin

      Reply
      • Hemant Sharma

        August 8, 2014 at 12:27 am

        Catalin, Thank You very much for all your help.

        Reply
        • Catalin Bombea

          August 8, 2014 at 3:48 am

          You’re wellcome Hemant πŸ™‚

          Reply
  8. Hemant Sharma

    August 7, 2014 at 11:10 am

    Hi Mynda,

    Suppose A4 is $100, B4 is $40. I need to have 5% of the lower of two cells in C4. How should I write it in excel formula. Thank You for your help.

    Reply
    • Catalin Bombea

      August 7, 2014 at 1:46 pm

      Hi Hemant,
      Use: =Min(A4:B4)*0.05
      Catalin

      Reply
  9. Diana Kretzschmar

    April 25, 2014 at 5:36 am

    Great Advice! Thank you!
    I have a Question tho, how must the Formula be entered if Table 1’s A-Column was actually 3 Columns, just like in Table 2? Meaning you’d still compare the 3 Columns but Source Table as well as Entry Table are the same Amount of Columns with the 4th (G) being the one that Data is to be populated in.

    Reply
  10. help me

    December 4, 2013 at 2:34 pm

    20 to 30 column and all column contain some value and all column which contain some value then total of all column and which columns total are lowest then lowest column value in another 31 column shows

    Reply
    • Catalin Bombea

      December 4, 2013 at 11:09 pm

      Hi,
      Can you upload a sample workbook, with detailed description of what are you trying to achieve? It will be easier for us to understand the situation, and the solution will come faster!:) You can use the Help Desk: https://www.myonlinetraininghub.com/helpdesk/
      Best,
      Catalin

      Reply
  11. kashif Safdar

    November 27, 2013 at 4:47 pm

    nice and thanks

    Reply
    • Mynda Treacy

      November 27, 2013 at 8:08 pm

      You’re welcome, Kashif πŸ™‚

      Reply
  12. tim mckenzie

    June 19, 2013 at 9:00 pm

    Hi,
    I have a problem with a vlookup at the moment – how do i contact you for help

    Regards
    Tim

    Reply
    • Carlo Estopia

      June 19, 2013 at 9:17 pm

      Hi Tim,

      Please explain your concerns here: HELP DESK.

      It would be best if you can send a mock file.

      Cheers,

      CarloE

      Reply
  13. Bill Fabian

    May 31, 2013 at 4:58 am

    What if we wanted to match three fields of data in on the look up sheet?
    If the three fields match 3 fields in the look up sheet true = one of the fields and false = “”

    Reply
    • Mynda Treacy

      May 31, 2013 at 8:08 am

      Hi Bill,

      I wrote another tutorial on looking up multiple values and matching them to multiple columns here.

      In it I show you a way you can use VLOOKUP and the IF function to do this, but at the bottom of the tutorial I show you another (better) way with INDEX and MATCH. Given your question it would go a bit like this:

      =INDEX(lookup_range,MATCH(A2&B2&C2,column_1&column_2&column_3,0),column_num_in_range)

      I hope that helps. If you get stuck please send me your workbook with specific instructions on what you want and where via the help desk.

      Kind regards,

      Mynda.

      Reply
      • caterina

        June 4, 2013 at 2:34 am

        Hi
        I would like to create a vlookup that would look in a specifica column all the word attached without space and insert one..do you think will be possible?

        Many thanks

        Reply
        • Mynda Treacy

          June 4, 2013 at 8:35 pm

          Hi Caterina,

          VLOOKUP is not the function for the job. You have a few options depending on your data.

          Does your data have a character where you want the space e.g. a hypen, comma, full stop etc.?

          If so you could just use the Find & Replace tool:

          1. Select the cells containing the data you want your spaces added to.
          2. CTRL+H to open Find & Replace tool
          3. Type in the character you want to replace in the ‘Find’ field
          4. Enter a space in the ‘Replace’ field
          5. Click Replace or Replace All

          If that doesn’t/won’t work please send me your workbook via the help desk so I can see what you’re working with and give you a specific solution.

          Kind regards,

          Mynda.

          Reply
  14. adnan ali

    May 17, 2013 at 12:47 am

    hi,
    linda i want a mltipal name and a diffrent heads i want if i enter head name the other branches of a head is auto,

    Reply
    • Mynda Treacy

      May 17, 2013 at 10:03 am

      Hi Adnan,

      I’m sorry I don’t understand your question. Can you please send me your Excel file with your data and specific requirements so I can better understand your question.

      Thanks,

      Mynda.

      Reply
  15. Abby

    February 7, 2013 at 5:29 am

    Can we do the reverse? I’m importing into a document where the concatenate is placed but I cannot place the concat in the document the data is coming from. In my instance, Doc 1 has site-driver-descri (site, driver, first 5 characters of description) all in col B

    The array would be from Doc 2 with no concatenate. Doc 2 has Col A for “site”, Col B for “driver” and i need the first 5 characters of the descrip housed in Col C to match. I need to pull in the value from Doc 2, column J.

    A concatenate array seems doable, but I cannot ifgure it out. I attempted to use “Lookup” solution but retrieved no results with that.

    Reply
    • Carlo Estopia

      February 7, 2013 at 6:26 pm

      Hi Abby,

      I was having a hard time really trying to work around formulas.

      So instead of going empty handed on this one, I am giving you a VBA customized function.

      Here’s the deal:
      1) ALT + F11 ( this will bring you to the VBE Window)
      2) In the VBE Window, Go To INSERT menu, Add MODULE (NOTE: NOT CLASS MODULE)
      3) In the Module, Paste this code

      Function MyVLookup(LookUpValue As String, TBLArray As Range, Col_Return As Integer) As String
          Dim r As Long
          For r = TBLArray.Cells(1, 1).Row To TBLArray.Rows.count
              If TBLArray.Cells(r, 1) & TBLArray.Cells(r, 2) & TBLArray.Cells(r, 3) Like LookUpValue & "*" Then
                  MyVLookup = TBLArray(r, Col_Return).Value
                  Exit Function
              Else
              End If
          Next
      End Function
      

      4 Here’s how the formula is used- just like any Excel Function

        =MyVLookup(A2&B2,'Doc2'!$A$2:$J$11,10)
        

      MyVlookup(LookupValue,TBLArray, Col_to_Return)

      REMINDERS:
      1 You might encounter security warnings. Just trust it.
      2 If VBA is not working, just go to Excel Options, Trust Center, Trust Center Settings, Enable Macro and ActiveX

      Cheers.

      CarloE

      PS: This is so tailor-made for you that I save ourselves the hassle of creating a very dynamic one. In short,
      The Values that this function will look for will be in Cols:A, B, and C only.
      Now you may change 1(A), 2 (B)or 3 (C) in the function–shown below in italics– if you want to have another columns to be looked up or you can copy the function in the same module and name it MyVLOOKUP2 etc., and play with the columns you like to be looked up. You may also delete or add more columns by deleting the part “TBLArray.Cells(r,1)” or adding more, respectively.

      "If TBLArray.Cells(r, 1) & TBLArray.Cells(r, 2) & TBLArray.Cells(r, 3)"
      
      Reply
  16. Kate

    December 30, 2012 at 3:57 am

    Would this work to find the corresponding text value in column “x” when my lookup might be in one of 3 columns

    Eg. I have a product available to order from 3 different companies – each company has a different item code. I want to type in the code from any company and find the product name in column “x”

    Tx

    Reply
    • Mynda Treacy

      December 30, 2012 at 4:18 pm

      Hi Kate,

      You can use this array formula:

      =INDEX($D$2:$D$6,MAX(($A$2:$C$6=F1)*ROW($A$2:$C$6)-1),1)

      Entered with CTRL+SHIFT+ENTER as this is an array formula.

      Where your 3 companies item codes are in cells A2:C6, your product name is in cells D2:D6, row 1 contains your headings and cell F1 contains the product code you want to lookup. If your data starts further down the worksheet than row 2 then you will need to change the -1 in the *ROW($A$2:$C$6)-1 part of the formula accordingly. i.e. I have taken -1 off the ROW formula to account for the header row in row 1, but if your data starts in say row 4 then you would have ROW($A$2:$C$6)-3.

      I hope that helps.

      Mynda

      Reply
  17. Michael

    December 19, 2012 at 1:11 pm

    How about in the opposite situation?

    I have around 8,000 cell values displayed in the same format:

    1 019784 FILTER BAG FRAME
    21 090016 INSEAL 15mmx1.5mm 90mm LONG

    I need the “1” (acts as an identification point for a position in the photo diagram) to be extracted into a separate cell, the “019784” (order code) to be extracted into another separate cell and “FILTER BAG FRAME” (product description) to be extracted in another separate cell for all 9,000 cells.

    N.B.
    -The identification point or position number can be either 1 or 2 digits but is always delimited by a space only after the numeric value of 1 or 2 digits.
    -The order code varies in it’s character count but there is a space before an after the order code value
    -The description has spaces throughout the sentence as per above example and there are sometimes numeric values in the description

    Can you help me with a formula to split the one cell into 3?

    Reply
    • Mynda Treacy

      December 19, 2012 at 1:58 pm

      Hi Michael,

      You can use the MID and FIND functions for this:

      To extract the order code:

      =MID(A1,FIND(" ",A1)+1,SEARCH(" ",A1,4)-SEARCH(" ",A1)-1)

      To extract the product description:

      =MID(A1,FIND(" ",A1,4)+1,99)

      Kind regards,

      Mynda.

      Reply
  18. Tanveer Samana

    December 1, 2012 at 8:40 pm

    I need the excel of the above explanation

    Reply
    • Mynda Treacy

      December 3, 2012 at 8:21 am

      Hi Tanveer,

      I don’t know what you mean. Can you please explain in a different way?

      Kind regards,

      Mynda.

      Reply
  19. Ali Mamedov

    October 11, 2012 at 9:57 pm

    What if Table 1 also contains the First Name, Initial and Last Name in separate columns? There is no way to show anything like that in the array. I have solved that by adding a new column and joining them in the new column but is there a way to do it by another way? Like using if or something else nested?

    Reply
    • Mynda Treacy

      October 11, 2012 at 10:38 pm

      Hi Ali,

      You can use the LOOKUP function like this:

      =LOOKUP(G3&H3&I3,$A$3:$A$8&$B$3:$B$8&$C$3:$C$8,$D$3:$D$8)

      Where columns G, H and I contain the values you want to lookup and A,B and C contain the table you’re looking up with the result you want returned in column D.

      Thanks to Roberto for suggesting that solution.

      I hope that helps.

      Mynda.

      Reply
      • Diana Kretzschmar

        April 25, 2014 at 6:17 am

        Mynda,

        I keep getting the #Value! error code on this formula. I had the exact same Question as Ali.
        I tried the formula and also variation with ,4) or ,4,FALSE) added to the end of your formula but nothing works.
        Here: =LOOKUP(F21&G21&H21,Sheet1!$A$2:$A$350&$B$2:$B$350&$C$2:$C$350&$D$2:$D$350)

        Data Jan 2010 – Dec 2010 is the Entry Sheet Column F (City),G (county) & H (State) will be entered and D (Zip) needs to be populated with help of the Index Sheet 1 (Library so to speak).
        Index Data is in Sheet 1 Column A-D (City, County, State & Zip)
        So IF F&G&H match A&B&C of Sheet 1 then copy Column D data into Data Sheet.

        Could you help me please?
        Thank you!
        Diana

        Reply
      • Diana Kretzschmar

        April 25, 2014 at 6:34 am

        Mynda,

        disregard my previous Question! I got it! πŸ™‚ Here: =LOOKUP(F21&G21&H21,Sheet1!$A$2:$A$350&$B$2:$B$350&$C$2:$C$350&$D$2:$D$350,Sheet1!D2:D350)

        Reply
        • Mynda Treacy

          April 25, 2014 at 9:02 am

          Glad you figured it out, Diana πŸ™‚

          Reply
  20. Nicole

    August 31, 2012 at 3:54 am

    What if data is not separated in different columns? Criteria are on the first row and the first column, just like this one:
    A B C D E
    1 0.1 0.2 0.3 0.4 0.5
    2 0.6 0.7 0.8 0.9 1.0
    3 1.1 1.2 1.3 1.4 1.5

    What is the formula for returning “1.1” if “A” and “3” are given?
    Thank you!

    Reply
    • Mynda Treacy

      August 31, 2012 at 9:40 am

      Hi Nicole,

      I’m not understanding your question 100% but if you only want to look up the values in one column then you can use a regular VLOOKUP formula.

      If that’s not what you meant, please let me know.

      Kind regards,

      Mynda.

      Reply
  21. Kosal Kong

    August 15, 2012 at 12:38 pm

    Im like both V&HLOOKUP, but my usually, commece is VLOOKUP. I am trying to looking for VLOOKUP within multiple criteria. And once again I seeking for advice to to work Piviot excel table

    Reply
    • Mynda Treacy

      August 15, 2012 at 8:37 pm

      Hi Kosal,

      I’m sorry I don’t understand what you’re having trouble with. Can you please email me with a specific example.

      Thanks,

      Mynda.

      Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Current ye@r *

Leave this field empty

Sidebar

More results...

Shopping Cart

mynda treacy microsoft mvpHi, I'm Mynda Treacy and I run MOTH with my husband, Phil. Through our blog, webinars, YouTube channel and courses we hope we can help you learn Excel, Power Pivot and DAX, Power Query, Power BI, and Excel Dashboards.

Subscribe to Our Newsletter

Receive weekly tutorials on Excel, Power Query, Power Pivot, Power BI and More.

We respect your email privacy

Guides and Resources

  • Excel Keyboard Shortcuts
  • Excel Functions
  • Excel Formulas
  • Excel Custom Number Formatting
  • ALT Codes
  • Pivot Tables
  • VLOOKUP
  • VBA
  • Excel Userforms
  • Free Downloads

239 Excel Keyboard Shortcuts

Download Free PDF

Free Webinars

Excel Dashboards Webinar

Watch our free webinars and learn to create Interactive Dashboard Reports in Excel or Power BI

Click Here to Watch Now
  • Excel
  • Excel Charts
  • Excel Dashboard
  • Excel Formulas
  • Excel PivotTables
  • Excel Shortcuts
  • Excel VBA
  • General Tips
  • Online Training
  • Outlook
  • Power Apps
  • Power Automate
  • Power BI
  • Power Pivot
  • Power Query
 
  • About My Online Training Hub
  • Contact
  • Disclosure Statement
  • Frequently Asked Questions
  • Guarantee
  • Privacy Policy
  • Terms & Conditions
  • Testimonials
  • Become an Affiliate

Copyright © 2023 · My Online Training Hub · All Rights Reserved

Microsoft and the Microsoft Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries. Product names, logos, brands, and other trademarks featured or referred to within this website are the property of their respective trademark holders.

Download A Free Copy of 100 Excel Tips & Tricks

excel tips and tricks ebook

We respect your privacy. We won’t spam you.

x