![]() We can insert MATCH into the VLOOKUP function in place of the column number. We will be using 0 as that will provide an exact match. The last argument in the MATCH function is important. If we were to look up “Nov”, this would return 11, as that is the 11th item. ![]() The result of this formula is 6, as in the Range B1-M1 “Jun” is the 6th item. ![]() Using our example data we can find the column number of “Jun” using the Match function. The MATCH function is a very useful it returns the position of a lookup value within a range. In these circumstances, we may need to look up to both the column and the row at the same time, such as in the data below.īut how can we achieve this? VLOOKUP & MATCHīy combining the VLOOKUP function with the MATCH function, we can achieve a lookup to a row and a column at the same time this is often referred to as a two-way lookup. There are times when our data is laid out in columns and rows. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |