• 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.

Looking up 2 columns

Hiall211

New Member
Hi,

I was wondering if someone can help me with this. In column C I would put the formula for each row.

I wanted to look up if the value in Column A for value "CA" had any blank values in Column B then it would return "Yes". Also if column A for value "BA" has no blank values in column B it would return "No".

Column A Column B Column C
CA 1/1/2014 Yes
CA 2/2/2014 Yes
CA 4/2/2014 Yes
CA Yes
CA Yes
BA 2/2/2014 No
BA 3/3/2014 No
BA 1/1/2013 No
BA 2/2/2012 No
 
Hi,

Welcome to the forum.

With the above information I think this would do:

=IF(A1="CA","Yes",IF(AND(A1="BA",B1<>""),"No"))

Considering your data starts from A1.

Regards,
 
Hi Somendra, Thanks. I don't think that's what I'm looking for.

I attached an excel file example. I am trying to automate this query in column C. I need each row to be filled out with Yes or No in column C.
 

Attachments

  • example.xlsx
    8.9 KB · Views: 8
Hi,

Yes I set up the other example to make the question more clear. I need to turn Column C query into a formula. Right now I'm just manually doing each one. Is it possible?
 
Back
Top