Lookup text

[gunnar]

Hi!
I have two ranges I wanna match. The content of the ranges
are numbers. If match, I wanna pick up the TEXT (AorB)from
the column to right of one of the ranges. I regularly use
SUMIF function, which works fine if the content I wanna
pick up is numbers.
Does anyone know how to solve this problem?
Here is the sumif example: {=SUM(IF(Deliveries!
$H$9:$H$158=$E6;IF(Deliveries!$D$9:$D$158=$G6;Deliveries!
$J$9:$J$158;0);0))}

Help is appreciated.
Gunnar

 

[Leo Heuser]

Hi Gunnar

This array formula:

=INDEX(Deliveries!$J$9:$J$158,MATCH(1,(Deliveries!$H$9:$H$158=$E6)*
(Deliveries!$D$9:$D$158=$G6),0))

Enter with <Shift><Ctrl><Enter> instead of <Enter>

will work for numbers as well as text.

--
Best Regards
Leo Heuser
MVP Excel

Followup to newsgroup only please.