In Excel I would like to assign a name to a number based on a separate lists. Example, I have a part number in A1, in D1 I have a title and below it (D2-D11) I have a list of part numbers, in E1 I have another title with a list of part numbers below it, I want the formula in B1 to return the correct title based on what list the part number is in. Thanks for your help
A B C D E
1 04 FORMULA Title Other Title
2 01 100
3 02 101
4 03 102
5 04 103
6 05 105
7 06 106
8 07 107
9 08 108
10 09 109
11 10 110