To keep things easier to understand, these two pieces of data are kept on two separate sheets within the Excel worksheet. This is the data that we will be working with so you can clearly see how this technique can be implemented.
Let’s assume that we have a large list of products which are associated with multiple different categories as can be seen below
HOW TO USE VLOOKUP IN EXCEL TABLE HOW TO
Throughout this blog post we’ll look at what each of these mean and how they can all be used in conjunction to perform a function what is essentially equivalent to a VLOOKUP within a VLOOKUP.īefore we jump into how to solve the problem of performing a VLOOKUP within a VLOOKUP, here is the data that we will be working with. The solution to this is quite a complex one and one that involves many different Excel formulas including But we aren’t going to look at why this is so great here, we are going to look at the main limitation and most importantly how to get around this with more clever magical Excel formulas. This is such a powerful function that can be used to speed up work in so many different ways. What this means in basic terms is “find me a specific cell within a table of data where a certain criteria is met”. =VLOOKUP(lookup_value,table_array,col_index_num,range_lookup) Let’s remind ourselves what the VLOOKUP function actually does The reason this isn’t possible is due to the way the VLOOKUP function works. One of the major challenges within Excel is trying to use a VLOOKUP function within a VLOOKUP function. Within our daily work we use Excel an awful lot, so naturally we like to use Excel to its full potential using lots of exciting formulas.
0 kommentar(er)
