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

Lookup

  • texasalynn
  • Jan 27th 2003
  • texasalynn
    Beginner
    Points
    121
    Trophies
    1
    Posts
    33
    • Jan 27th 2003
    • #1

    This seems like a simple vlookup but it's not. I need a way to take information from a separate workbook where it needs to find the intersection of the column and row.


    So I need to lookup from the current workbook cell A3=1-21-2003 and cell C3=Tray2 so the result will return "1" from the separate workbook.
    Here is an example of the pivot table that I need to lookup to find the intersection



    A B C D
    Date: Tray1 Tray2 Tray3
    1-21-2003 1 1 1
    1-22-2003 2 1 2
    1-23-2003 3 2 3


    HELP me please!


    Thanks,
    texasalynn

    ------------------------
    "We don't see things as they are.
    We see them as we are." -Anais Nin

    • Report Content
  • bumble
    Beginner
    Points
    30
    Trophies
    1
    Posts
    10
    • Jan 27th 2003
    • #2

    If you add a row under your date: Tray column and put in the column numbers eg.
    Tray1 Tray2 Tray3
    2 3 4


    You could get away with the following formula:-
    =VLOOKUP(A3,Sheet2!$A$1:$D$5,HLOOKUP(C3,Sheet2!$B$1:$D$2,2,FALSE))


    Cheers,

    • Report Content
  • AJW
    Student
    Points
    453
    Trophies
    1
    Posts
    137
    • Jan 28th 2003
    • #3

    Try the lookup's in the attached from Excel Logic web site.

    • Report Content
  • yjoshi
    Student
    Points
    881
    Trophies
    1
    Posts
    285
    • Mar 11th 2003
    • #4

    Hi AJW,


    This excel sheet is reallv too good.


    Which is the site you are mentioning here?


    Looks to be interesting.

    Thanks: ~Yogendra

    • Report Content
  • Richie(UK)
    OzMVP
    Likes Received
    1
    Points
    8,272
    Trophies
    1
    Posts
    2,739
    • Mar 11th 2003
    • #5

    Hi yjoshi


    The site mentioned is here:


    http://www.xl-logic.com/menu.html


    (Pretty good isn't it?) :thumbup:

    Cross-poster? Read this: Cross-posters
    Struggling to use tags (including Code tags)? : Forum tags

    • Report Content
  • yjoshi
    Student
    Points
    881
    Trophies
    1
    Posts
    285
    • Mar 11th 2003
    • #6

    Thanx a lot.

    Thanks: ~Yogendra

    • 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