Find data in one table from another.

[Guest]

Try this:
=SUMPRODUCT(--ISNUMBER(SEARCH(" "&$A1&" "," "&CATALOG&" ")))>0

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro

 

[Guest]

If your part number test must be case-sensitive, meaning that
AB123 does not match Ab123, then use this:

=SUMPRODUCT(--ISNUMBER(FIND(" "&$A1&" "," "&CATALOG&" ")))>0

Helping, yet?

***********
Regards,
Ron

XL2002, WinXP-Pro

 

[Guest]

Ron, you are the man! That did it perfectly. Now I just have to wait for it
to calculate.

 

[Guest]

Thanks for the feedback...I'm glad that worked for you.

***********
Regards,
Ron

XL2002, WinXP-Pro