In this Excel video tutorial, we gonna see how to Concatenate Values in Excel with Practical Examples and also how to use Vlookup with Two Criteria in Excel or how to use lookup function with multiple criteria.

The concat or concatanate formula in Excel, can join two or more text strings into one string or in other words, it can append cells together. We can append texts, numbers, formulas, values etc.

in the first example we going to see how can we group together the first name in the last name of a person and that way we going to have the complete name or the full name so if you have a list of names there are separate from each other I mean you have the first name the middle name and the sure name you can append those values together using the concatenate function in Excel

in the second example we going to see how can you create emails addresses for each one of the people that we have in the list for each one of the names but something that we need to think about it is we do not have the email address in the list but we can create the email address for the list within the concatenate function in Excel so in between quotations marks we can append any type of text that we want to use in our concatenation

in the third example we going to see how can we create passwords in Excel how to randomly generate passwords in Excel using the concatenate function and again I hear we're going to use the name the middle name the surname and also the email address with some random numbers to create a temporary password

in the 4th and last example but I know list important we going to see how can we use the vlookup function in Excel with two different criteria or with multiple criteria. The Vlookup function help us to look up for something and bring it back the corresponding value as result. in this case in this scenario in this example I need you look up for two different information there are the products name and also the products category. if the name and also the category of the product match with the thing that I'm looking for I'm going to have as result the cost or the price of this specific item.

#JopaExcel #Dashboard #Excel