Sep 10, 2022 12:00 AM

Wildcards in Excel VLOOKUP XLOOKUP and SUMIFS - 2512

External YouTube Channel

Mohammad asks: How do we vlookup part of a cell in part of another cell. For example, find "bank of america" in "you have received money from bank of america account". This video shows how to solve this with VLOOKUP, XLOOKUP, and SUMIFS

For example, find "bank of america" in "you have received money from bank of america account". This video shows how to solve this with VLOOKUP, XLOOKUP, and SUMIFS.

In this Video

  • (0:00) Wildcard in VLOOKUP
  • (1:01) Wildcard in XLOOKUP
  • (1:57) Buy a book
  • (2:07) Wildcard in SUMIFS

Topic in this Video

  • wildcard excel lookup
  • wildcards in excel formula
  • how to use excel wildcards
  • excel how to search wildcards
  • what are excel wildcards
  • wildcards excel search
  • excel wildcard search in formula
  • excel wildcard search not working
  • excel wildcards search
  • microsoft excel wildcards
  • microsoft excel wildcard in formula
  • wildcard not working excel
  • excel wildcards does not work
  • excel using wildcards

More about Excel Features

What are the XLOOKUP & VLOOKUP functions in Excel?

The XLOOKUP and VLOOKUP functions in Excel are used to find, or 'lookup', a value from a table or a list and then return a related result. In this resource, we’ll discuss XLOOKUP vs VLOOKUP with examples of how to use each.

https://www.goskills.com/Excel/Resources/Xlookup-vs-vlookup

XLOOKUP just killed VLOOKUP: everything to know about this major new Excel function

Microsoft recently announced the upcoming release of a new function called XLOOKUP. This function will be replacing the widely used VLOOKUP, HLOOKUP and INDEX/MATCH functions to run searches in a table of Excel data.

https://www.powerusersoftwares.com/post/xlookup-just-killed-vlookup-everything-to-know-about-this-major-new-excel-function