Is there an array formula for text?

M

mrlanier

By using the following array, I can call up the sum of corresponding
numbers in column B as a result of conditions set in column A:

{=SUM(IF(A1:A100=1,B1:B100))}

However, I need to call up text instead of numbers in column B. For
example, if the number 1 appears anywhere within column A's range, and
the text corresponding to 1 is "Volkswagon" in column B, I need to call
up the text rather than a sum of numbers. Are there any suggestions?
Thanks.

Michael
 
R

RichardSchollar

Michael

What do you mean by "call up the text"? Can you provide an example
giving data and expected result from the formula. Thanks.

Richard
 
M

mrlanier

Max,

Thanks for the links. When I get time I will explore them both. At a
glance, both look like what I'm seeking.

Michael
 
Top