We are trying to find our lookup value within a range of values.
It refers to a range between two values, such as a number between 1 and 100, 101 and 200, or in the case of dates, between 1/1/14 and 3/31/14. The word range here doesn’t refer to a worksheet range, such as A1:B10. So, what is a range lookup? It means we are trying to find a value between two endpoints. The fourth argument, the optional range_lookup value, is the argument that enables us to easily translate dates into fiscal quarter groups, or, perform any other range lookup. – true or false, are we doing a range lookup?.col_index_num – the column that has the value to return.table_array – the range in which we are looking.The syntax for the VLOOKUP function follows: =VLOOKUP(lookup_value, table_array, col_index_num, ) To accomplish this, we’ll first need to investigate in detail the function’s fourth argument, the range lookup argument. In this post, we use the VLOOKUP function to convert or translate calendar year transaction dates into fiscal year periods, such as a fiscal quarter. I’m a huge fan of the VLOOKUP function, and am surprised by its day-to-day utility for accountants.
0 kommentar(er)
