Find data in one table from another.

R

Ron Coderre

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

Does that help?

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

XL2002, WinXP-Pro
 
R

Ron Coderre

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
 
M

micmed

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

Ron Coderre

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

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

XL2002, WinXP-Pro
 
Top