+ Reply to Thread
Results 1 to 6 of 6

Lookup based on row and column number

  1. #1
    Registered User
    Join Date
    06-24-2020
    Location
    Jakarta
    MS-Off Ver
    MS 365
    Posts
    74

    Lookup based on row and column number

    Hi ALL,

    I have a problem to do look up on 3 variables based on row and column no. from dynamic pivotable.
    The question is on the file.
    Could you pls help to check it for me? Thanks
    Attached Files Attached Files
    Last edited by halimgunawan; 10-02-2024 at 09:26 AM.

  2. #2
    Forum Expert
    Join Date
    04-14-2009
    Location
    Taiwan
    MS-Off Ver
    Excel 2016,2019,O365
    Posts
    2,465

    Re: Lookup based on row and column number

    Perhaps,

    C12
    Please Login or Register  to view this content.
    One example for pivottable.
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    06-24-2020
    Location
    Jakarta
    MS-Off Ver
    MS 365
    Posts
    74

    Re: Lookup based on row and column number

    sorry, I have revised the example file.. could you pls help to check it? Thanks alot

  4. #4
    Forum Expert
    Join Date
    04-14-2009
    Location
    Taiwan
    MS-Off Ver
    Excel 2016,2019,O365
    Posts
    2,465

    Re: Lookup based on row and column number

    Perhaps,

    J8
    =INDEX(B6:G11,J6,J7)
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    06-24-2020
    Location
    Jakarta
    MS-Off Ver
    MS 365
    Posts
    74

    Re: Lookup based on row and column number

    if we update the pivotable, and it has different range size?
    also the pivot has 3 variables..

  6. #6
    Forum Expert
    Join Date
    04-14-2009
    Location
    Taiwan
    MS-Off Ver
    Excel 2016,2019,O365
    Posts
    2,465

    Re: Lookup based on row and column number

    Maybe, you can change B6:G11 to B6:Z100 for large dataset.

    If not, I can not offer more solution.

+ 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. Lookup Formula Based on Header Title Not Column Number
    By JayR22 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-18-2023, 06:23 AM
  2. [SOLVED] Lookup Row Number based on known Column Number
    By Adb123 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 02-13-2020, 07:56 AM
  3. [SOLVED] Using MATCH to find row number based on a two-column lookup.
    By systemlordanubis in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-17-2016, 08:34 AM
  4. Replies: 3
    Last Post: 05-08-2015, 12:05 PM
  5. Lookup Column number in a table based on a cell value
    By electricmice in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-22-2012, 01:08 AM
  6. Using text box input to lookup number and replace based on user input into new column
    By harl3y412 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-28-2011, 03:15 PM
  7. Lookup largest number in a column treating negative number as postive number
    By xWiZardx in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-17-2010, 08:09 AM

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