Page 1 of 2 12 LastLast
Results 1 to 10 of 19

Thread: Trouble Understanding Which Formula is needed

  1. #1
    Board Regular
    Join Date
    Oct 2015
    Posts
    106
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Trouble Understanding Which Formula is needed

    Hi, I'm having a major headache right now and can't think straight on this. I've tried a couple of solutions, but still can't wrap my head around what is needed.

    Basically, I am trying to return a value from the first tab contingent on whether or not the value underneath cell A1 on that tab is blank or not. It's hard to describe, but I put an explainer in the cell adjacent to where the formula would be.

    https://drive.google.com/open?id=1_6...z7NaA2z6DAePNZ

  2. #2
    Board Regular sandy666's Avatar
    Join Date
    Oct 2015
    Posts
    2,797
    Post Thanks / Like
    Mentioned
    31 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Trouble Understanding Which Formula is needed

    your file is NOT shared
    I know you know but I forgot my Crystal Ball and don't know what you know



    In the first post, show the type of machine (PC / Mac) and the Office version you are working on
    impossible things we do on the spot. for miracles you need to wait for a while

  3. #3
    Board Regular
    Join Date
    Oct 2015
    Posts
    106
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Trouble Understanding Which Formula is needed


  4. #4
    Board Regular
    Join Date
    Oct 2015
    Posts
    106
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Trouble Understanding Which Formula is needed

    Let me know if it makes sense or not.

  5. #5
    Board Regular
    Join Date
    Feb 2018
    Location
    Oz
    Posts
    119
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Trouble Understanding Which Formula is needed

    Sadly, not. The important detail has been clipped from the second tab.
    Be warned - I'm an Excel enthusiast, not an expert.

  6. #6
    Board Regular
    Join Date
    Oct 2015
    Posts
    106
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Trouble Understanding Which Formula is needed

    Here's what it says: <<< Here instead I need a formula that would look for the A1 Value in the DATABASE sheet A Column and return the C2 value ONLY IF the cell below A1 (DATABASE Sheet) is blank! If not blank return "" Nothing.

  7. #7
    Board Regular
    Join Date
    Feb 2005
    Location
    Melbourne (Australia)
    Posts
    578
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Trouble Understanding Which Formula is needed

    How about

    =IF(OFFSET(DATABASE!A1,1,0)="",DATABASE!C2,"")

    Sorry - I can't use Google Drive from this computer, so I'm working off the written description only.


    ETA: Unless you mean that you need to find a text string A1, not cell A1.... In which case

    =IF(OFFSET(DATABASE!A1,MATCH("A1", DATABASE!A:A,0)+1,0)="",DATABASE!C2,"")
    Last edited by Glove_Man; Aug 9th, 2019 at 03:04 AM.
    "I'm almost sure I'm not mad..." - Stoppard

  8. #8
    MrExcel MVP
    Moderator
    Peter_SSs's Avatar
    Join Date
    May 2005
    Location
    Macksville, Australia
    Posts
    40,968
    Post Thanks / Like
    Mentioned
    90 Post(s)
    Tagged
    21 Thread(s)

    Default Re: Trouble Understanding Which Formula is needed

    Quote Originally Posted by gravanoc View Post
    Here's what it says: <<< Here instead I need a formula that would look for the A1 Value in the DATABASE sheet A Column and return the C2 value ONLY IF the cell below A1 (DATABASE Sheet) is blank! If not blank return "" Nothing.
    From what I can see, none of your examples demonstrate the red part. Could you give example(s) where that would apply or point me to where it is demonstrated with the given sample data?
    Hope this helps, good luck.
    Peter
    Excel 365 - Windows 10
    - Want to help your helpers by posting a small, copyable, screen shot directly in your post? Look here
    - If posting vba code, please use Code Tags - like this [code]Paste code here[/code] - or use the # key in the Reply window
    - Read: Forum Rules, Forum Use Guidelines, & FAQ

  9. #9
    Board Regular
    Join Date
    Oct 2015
    Posts
    106
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Trouble Understanding Which Formula is needed

    Hi, I updated it so that it hopefully makes more sense now.

    I have to create a database to upload products to a web marketplace.

    They supplied me a blank spreadsheet where, beside many other fields like description, size etc, they also need the image file name listed in columns NEXT to each other (WEB tab in my sample sheet).

    I have all of these data in another spreadsheet but when a product has multiple images, they are not listed in columns next to each other but in below rows and the SKU# is NOT repeated but left blank (see DATABASE tab in my sample sheet).
    I have no problem to retrieve the first image with a simple Vlookup (Column "C" of the WEB sheet) the problem is instead to retrieve and place the additional images…

    In my head I have this formula:
    Example for SKU# BS02/6-BSP (on the WEB sheet row 3)

    On C3 the Current formula =VLOOKUP(A3,DATABASE!A:C,3,FALSE) works perfect to retrieve the main/first image
    On D3 I need a formula that will look for the value on A3 cell on the A Column of the DATABASE sheet and once located if the cell BELOW is blank then retrieve the value on the C column otherwise ""return blank.
    Same on the E3 column to retrieve the third image if available…

    https://drive.google.com/file/d/1OKZ...ew?usp=sharing

  10. #10
    Board Regular
    Join Date
    Oct 2015
    Posts
    106
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Is this solvable with built-in functions as is?

    I have to create a database to upload products to a web marketplace.

    They supplied me a blank spreadsheet where, beside many other fields like description, size etc, they also need the image file name listed in columns NEXT to each other (WEB tab in my sample sheet).

    I have all of these data in another spreadsheet but when a product has multiple images, they are not listed in columns next to each other but in below rows and the SKU# is NOT repeated but left blank (see DATABASE tab in my sample sheet).
    I have no problem to retrieve the first image with a simple Vlookup (Column "C" of the WEB sheet) the problem is instead to retrieve and place the additional images…

    In my head I have this formula:
    Example for SKU# BS02/6-BSP (on the WEB sheet row 3)

    On C3 the Current formula =VLOOKUP(A3,DATABASE!A:C,3,FALSE) works perfect to retrieve the main/first image
    On D3 I need a formula that will look for the value on A3 cell on the A Column of the DATABASE sheet and once located if the cell BELOW is blank then retrieve the value on the C column otherwise ""return blank.
    Same on the E3 column to retrieve the third image if available…

    https://drive.google.com/open?id=1OK...ho3F5skAKC3lMU

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
  •