1. OzGrid
    1. Excel/VBA Consultancy
    2. OzGrid Store
    3. Training
    4. Freebies
  2. Forum
    1. Unresolved Threads
    2. Forum Rules
  3. Dashboard
  4. Articles
  5. Members
    1. Recent Activities
    2. Users Online
    3. Team
    4. Search Members
  • Login or register

    Login

    Lost Password

    Register

    Don’t have an account yet? Register yourself now and be a part of our community!

    Register Yourself
  • Search
This Thread
  • Everywhere
  • This Thread
  • This Forum
  • Articles
  • Pages
  • Forum
  • More Options
  1. OzGrid Free Excel/VBA Help Forum
  2. HELP FORUMS
  3. Excel General

Tables

  • RadMan
  • Jan 29th 2003
  • RadMan
    Beginner
    Points
    16
    Trophies
    1
    Posts
    4
    • Jan 29th 2003
    • #1

    I have a rather unusual problem I hope you can help me with. I am writing an excel calculation sheet that needs to refer to a table. The reference from the table is not in the coventional sense. Instead of knowing the first column values and the first row values, I know the first column values and the value located in the row of the known 1st column value. I need to then get the first row value located in the column of the table value. VLOOKUP, and HLOOKUP don't help me. Is there a formula or an excel function that can help me??

    • Report Content
  • PJ KARAFFA
    Beginner
    Points
    60
    Trophies
    1
    Posts
    20
    • Jan 29th 2003
    • #2

    Is it possible to post a little of your data so that we can getter a better understanding of what you are actually trying to do!!

    • Report Content
  • RadMan
    Beginner
    Points
    16
    Trophies
    1
    Posts
    4
    • Jan 29th 2003
    • #3

    I attached the table. let's say I know the dose/fraction is 250, and I know the table value is 56. I need excel to look up 12 for the number of fractions.

    • Report Content
  • s_u_resh
    Student
    Points
    350
    Posts
    98
    • Jan 30th 2003
    • #4
    Quote

    Originally posted by RadMan
    I attached the table. let's say I know the dose/fraction is 250, and I know the table value is 56. I need excel to look up 12 for the number of fractions.


    DID NOT UNDERSTAND WHAT YOU ARE TRYING TO SAY , EXPLAN PLS.

    • Report Content
  • PJ KARAFFA
    Beginner
    Points
    60
    Trophies
    1
    Posts
    20
    • Jan 30th 2003
    • #5

    Here is one way to answer your question. Although it may not be exactly what you want it is very close. All the credit for this one goes to Aladin Akyurek.:D

    • Report Content
  • s_u_resh
    Student
    Points
    350
    Posts
    98
    • Jan 30th 2003
    • #6

    I agree for above example , it should work.


    Thanks to PJ KARAFFA



    Regards
    S.Suresh

    • Report Content
  • PJ KARAFFA
    Beginner
    Points
    60
    Trophies
    1
    Posts
    20
    • Feb 19th 2003
    • #7

    RadMan,


    It took some time but I think this is the answer that you are looking for Compliments of Aladin Akyurek!!:thumbup:

    • Report Content

Share

  • Facebook
  • Twitter
  • Reddit
  • WhatsApp
  • LinkedIn
  1. Privacy Policy
  2. Contact
© OzGrid Business Services. All Rights reserved.
  1. Navigation
  2. OzGrid
    1. Excel/VBA Consultancy
    2. OzGrid Store
    3. Training
    4. Freebies
  3. Forum
    1. Unresolved Threads
    2. Forum Rules
  4. Dashboard
  5. Articles
  6. Members
    1. Recent Activities
    2. Users Online
    3. Team
    4. Search Members
  7. Search
  8. Options
    1. (placeholder)
  9. Current Location
  10. OzGrid Free Excel/VBA Help Forum
  11. HELP FORUMS
  12. Excel General
  1. User Menu
  2. Login
  3. Registration
This site uses cookies. By continuing to browse this site, you are agreeing to our use of cookies. More Details Close