My source of information has been these newsgroups and other forums.
One can learn quite a bit by watching others and asking questions.

Note that using...

SEARCH(" "&D2&","," "&B2:B4&",")

....instead of...

SEARCH(D2,B2:B4)

....ensures that SEARCH will find/match the correct value. For example,
if the value you're looking for is 8926, and A2:B4 contains the
following...

52177 9561
62532.01 89265
726589 90026, 8926

....the first one would match B4, whereas the second one would
incorrectly match B3.

Hope this helps!

In article ,
"Kok Yong Lee" wrote:

Hi Domenic,

Any where I can find more information regarding your rather exotic usage of
'&' character in SEARCH(" "&D2&","," "&B2:B4&",")?

many thanks.