Consulting

Results 1 to 4 of 4

Thread: Lookup question

  1. 03-29-2010, 07:58 AM #1
    Blackie50
    Blackie50 is offline
    VBAX Regular
    Joined
    Nov 2009
    Posts
    83
    Location

    Lookup question

    Hi,

    Not a great user of lookup tables and was wondering if the following is possible (or by other means?).

    Based on the value of Cell1 & Cell2 the value of Cell3 is the lookup value. Cell1 & 2 would be dropdown lists.

    example Fund 1 (cell1) Date (cell2) that days price (cell3)

    thanks
    Jon
    Reply With Quote Reply With Quote
  2. 03-29-2010, 08:13 AM #2
    mbarron
    mbarron is offline
    VBAX Mentor
    Joined
    Jun 2004
    Posts
    363
    Location
    Something like the attached maybe? It uses dynamic ranges for the dates and stocks drop downs and then the Index and Match functions to acquire the Price.
    Reply With Quote Reply With Quote
  3. 03-29-2010, 08:23 AM #3
    Bob Phillips
    Bob Phillips is offline
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,453
    Location
    This array formula demonstrates a technique

    HTML Code:
    =INDEX(K2:K200,MATCH(1,(I2:I200=A20)*(J2:J200=B20),0))
    Last edited by Aussiebear; 04-20-2023 at 05:36 AM. Reason: Added code tags
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber
    Reply With Quote Reply With Quote
  4. 03-29-2010, 02:24 PM #4
    Blackie50
    Blackie50 is offline
    VBAX Regular
    Joined
    Nov 2009
    Posts
    83
    Location
    Very Good guys - just the ticket

    thanks
    Reply With Quote Reply With Quote
« Previous Thread | Next 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
  •  

Forum Rules