Index Match Formula Issue - Lookup Value is a Formula

Hi,
I am having trouble with my Index Match formula. The lookup value (column C) is in the adjacent cell but it is a formula. It works on the cells that have letters in them. But, the ones with all numbers if does not. If I add a value function to the formula it works. But, only on cells with all numbers. Would like to find a way it would work with both all numbers and cells with letter number combinations. Please see my attached example.
Thanks in advance for the help.

Enter this formula in D2 and copy across and down

Formula:

Please Login or Register  to view this content.

This is an incredibly large number that can be entered in Excel and most likely doesn't exist withing the lookup_vector. Since the LOOKUP function typically works on a sorted (ascending order) range it will go for the last row assuming that this is where the largest value exists. However, when used with SEARCH or FIND functions, the only number it will find is the one returned by the search function.

Please don't forget to thank those who helped by clicking on Add Reputation * and please mark thread as "Solved" if your issue has been resolved. (Selecting Thread Tools-> Mark thread as Solved).