Results 1 to 2 of 2

Thread: Lookup with dynamic Row and Column

  1. #1
    Neophyte stilwellj1983's Avatar
    Join Date
    Sep 2019
    Posts
    1
    Articles
    0
    Excel Version
    Office 365

    Lookup with dynamic Row and Column



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I have a document that I would like to lookup the far left column but both my row and column are floating. see example below. In the formula I would know 1 - 6 and the name, I want to return the A - F.


    1 2 3 4 5 6
    A Steve John Joe Mike Gray Hanna
    B John Joe Mike Gray Hanna Steve
    C Joe Mike Gray Hanna Steve John
    D Mike Gray Hanna Steve John Joe
    E Gray Hanna Steve John Joe Mike
    F Hanna Steve John Joe Mike Gray

  2. #2
    Conjurer alansidman's Avatar
    Join Date
    Oct 2018
    Location
    Steamboat Springs
    Posts
    193
    Articles
    0
    Excel Version
    2019
    I am not understanding your needs. Please explain in simple terms what you are trying to do. Provide an example in your step by step narrative with your expected results. Your current request is to vague to determine your requirements.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •