Is there an array formula that works with text?

[MichaelRLanier]

The array formula {=SUM(IF(A1:A10=1,B1:B10))} will return the contents
of B2 if A2=1 and the content of B2= a number. But what if B2= text?
Can this formula, or one similar to it, be made to return a letter or
word—something other than a number?

 

[Max]

VLOOKUP or INDEX/MATCH would spring to mind
Try Debra's nice coverage on these functions 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

 

[MichaelRLanier]

Thanks for your help Max. I'll try your suggestion.

 

[Max]

Welcome