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

Excel search - multiple items in one list (formula help wanted) [SOLVED]

R

Radish

New Member
Hello all,


I'm trying to work out a formula to do some searches in a sheet of data, but everything I can find on formulas doesn't seem to help me. So I figured I'd ask here.


My sheet has the following data arrangements:


Column A: name

Column B: e-mail

Column C: a 'Yes/No' indicator

Column D: name


I need a formula to perform the following functions for me:


- Look at cell in column C. If Indicator is 'No', display 'Orderer'. End of function.

- If indicator is 'Yes', look at corresponding cell in column A. For example, if C23 says 'Yes', look at A23.

- Take the value from the cell from column A (per example, A23) and look this up in column D.

- If the value appears in column D (this can be once or multiple times), display 'Approver'. End of function.

- If the value does not appear in column D, display 'Approver - no users'. End of function.


I need to then copy this formula for about 700 lines.


Cheers,


Radish
 
I think this is what you're looking for:

=IF(C2="No","Orderer",IF(COUNTIF(D:D,A2),"Approver","Approver - no users"))


PS. Thanks for having a very good description. Gave lots of detail, and clearly explained what you wanted. Makes coming up with a solution a lot easier. =)
 
That is it! Awesome, thank you very much! As so often before, I was trying to make things way more complicated than they had to be. :o)
 
You must log in or register to reply here.
Back
Top