![]() You would either need to filter the table or use a PivotTable. ![]() If we need to return multiple results from a table then the lookup functions are unlikely to work. ![]() As we can see, there is another match further down that VLOOKUP() has ignored. Let’s take a look at how a VLOOKUP() works:Įven this simple example shows one of the issues of the lookup functions: they only return the first match. The VLOOKUP() function assumes that your data is arranged as a table with different elements of the information in different columns. The V and H in the names of these two functions refer to Vertical and Horizontal respectively, so the good news is that once you’ve learnt how to use VLOOKUP(), HLOOKUP() should be easy, as it works in exactly the same way, but with data arranged in rows as opposed to columns. Although the Excel lookup functions can seem quite straightforward, it’s very easy to get the wrong answer if you don’t fully understand how they work.Įxcel does have an additional lookup function: LOOKUP() but this is only included for compatibility with older spreadsheet applications, so we’ll concentrate on VLOOKUP() and HLOOKUP().
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |