Getting text answers without using Lookup functions

  • Thread starter Thread starter Jerry
  • Start date Start date
J

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
 
When the match type is set to 0 (=FALSE), they will do what you want.

=VLOOKUP(LookupValue,LookupTable,ColIdx,0)
 
Back
Top