I guys I dont know if I'm over complicating it but I can only get it to return true instead of the name
I two arrays:
A1:A6 - These are the name of people
C1:C6 - A special character may be written in one single cell at any time The special character is XXX
Basically I would like it to look between C1:C6 and if it finds XXX I want it to return the name corresponding name in the same row of the array A1:A6
In this case it should just return Frank because XXX is written in C6
Thank in advance
=INDEX(A1:A5,MATCH("XXX",C1:C5,"0"))
This works but If it is XXX cannot be found then how do you get it to return "CLOSED"
I've tried every-way to be honest.
Bookmarks