Nkoli wrote:
If Find & Replace finds the value you're using as the search criterion, then make sure the search vector begins in the column that contains the match for the search criterion. The result vector can only be one column
It is.
and it's probably better to have the search vector as one column as well since the match has to be in the first column.
It is.
Also, if you're typing in the text rather than using a cell reference for the search criterion, double check that the text is enclosed in double quotes. That's all I can think of for now. Good luck.
Nope, the criterion is is a cell reference. My lookup (in Sheet2) =LOOKUP(A2;Sheet1.$A$2:$A$65536;Sheet1.$F$2:$F$65536) /Per -- Per Jessen, Zürich (18.4°C) -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org