I'm trying to use an array formula that matches Lookupb to the record in
column a based on match to LookupA. The formula I use is as follows:
=INDEX($A$2:$B$26,MATCH(C2,B$2:B$26,0),1)
This works but once I try to make it an array it only shows the figure for
the first record match on Lookup B. I need to use an array due to
performance issues. This works too slow if I just use the formula above
without as a copy and paste. Any suggestions on how to convert to an array
and still get desired results.

Below is sample table

ShowUpRate LookupA LookupB ShowUpRate
50% 12.00 1.00 17%
33% 14.00 2.00 17%
38% 17.00 3.00 17%
17% 23.00 4.00 17%
40% 16.00 5.00 17%
50% 18.00 6.00 17%
33% 22.00 7.00 17%
0% 24.00 8.00 17%
50% 26.00 9.00 17%
0% 25.00 10.00 17%
60% 19.00 11.00 17%
33% 21.00 12.00 17%
33% 8.00 13.00 17%
50% 7.00 14.00 17%
25% 15.00 15.00 17%
0% 13.00 16.00 17%
0% 20.00 17.00 17%
43% 11.00 18.00 17%
40% 10.00 19.00 17%
43% 9.00 20.00 17%
33% 6.00 21.00 17%
17% 1.00 22.00 17%
78% 4.00 23.00 17%
57% 5.00 24.00 17%
46% 3.00 25.00 17%

=INDEX(A2:B26,MATCH(C2:C26,B2:B26,0),1)

should be ur formula, which u should insert to d2:d26 for instance.
Highlight the block, insert the formula end press ctrl+shift+enter.
Believe I undertood what u tried to get.

"jkim" wrote:

I'm trying to use an array formula that matches Lookupb to the record in
column a based on match to LookupA. The formula I use is as follows:
=INDEX($A$2:$B$26,MATCH(C2,B$2:B$26,0),1)
This works but once I try to make it an array it only shows the figure for
the first record match on Lookup B. I need to use an array due to
performance issues. This works too slow if I just use the formula above
without as a copy and paste. Any suggestions on how to convert to an array
and still get desired results.

Below is sample table

ShowUpRate LookupA LookupB ShowUpRate
50% 12.00 1.00 17%
33% 14.00 2.00 17%
38% 17.00 3.00 17%
17% 23.00 4.00 17%
40% 16.00 5.00 17%
50% 18.00 6.00 17%
33% 22.00 7.00 17%
0% 24.00 8.00 17%
50% 26.00 9.00 17%
0% 25.00 10.00 17%
60% 19.00 11.00 17%
33% 21.00 12.00 17%
33% 8.00 13.00 17%
50% 7.00 14.00 17%
25% 15.00 15.00 17%
0% 13.00 16.00 17%
0% 20.00 17.00 17%
43% 11.00 18.00 17%
40% 10.00 19.00 17%
43% 9.00 20.00 17%
33% 6.00 21.00 17%
17% 1.00 22.00 17%
78% 4.00 23.00 17%
57% 5.00 24.00 17%
46% 3.00 25.00 17%

Thanks looks like it will work

"Alojz" wrote:

=INDEX(A2:B26,MATCH(C2:C26,B2:B26,0),1)

should be ur formula, which u should insert to d2:d26 for instance.
Highlight the block, insert the formula end press ctrl+shift+enter.
Believe I undertood what u tried to get.

"jkim" wrote:

I'm trying to use an array formula that matches Lookupb to the record in
column a based on match to LookupA. The formula I use is as follows:
=INDEX($A$2:$B$26,MATCH(C2,B$2:B$26,0),1)
This works but once I try to make it an array it only shows the figure for
the first record match on Lookup B. I need to use an array due to
performance issues. This works too slow if I just use the formula above
without as a copy and paste. Any suggestions on how to convert to an array
and still get desired results.

Below is sample table

ShowUpRate LookupA LookupB ShowUpRate
50% 12.00 1.00 17%
33% 14.00 2.00 17%
38% 17.00 3.00 17%
17% 23.00 4.00 17%
40% 16.00 5.00 17%
50% 18.00 6.00 17%
33% 22.00 7.00 17%
0% 24.00 8.00 17%
50% 26.00 9.00 17%
0% 25.00 10.00 17%
60% 19.00 11.00 17%
33% 21.00 12.00 17%
33% 8.00 13.00 17%
50% 7.00 14.00 17%
25% 15.00 15.00 17%
0% 13.00 16.00 17%
0% 20.00 17.00 17%
43% 11.00 18.00 17%
40% 10.00 19.00 17%
43% 9.00 20.00 17%
33% 6.00 21.00 17%
17% 1.00 22.00 17%
78% 4.00 23.00 17%
57% 5.00 24.00 17%
46% 3.00 25.00 17%

glad helping, cheers

"jkim" wrote:

Thanks looks like it will work

"Alojz" wrote:

=INDEX(A2:B26,MATCH(C2:C26,B2:B26,0),1)

should be ur formula, which u should insert to d2:d26 for instance.
Highlight the block, insert the formula end press ctrl+shift+enter.
Believe I undertood what u tried to get.

"jkim" wrote:

I'm trying to use an array formula that matches Lookupb to the record in
column a based on match to LookupA. The formula I use is as follows:
=INDEX($A$2:$B$26,MATCH(C2,B$2:B$26,0),1)
This works but once I try to make it an array it only shows the figure for
the first record match on Lookup B. I need to use an array due to
performance issues. This works too slow if I just use the formula above
without as a copy and paste. Any suggestions on how to convert to an array
and still get desired results.

Below is sample table

ShowUpRate LookupA LookupB ShowUpRate
50% 12.00 1.00 17%
33% 14.00 2.00 17%
38% 17.00 3.00 17%
17% 23.00 4.00 17%
40% 16.00 5.00 17%
50% 18.00 6.00 17%
33% 22.00 7.00 17%
0% 24.00 8.00 17%
50% 26.00 9.00 17%
0% 25.00 10.00 17%
60% 19.00 11.00 17%
33% 21.00 12.00 17%
33% 8.00 13.00 17%
50% 7.00 14.00 17%
25% 15.00 15.00 17%
0% 13.00 16.00 17%
0% 20.00 17.00 17%
43% 11.00 18.00 17%
40% 10.00 19.00 17%
43% 9.00 20.00 17%
33% 6.00 21.00 17%
17% 1.00 22.00 17%
78% 4.00 23.00 17%
57% 5.00 24.00 17%
46% 3.00 25.00 17%