Results 1 to 4 of 4

Thread: Get value form a table

  1. #1
    Neophyte Ignatios's Avatar
    Join Date
    Jan 2021
    Posts
    1
    Articles
    0
    Excel Version
    365

    Get value form a table



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

    Hi gents,
    I am trying to find the correct syntax/formula for getting a value from a table based on a value from another cell in an other sheet.
    Eg this is the table



    In my other sheet I have
    61427 but a few cells lower i want to get the second value from the tabel "6152"
    so in cel A1 I have =A10 and I want to get the below value from A11

    hope that makes sence

  2. #2
    Admin Alumnus Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,747
    Articles
    0
    Excel Version
    2010 on Xubuntu
    Hi
    please post a sample sheet ( no pics please) Thx
    Thank you Ken for this secure forum.

  3. #3
    Seeker RET's Avatar
    Join Date
    Nov 2020
    Location
    Spain
    Posts
    13
    Articles
    0
    Excel Version
    2019
    I read it twice trying to understand, but no way. Please, explain it better.

  4. #4
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,893
    Articles
    0
    Excel Version
    365
    Quote Originally Posted by Ignatios View Post
    hope that makes sence
    little sence

Posting Permissions

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