Results 1 to 4 of 4

Thread: If/then function - Help!
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Jun 2018
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default If/then function - Help!

    Hi all,

    I need some help figuring out a formula to read two columns and if they're both filled, then to provide the data.

    Example:

    I have one worksheet that serves as my data dump. Column C is a list of customers and column J and K are the brands of computers and smartphones they own. Sometimes column J and K will be blank.

    In a second worksheet I'm trying to write a formula that will read the data dump worksheet, provide the customer name, the brand of smartphone and/or computer only IF J and/or K are filled out.

  2. #2
    MrExcel MVP
    Join Date
    Aug 2010
    Location
    Rio de Janeiro BRAZIL
    Posts
    16,267
    Post Thanks / Like
    Mentioned
    19 Post(s)
    Tagged
    8 Thread(s)

    Default Re: If/then function - Help!

    Assuming the data are in Sheet1 and in the other sheet the customer names are in column A beginning in A2, try

    Formula in B2 copied across to C2 and down
    =IFERROR(INDEX(Sheet1!J:J,MATCH($A2,Sheet1!$C:$C,0))&"","Not found")

    Hope this helps

    M.

  3. #3
    New Member
    Join Date
    Jun 2018
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: If/then function - Help!

    You're my hero! Thanks a million!

  4. #4
    MrExcel MVP
    Join Date
    Aug 2010
    Location
    Rio de Janeiro BRAZIL
    Posts
    16,267
    Post Thanks / Like
    Mentioned
    19 Post(s)
    Tagged
    8 Thread(s)

    Default Re: If/then function - Help!

    You are welcome. Thanks for the feedback.

    M.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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