+ Reply to Thread
Results 1 to 6 of 6

fetch value to adjacent left next cell

  1. #1
    Registered User
    Join Date
    09-13-2015
    Location
    Bengaluru, KA, India
    MS-Off Ver
    Home & Student 2021
    Posts
    36

    Question fetch value to adjacent left next cell

    Sorry if the title is misleading.
    Here is what I intend to convey.



    If It is not starting with "29" it should return as 0.Screenshot 2022-03-05 164033.png
    Attached Files Attached Files
    Last edited by avinash21; 03-05-2022 at 07:11 AM.

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: fetch value to adjacent left next cell

    Quote Originally Posted by avinash21 View Post
    Sorry if the title is misleading.
    If you already know the title is misleading, perhaps you should update it to reflect what you really intend.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,007

    Re: fetch value to adjacent left next cell

    in A14

    =IFERROR(INDEX($A$3:$A$9,AGGREGATE(15,6,ROW($A$1:$A$100)/($A$3:$A$9<>""),ROWS($1:1))),"")

    in B14

    =IF(ISNUMBER(INDEX($B$3:$B$9,MATCH($A14,$A$3:$A$10,0)+1)),"",INDEX($B$3:$B$9,MATCH($A14,$A$3:$A$10,0)+1))

    in C14

    =INDEX($C$3:$C$10,MATCH(A14,$A$3:$A$10,0))
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

  4. #4
    Registered User
    Join Date
    09-13-2015
    Location
    Bengaluru, KA, India
    MS-Off Ver
    Home & Student 2021
    Posts
    36

    Re: fetch value to adjacent left next cell

    Thank you sir JohnTopley. I'm grateful to you.

    Well, I have started to be familiar about Excel from Mike Garvin Excelisfun YouTube Channel

    Sir, one day I would like to learn at least a fraction of what you and Glenn Kennedy know about excel any tips for a novice like me?

    Although I'm able apply INDEX, Match and VLOOKUP in isolation, clubbing them & applying seems like a daunting task to me.

    Also I didn't understand why have you applied Index formula twice in B14.
    Last edited by avinash21; 03-05-2022 at 12:29 PM.

  5. #5
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,007

    Re: fetch value to adjacent left next cell

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    =IF(ISNUMBER(INDEX($B$3:$B$9,MATCH($A14,$A$3:$A$10,0)+1)),"",INDEX($B$3:$B$9,MATCH($A14,$A$3:$A$10,0)+1))[/FORMULA]

    The highlighted part checks if there is a NUMBER (Time) only i.e the TEXT associated with Bill No. in column A is absent: if TRUE, leave cell blank otherwise add the TEXT.

  6. #6
    Registered User
    Join Date
    09-13-2015
    Location
    Bengaluru, KA, India
    MS-Off Ver
    Home & Student 2021
    Posts
    36

    Re: fetch value to adjacent left next cell

    Thank you Mr JohnTopley.

+ 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] Format Cell if it has been a week since Date in Left Adjacent Cell
    By MatthewTaylor in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-27-2020, 11:38 AM
  2. [SOLVED] adjacent cell return value? trying to fetch data from another worksheet
    By L.Storm in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-25-2019, 08:07 AM
  3. [SOLVED] Finding Max value in column and returning value from left adjacent cell
    By Haidar123 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-17-2019, 03:33 AM
  4. Copying data from adjacent cell to blank cell (left side)
    By raghunaik in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-14-2015, 08:20 AM
  5. [SOLVED] How to read the cell value to left of max in adjacent column
    By Freddybaby in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-14-2014, 04:19 PM
  6. Replies: 5
    Last Post: 08-19-2013, 03:13 PM
  7. [SOLVED] Need hyperlink in cell qnly if adjacent cell to left is blank...
    By egildone in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-27-2012, 03:52 PM

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