Is there an array formula for text?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mrlanier@hotmail.com - 27 Dec 2006 12:21 GMT

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

Reply to this Message

RichardSchollar - 27 Dec 2006 12:29 GMT

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

> 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:
[quoted text clipped - 8 lines]
>
> Michael

Reply to this Message

Max - 27 Dec 2006 13:53 GMT

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

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

> 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:
[quoted text clipped - 8 lines]
>
> Michael

Reply to this Message

mrlanier@hotmail.com - 27 Dec 2006 14:16 GMT

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

Reply to this Message

Max - 27 Dec 2006 14:34 GMT

You're welcome, Michael

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

> 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

Reply to this Message

Rate this thread: