Results 1 to 4 of 4

Thread: Get value form a table

  1. 2021-01-16, 10:02 PM #1
    Ignatios
    Ignatios is offline
    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
    Reply With Quote Reply With Quote
  2. 2021-01-17, 08:51 AM #2
    Pecoflyer
    Pecoflyer is offline
    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.
    Reply With Quote Reply With Quote
  3. 2021-01-17, 01:19 PM #3
    RET
    RET is offline
    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.
    Reply With Quote Reply With Quote
  4. 2021-01-17, 03:12 PM #4
    p45cal
    p45cal is offline
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,890
    Articles
    0
    Excel Version
    365
    Quote Originally Posted by Ignatios View Post
    hope that makes sence
    little sence
    Reply With Quote Reply With Quote
« Previous Thread | Next 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
  •  

Forum Rules

Gravatar by 1e2.it