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

In C2:

=VLOOKUP(A2,A2:B6,2,0)

A2 = TM72001. Instead of A2 as the lookup value, you could have a drop down list in say F1 with all the TM..... numbers.

Then the formula would look like this.
=VLOOKUP(F1,A2:B6,2,0)

Regards,
Howard