Getting text answers without using Lookup functions

[Jerry]

Hello Out There,

Because lookup formulas require the initial range
structure to be in sequence I cannot use them to return an
text answer on my worksheet. The information used is
random and should not be sorted for this purpose. I use
sum(if( to get 99% of the information but still need to
get the alpha numeric data.

Example: A B C D
1

 

[Aladin Akyurek]

When the match type is set to 0 (=FALSE), they will do what you want.

=VLOOKUP(LookupValue,LookupTable,ColIdx,0)