On both Sheet1 and Sheet2 I have recurring numbers (such as A135 and a second
line of A135). Could that mess up the search ? Probably so because it
wouldn't know which one to pick.
It depends on what you want for a result. When there are multiple identical
matches, your formula will return the first match.
What do you mean by "mess up the search"?
What kind of a number is A135? It doesn't seem to be a real number, nor a
complex number. Is it a numeric value that you have custom formatted to
display this way?
What do you mean, in your previous post, by "doesn't work"?
If that is true, is there a formula to get rid of all repeats of the same
number ?
There are methods to get rid of duplicates. You can filter your list and
select to return only unique entries. I don't have the slightest idea whether
that will be of any value to you.
The reason you have been getting responses that are less than helpful is
because we are limited by the amount of information you have provided.
In order to receive pertinent advice, instead of generalities, it would be best
if you would provide examples of your data, lookup values, etc. You need to
provide the actual data that is in the formula bar when you select the cell,
and not what the cell appears to show -- as that can be influenced by
formatting. The contents of the cells can also be affected by whether the
values are entered directly, or generated by a formula. If the latter, the
precedents should also be supplied.
--ron