Solved

# I'm bring back a match between two different arrays in excel?

Posted on 2011-09-08
211 Views
OR(E22:J22=\$R\$2:\$R\$17)

This brings back true, there is one and only one true, I just need to bring back that true value.

I tried : Match(true, OR(E22:J22=\$R\$2:\$R\$17), 0), to get the number, but it didn't seem to work.
0
Question by:syeager305
• 2

LVL 24

Expert Comment

ID: 36506738
If there is only one, this array formula perhaps?

=SUM(IF(E22:J22=\$R\$2:\$R\$17,R2:R17))
0

LVL 24

Expert Comment

ID: 36506791
I must say I'm surprised your (array) formula worked at all.
0

LVL 50

Accepted Solution

barry houdini earned 500 total points
ID: 36506907
Try this formula

=INDEX(E22:J22,MATCH(1,INDEX((COUNTIF(\$R\$2:\$R\$17,E22:J22)>0)+0,0),0))

regards, barry
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

### Suggested Solutions

Recently Microsoft released a brand new function called CONCAT. It's supposed to replace its predecessor CONCATENATE. But how does it work? And what's new? In this article, we take a closer look at all of this - we even included an exercise file for…
My experience with Windows 10 over a one year period and suggestions for smooth operation
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…