I need to be able to look in an array that contains both text and numbers for
a text a value in a row. When that value is found I need the amount from the
100 row in the column where the text value I was searching for was found. I
have tried using hlookup, lookup, find but have not had any success. Can
anyone be of assistance.

Thanks,