+ Reply to Thread
Results 1 to 4 of 4

How to match CONCATENATE, (multiple) IFs and LOWER for a descriptive URL?

  1. #1
    Registered User
    Join Date
    02-13-2016
    Location
    London
    MS-Off Ver
    Mac 2011
    Posts
    2

    How to match CONCATENATE, (multiple) IFs and LOWER for a descriptive URL?

    Hello!

    I have this problem, for which I have made any progress so far... It has to do with an ecommerce site and creation of facets; I want to replace the annoying parameters with descriptive URLs that will come through the use of facets.

    column B (b2): http://www.ecommercesite.com (and also it has to be the result of the below)
    column C (c2): http://www.ecommercesite.com
    column D (d2): Level 1: Furniture
    column E (e2): Level 2: Sofas
    column F (f2): Level 3: Two Seater Sofas
    column G (g2): Level 4: Chesterfield
    column H (h2): Level 5: Muuto

    I want this URL (from B2) : http://www.ecommercesite.com to show like this:
    http://www.ecommercesite.com/furnint...terfield/muuto

    I know that it has to be a combination of multiple IFs, CONCATENATE and LOWER but I am only 30-40% there. I am having issue with the use of hyphens within the subfolders.
    That's what I have done: =LOWER(CONCATENATE(IF(C2="http://ecommercesite.com","http://www.ecommercesite.com"),H2,G2,"/",F2,"/",E2,D2))

    If anyone could help that would be amazing!
    Thanks!

  2. #2
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.83 (24031120))
    Posts
    8,743

    Re: How to match CONCATENATE, (multiple) IFs and LOWER for a descriptive URL?

    IF(C2="http://ecommercesite.com","http://www.ecommercesite.com"),H2,G2
    thats trying to do the IF


    http://www.ecommercesite.com/furninture/sofas/two-seater-sofas/chesterfield/muuto


    "http://www.ecommercesite.com"),H2,G2,"/",F2,"/",E2,D2
    column C (c2): http://www.ecommercesite.com
    column D (d2): Level 1: Furniture
    column E (e2): Level 2: Sofas
    column F (f2): Level 3: Two Seater Sofas
    column G (g2): Level 4: Chesterfield
    column H (h2): Level 5: Muuto
    SO

    ="http://www.ecommercesite.com"&"/"&D2&"/"&E2&"/"&F2&"/"&G2
    should give you the string - then you need to use hyperlink

    =HYPERLINK("http://www.ecommercesite.com"&"/"&D2&"/"&E2&"/"&F2&"/"&G2)

    in fact as the first part is in C2

    =HYPERLINK(C2&"/"&D2&"/"&E2&"/"&F2&"/"&G2)

    if you want to change to lowercase
    =LOWER(HYPERLINK("http://www.ecommercesite.com"&"/"&D2&"/"&E2&"/"&F2&"/"&G2))

    I dont know what your trying to do with the IF
    Wayne
    if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  3. #3
    Registered User
    Join Date
    02-13-2016
    Location
    London
    MS-Off Ver
    Mac 2011
    Posts
    2

    Re: How to match CONCATENATE, (multiple) IFs and LOWER for a descriptive URL?

    Hi!
    Thank you for your quick response - it's very much appreciated!
    I thought of multiple IFs, because I may want in the next row below to use 2 out of the 5 facets and in then in the row after I may want to use 3 out of 5 facets and so forth.

    Therefore if I am going to use two out of five facets in the next row, I wouldn't want URL that will follow to show three trailing slashes.
    I hope it makes sense.
    Thank you again!

  4. #4
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.83 (24031120))
    Posts
    8,743

    Re: How to match CONCATENATE, (multiple) IFs and LOWER for a descriptive URL?

    with an IF ( )

    you need to tell excel what the test is to use 2,3 or 4 elements
    and then write the code for those ifs

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Concatenate Multiple Vlookup/Index/Match Results with Commas
    By mkay13 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-29-2015, 02:04 PM
  2. Match or fix to nearest/closest lower value.
    By nihar sharma in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-16-2015, 11:59 AM
  3. Vlookup or Index Match multiple criteria with Concatenate
    By mpost54 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-04-2015, 05:22 PM
  4. [SOLVED] Concatenate works, but I need to omit descriptive text when cell is empty
    By michigandrea in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-02-2014, 08:32 AM
  5. [SOLVED] Index/Match Array with multiple results concatenate in one cell
    By samiesosa in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-15-2013, 01:34 PM
  6. Take Lower Match Value in a Mode Formula
    By cubysfan in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-08-2011, 12:53 PM
  7. match lower and upper case
    By SarahPintal in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-12-2010, 02:24 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1