• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 217
  • Last Modified:

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

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
syeager305
Asked:
syeager305
  • 2
1 Solution
 
StephenJRCommented:
If there is only one, this array formula perhaps?

=SUM(IF(E22:J22=$R$2:$R$17,R2:R17))
0
 
StephenJRCommented:
I must say I'm surprised your (array) formula worked at all.
0
 
barry houdiniCommented:
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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now