Stormseed, you can use the drop down on the left to change from Dutch (Nederlands) to English.
Personally I prefer just to create a unique key by concatonating the columns that I wish to search and then use a combination of index and match to return the values that I require, this has the advantage of being able to specify exact or nearest matches.
It is very true that one should follow that concept you defined here using index(match()). However, this can cause discrepancies the reason being possible data duplication. Also, you cannot implement this concept on entirely seperate values in 2 different columns. Moreover, in order to find the nearest values in a lookup, I wud rather make use of the "TRUE" or "1" expression for retrieving column field in the formula.
Dear NBVC & Others:
thanks for the clarification you provided. I checked out the UDF. However, I cannot figure out the use of the UDF in order to achieve my needs. Check this thread and kindly let me know if I can implement this UDF to accomplish my need !