+ Reply to Thread
Results 1 to 9 of 9

VLOOKUP to retrieve specific sub cell value

  1. #1
    Registered User
    Join Date
    06-29-2021
    Location
    India
    MS-Off Ver
    2013
    Posts
    8

    Post VLOOKUP to retrieve specific sub cell value

    Can you please help me to find out the "price after revert" in this price column . Please look into the attachments for more details.



    Thanks
    Attached Files Attached Files
    Last edited by Learnerhere; 06-29-2021 at 03:31 PM.

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    Waterlooville,England
    MS-Off Ver
    Office 2010
    Posts
    22,827

    Re: VLOOKUP to retrieve specific sub cell value

    reformat your data as attached then a simple vlookup is what you want

    and avoid merged cells!

    Excel works on simple principle of ONE row per item; avoid "complex" formats as they only make life more complicated.

    Keep it simple!
    Attached Files Attached Files
    Last edited by JohnTopley; 06-29-2021 at 03:06 PM.

  3. #3
    Valued Forum Contributor
    Join Date
    05-15-2017
    Location
    US
    MS-Off Ver
    365
    Posts
    862

    Re: VLOOKUP to retrieve specific sub cell value

    Or you can use INDEX/MATCH and get the price you want like this and not have to change your layout/structure.
    Now this will give you the price you want as long as the price you want is 2 rows below the list price.

    Please Login or Register  to view this content.
    Put that in B2 on your Result tab then copy down.
    If you find the suggestion or solution helpful, please consider adding reputation to the post.

  4. #4
    Registered User
    Join Date
    06-29-2021
    Location
    India
    MS-Off Ver
    2013
    Posts
    8

    Re: VLOOKUP to retrieve specific sub cell value

    Thanks a lot brother. It really helped me.. I am very much thankful to you

  5. #5
    Registered User
    Join Date
    06-29-2021
    Location
    India
    MS-Off Ver
    2013
    Posts
    8

    Re: VLOOKUP to retrieve specific sub cell value

    Thanks brother, But i cant do the data arrange for lot of data and it may change the outlet of the sheet also.. Thanks again Brother

  6. #6
    Forum Expert
    Join Date
    05-05-2015
    Location
    Waterlooville,England
    MS-Off Ver
    Office 2010
    Posts
    22,827

    Re: VLOOKUP to retrieve specific sub cell value

    As you appear to be relative new to Excel I do urge you to reconsider your decision not to reformat. I see so many people resorting to complex formulae simply because of the way data is organised.

    The format has the advantage of simplicity and i would argue it is much more readable. The "pain" now will pay dividends later.

  7. #7
    Forum Expert wk9128's Avatar
    Join Date
    08-15-2020
    Location
    Malaysia
    MS-Off Ver
    365 & WPS(2022)
    Posts
    2,036

    Re: VLOOKUP to retrieve specific sub cell value

    Worksheet name : Result

    Cell B2 formula , Drag down

    HTML Code: 
    =INDEX(Product!$E$5:$E$19,MATCH(A2,Product!$A$5:$A$19,)+MATCH("Price after revert",Product!$D$5:$D$19,)-1)

  8. #8
    Registered User
    Join Date
    06-29-2021
    Location
    India
    MS-Off Ver
    2013
    Posts
    8

    Re: VLOOKUP to retrieve specific sub cell value

    Thanks Brother, It was helpful

  9. #9
    Forum Expert wk9128's Avatar
    Join Date
    08-15-2020
    Location
    Malaysia
    MS-Off Ver
    365 & WPS(2022)
    Posts
    2,036

    Re: VLOOKUP to retrieve specific sub cell value

    You're Welcome. Thank You for the feedback

+ 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. Using Vlookup to retrieve a cell containing multiple lines.
    By RuthEllen63 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-30-2020, 02:53 PM
  2. Replies: 2
    Last Post: 07-14-2020, 11:20 AM
  3. Retrieve specific pivot cell's data source via VBA
    By DouglasWilliamSMith in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-16-2019, 12:08 PM
  4. Use VLOOKUP to retrieve a value based on a word within a cell
    By Nelzon in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-09-2016, 08:11 PM
  5. Replies: 1
    Last Post: 12-10-2013, 01:44 PM
  6. [SOLVED] Formula to retrieve mutiple values less than value in specific cell, but in date order.
    By rocksan in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-18-2012, 11:33 PM
  7. Vlookup retrieve cell data and conditional formatting
    By Philly123 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-25-2012, 10:50 PM

Tags for this Thread

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