• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

search entire column

what i am trying to achieve is

if d4 value is GF then check all IDs in B4:10 if any has the value of Y from table U4:AC23

if d4 = GF then check ID 15064 from table U4:AC23 value whether it is Y or N
if d4 =GF then check ID 15065 from table U4:AC23 value Y or N
.
.
.
.
.
if d4 value is GF then check ID 18873 from table U4:AC23 value Y or N
 

Attachments

Back
Top