Results 1 to 8 of 8

Thread: Advanced If Code

  1. #1

    Advanced If Code



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi All,

    Just wondering if this is possible. I have a spreadsheet, attached which I would like to do the following with.

    If the customer concern column in ‘Step 2 sheet’ shows ‘alleged’ or ‘found’

    Then

    1 - In the ‘Defend Ltr sheet’, automatically populate the ‘Complaint Point column C10 to C39’ with the relevant text in the ‘Statement’ column in the ‘step 2’ TAB. For example, C10 in the Defend Ltr tab would equal C6 from the Step 2 tab.

    2 - In the ‘Defend Ltr sheet’, automatically populate the ‘Category column o10 to o39’ with the relevant text in the ‘Category’ column in the ‘step 2’ TAB. For example, o10 in the Defend Ltr tab would equal b6 from the Step 2 tab.

    So I would envisage the ‘Defend Ltr tab’ looking like this the completed information in the Defend Ltr tab:

    Hope this makes sense.

    Thanks
    Craig.
    Attached Files Attached Files

  2. #2
    Hi Craig...

    I am not sure, if I had correctly understood the requirements, but if you want to get the values from one sheet to another sheet, you can try...

    Formula in C10 of Defend Ltr ='Step 2'!C6
    Formula in O10 of Defend Ltr ='Step 2'!B6

    Then autofill until row 39.

    Best Regards :-)

  3. #3
    Thanks for this but this is only linked to the sheet. I need it to feed through based on if column d in the step 2 tab shows alledged or found

  4. #4

    Solution

    Hi, I have uploaded the solution for you in the same file

    You could simply use the following formula in Cell o10

    =IF(OR('Step 2'!D6="Alleged",'Step 2'!D6="Found"),'Step 2'!B6,"")

    This implies that IF D6 is either contains "Alleged" or "Found" text, Then it returns the value in B6 in Step 2

    I Guess this is what you were requesting for

    Kindly let me know if there is any other change you want to be done on this

  5. #5
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,090
    Articles
    79
    Blog Entries
    14
    Quote Originally Posted by askrocks View Post
    Hi, I have uploaded the solution for you in the same file
    Hey askrocks,

    Thanks for chipping in, but the forum doesn't work like that. You'd need to attach it as you can't modifiy others files on the servers.
    Ken Puls, FCPA, FCMA, MS MVP (Excel)

    Master your data with Power Query: Purchase your copy of my book M is for Data Monkey today!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

  6. #6
    Sorry for that Ken, actually I tried uploading the modified file initially, but couldnt due to the Security of the pc that i work on, so only the text got uploaded

  7. #7
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,090
    Articles
    79
    Blog Entries
    14
    That sounds kind of weird... I haven't heard of PC security preventing an upload. To be fair, I suppose a corporate firewall could prevent it, depending on which protocols they blocked, but I haven't received a complaint about it yet...
    Ken Puls, FCPA, FCMA, MS MVP (Excel)

    Master your data with Power Query: Purchase your copy of my book M is for Data Monkey today!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

  8. #8
    corporate firewall is more like it, we have problems with uploading attachments on our personal (YAhoo!) mails also, so thats y........apologies once again, will keep this in mind

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •