Hello,

I want to find the rownumber where three coulumns match a predefined
value. Say column a must be x, culumn b must be y and column c must be
z. I could create a loop testing columns a,b and c in every row till I
find the wanted data, but that's very slow. Alternatively I could
create an extra column d with labels made up from the data in the
columns a b and c. And use the find method to find xyz in this column.
This doesn't seem very efficient to me either.

Does any-one know a more efficient way to find the wanted data?


Wilco