+ Reply to Thread
Results 1 to 4 of 4

Want to find a Value from a Column using Row Number

  1. #1
    Registered User
    Join Date
    01-27-2022
    Location
    UK
    MS-Off Ver
    2021
    Posts
    35

    Want to find a Value from a Column using Row Number

    Hi,

    I have values in column J.
    in cell H8, i have a row number 11 which is variable.

    In cell G11, i want value of row no.11 of column J. as value in cell H8 is 11.


    (a sample file is attached for further clarification)

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

    Re: Want to find a Value from a Column using Row Number

    Try

    =INDIRECT("J" &H8)
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

  3. #3
    Registered User
    Join Date
    01-27-2022
    Location
    UK
    MS-Off Ver
    2021
    Posts
    35

    Re: Want to find a Value from a Column using Row Number

    Hi @JohnTopley

    Thanks a lot.

    It worked perfectly

  4. #4
    Valued Forum Contributor
    Join Date
    12-09-2014
    Location
    Trakai, Lithuania
    MS-Off Ver
    2010
    Posts
    705

    Re: Want to find a Value from a Column using Row Number

    Formula
    Formula: copy to clipboard
    Please Login or Register  to view this content.

+ 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] Excel: find next smaller number in a column with duplicates for a given number value
    By Hmerman in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-08-2020, 08:14 AM
  2. Replies: 5
    Last Post: 02-13-2014, 05:37 PM
  3. Replies: 1
    Last Post: 06-10-2013, 07:08 PM
  4. Find highest revision number in one column of a item number in another column
    By Tasiast in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-01-2013, 01:03 PM
  5. Replies: 4
    Last Post: 11-13-2012, 02:16 PM
  6. [SOLVED] find number of times a letter or a number appears in a column
    By dcoates in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-17-2012, 02:47 PM
  7. Replies: 7
    Last Post: 12-18-2008, 07:34 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