lookup for first n characters
 

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!

lookup for first n characters
 

Try something like this:

A1 = lookup value = ABCDEF

=VLOOKUP(A1&"*",'C:\TV\[dbase.xls]dbase'!$A:$B,2,0)

--
Biff
Microsoft Excel MVP


"shairal" wrote in message
...
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!

lookup for first n characters
 

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!