We help IT Professionals succeed at work.

Compare values in 2 arrays and return true if any of the values match

91 Views
Last Modified: 2017-03-30
Want to compare the two highlighted arrays and return true if any of the cells match
Capture.PNG
Comment
Watch Question

ShumsManaging Director/Excel VBA Developer
CERTIFIED EXPERT
Distinguished Expert 2018

Commented:
Can you please explain more. Cell reference, Rows, Columns. Or Sample Workbook would be helpful

Author

Commented:
I have attached a picture to help
ShumsManaging Director/Excel VBA Developer
CERTIFIED EXPERT
Distinguished Expert 2018

Commented:
Return where?

Author

Commented:
to where ever the formula is located
ShumsManaging Director/Excel VBA Developer
CERTIFIED EXPERT
Distinguished Expert 2018

Commented:
You can name the range for Opens and use below formula Assuming your Close list is from row 15 in Column A
=COUNTIF(Opens,A15)>0

Open in new window

Compare-Values.xlsx

Author

Commented:
Sorry i would like the formula to be able to tell using only one formula. i have attached an example of this
Book1.xlsx
Managing Director/Excel VBA Developer
CERTIFIED EXPERT
Distinguished Expert 2018
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION

Author

Commented:
Exactly what i was after thank you
ShumsManaging Director/Excel VBA Developer
CERTIFIED EXPERT
Distinguished Expert 2018

Commented:
You're Welcome Tiger858! Glad I was able to help.