monline

I was looking for the solution and Google came up with a number of Excel-plugins (third party software) that one can use to do the job. However there's a builtin function that can be used in a number of situations to solve the problem. Here's a nice tutorial on how to do that

The only problem I had to solve by myself was that my Excel didn't accept the functions as it was written in the tutorial. It took me a couple of minutes until I realized that my Hungarian Excel expects the function name and the string operators in Hungarian.

So the original example (=VLOOKUP(A7,Products!$A$2:$C$5,2,FALSE)) should be converted to this in Hungarian Excel: =FKERES(A7,Products!$A$2:$C$5,2,HAMIS)

Here's the Hungarian online help for the FKERES function.