Indirect & Match Formula Problem

J

jkim

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%
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top