Link to home
Get AccessLog in
Avatar of Tiger858
Tiger858

asked on

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

Want to compare the two highlighted arrays and return true if any of the cells match
Capture.PNG
Avatar of Shums Faruk
Shums Faruk
Flag of India image

Can you please explain more. Cell reference, Rows, Columns. Or Sample Workbook would be helpful
Avatar of Tiger858
Tiger858

ASKER

I have attached a picture to help
Return where?
to where ever the formula is located
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
Sorry i would like the formula to be able to tell using only one formula. i have attached an example of this
Book1.xlsx
ASKER CERTIFIED SOLUTION
Avatar of Shums Faruk
Shums Faruk
Flag of India image

Link to home
membership
This content is only available to members.
To access this content, you must be a member of Experts Exchange.
Get Access
Exactly what i was after thank you
You're Welcome Tiger858! Glad I was able to help.