+ Reply to Thread
Results 1 to 6 of 6

Index match method or any other method to get value of cell with different sequential row

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

    Post Index match method or any other method to get value of cell with different sequential row

    Hi,

    Is it possible to get get value of cell with different sequential row , Please check with attachment for more details
    Attached Files Attached Files

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

    Re: Index match method or any other method to get value of cell with different sequential

    Can you clarify with some "expected" results on the 2 asks you have in the file?
    If you find the suggestion or solution helpful, please consider adding reputation to the post.

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

    Re: Index match method or any other method to get value of cell with different sequential

    For question 1 and 2 the expected answer is "final price" column is fully filled with MRP price like below

    Final Price
    45
    45
    45
    45
    200
    200
    200
    200

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

    Re: Index match method or any other method to get value of cell with different sequential

    To be more precise based on cell reference like below


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

    Re: Index match method or any other method to get value of cell with different sequential

    Here is something that works, BUT because of the merged cells, not sure how maintainable it will be..
    Attached Files Attached Files

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

    Re: Index match method or any other method to get value of cell with different sequential

    Thanks brother, i can understand it partially

+ 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. Correcting index and count method to get the last numeric cell value
    By plumberef in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-08-2020, 08:12 AM
  2. Correcting index and count method to get the last numeric cell value
    By plumberef in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-08-2020, 07:32 AM
  3. powery query join method instead of index match
    By JEAN1972 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-01-2018, 02:33 PM
  4. [SOLVED] Sequential Method to Set Focusing of Text Boxes
    By Rajeshkumar R in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-22-2017, 01:08 AM
  5. [SOLVED] Best Method... Range.Find or Index.Match?
    By Quint6778 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-28-2017, 10:37 AM
  6. [SOLVED] Which method is faster, VLOOKUP or MATCH & INDEX?
    By Jimmyjazz in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-20-2013, 04:35 PM
  7. [SOLVED] Summing multiple hits using match, offset and index method
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-08-2006, 05:40 AM

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