Vlookup using the range of the given value.
FindTaim is an Excel vba function to look up a numeric data in a range between value 1 and
value 2 in a table organized vertically. These two values must appear in the first two columns of
the table passed into FindTaim function. Then it returns the value found in the column whose
number is passed into FindTaim function.
The code of this function is open-source and it is given in module 1 so click on ( Alt +F11) and you
are free to reuse it as much as you want.
The syntax of this function is :
=FindTaim (a, table, colonne)
Its arguments are :
- a- The numeric value to look for in the range given by the first and the second columns of a table.
- table - The table from which to retrieve a value.
- colonne- The column in the table from which to retrieve a value.
When you use FindTaim, every column in the table is numbered, starting from the left to the
right. To get a value from a particular column, provide the appropriate number using the column
index.
For example, the column index to retrieve the value of 2030 is 4 in the example given
below :