=MATCH("abc",A1:A100&B1:B100&C1:C100),0)
ctrl/shift enter the above, and if it's an error, there are no abc values in
the same row, and if it returns a number, it's the row # where it occurs.

wrote in message
oups.com...
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