The third argument requires the column index number of the array for finding the desired cell value. In the second argument, we have used the MATCH function, and so the MATCH function will return the desired row index number according to the currency automatically. Remember, this array should also be absolute. The first argument is the array F4:G10 from which we would extract the values. For an E xact match, we have written 0 here. So, you need to absolutely refer with a dollar($) sign or press F4.Īnd, the last argument denotes the type of match. Remember, you must use an absolute array here. That’s why we have chosen the F4:F10 cell reference. So, we have to select the cells where the currencies locate. Now, the MATCH function only gives the index number of the value. We reference the C5 cell as the first argument as this is the cell carrying desired currency and this is the value that we have to look for in the dataset. You can convert currency using the VLOOKUP formula too. How to Convert CAD to USD in Excel (4 Easy Ways)ģ.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |