On Thursday, April 11, 2013 4:44:54 PM UTC-7, Excel Dumbo wrote:
Hello,



Could you please help design a lookup formula as shown in the attached

spreadsheet ?

Thanks



Dumbo





+-------------------------------------------------------------------+

|Filename: Complicated Lookup.zip |

|Download: http://www.excelbanter.com/attachment.php?attachmentid=841|

+-------------------------------------------------------------------+







--

Excel Dumbo

Maybe I missread your problem.

Try this in C2

=VLOOKUP(LEFT(F1,7),A2:B6,2,0)

Where TM72001-S1-K.Cantlon is in F1.

Does that do it?

Howard