It returns the index number of the lookup value. The MATCH function doesn’t return a cell value.Using the INDEX function, you can extract values both vertically and horizontally. The INDEX function has a great advantage over the VLOOKUP function.But, if you lookup text values, it is very advisable to put the range_lookup argument as FALSE, if you want an exact match always. If you lookup numbered values, the range_lookup argument is not so important.And, the return value column index number will be put according to this serial. Another thing, you should remember is that, when selecting the table array, keep the lookup value column as the first column in your selection.You can not look up your value through the horizontal rows. So, you can only look up your values through the columns. When using the VLOOKUP function, remember that this is a vertical lookup process.Read More: How to Create Real Time Currency Converter In Excel ![]() As the exchange rate is situated on the second of our selected array, we write 2 in the third argument’s place. 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)ģ.How to Get Exchange Rate by Date in Excel (2 Suitable Methods).Convert Euro to USD in Excel (2 Handy Methods).Read More: How to Convert USD to CAD in Excel (4 Quick Tricks) Remember, the Asterisk sign (*) is used for multiplication in Excel. As the EUR exchan`ge rate is 0.94 in respect of the USD, so we write 0.94 in the second argument. Now, in the second argument, we have to set the value for the true return of the logical test. If the currency is EUR, true will be returned. ![]() Now, if the first logical test returns false, it will go to the second IF, and at the first argument, it will test if the desired currency is EUR. If our desired currency is USD, we have set our exchange rate as 1. The second argument requires the input of the value returned when the logical test is true. Writing =IF enables the IF function of Excel.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |