Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Feb 2001
    Posts
    60
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Lookup value in table (97/SR1)

    Hello,

    I have a table of XY values. For a value of X entered that is the exact number from the table, I used the vlookup() function to get the Y value. However, If I would enter a value of X that is not located in the table but is between an upper and lower values shown in the table, than I would like to average the corresponding Y values. Attached is a spreadsheet that I am working on. I am trying to figure out the equation that I should use in this case.

    Thanks,
    Hanan.

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Lookup value in table (97/SR1)

    Try this in B14.
    =TREND(OFFSET($A$2,MATCH(B13,$A$2:$A$10)-1,1,2,1),OFFSET($A$2,MATCH(B13,$A$2:$A$10)-1,0,2,1),B13)

    It won't be the average. It will be an interpolation of the value (which I think is better)

    Steve

Posting Permissions

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