Is there an array formula for text?

[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

 

[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

 

[Max]

Perhaps what you're after is lookup ?
2 usual ways are either via VLOOKUP or INDEX/MATCH

Try Debra's nice coverage on VLOOKUP or INDEX/MATCH at her:

http://www.contextures.com/xlFunctions02.html
VLOOKUP

http://www.contextures.com/xlFunctions03.html
INDEX/MATCH

There's also some sample workbooks available for d/l & study

 

[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

 

[Max]

You're welcome, Michael