Need a more detailed explanation.

Biff

"Brian" wrote in message
...
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,