Try This

LOOKUP(1E+300,SEARCH($A$2:$A$4,E2),$E$2:$E$4)


"shairal" wrote:

I need for a lookup type formula that looks at a cell in workbook1, then does
a lookup in workbook2 for the 'root' part.

So in workbook1 I have part numbers like ABCDEF, HIJK, LMNOPPQ, etc. In
workbook2, I need to look through a list of parts like ABCDEF123k, HIJK54,
LMNOPPQ999, and input this information into workbook1. So, ABCDEF would
return the information from part ABCDEF123K.

Any help would be greatly appreciated!!
Thanks in advance!