+ Reply to Thread
Results 1 to 3 of 3

filling a table using a database while finding the nearest value for two parameter

  1. #1
    Registered User
    Join Date
    07-06-2012
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    2

    Post filling a table using a database while finding the nearest value for two parameter

    Hi,

    First I'm new to this forum and I apologize if this message is in the wrong category.
    I couldn't find a response browsing your site.

    My problem is:

    I have a table to fill using the data of another one.
    Let's say I have a huge swimming pool (x,y) and I test the Ph in various point.

    Table #1 is the database (x;y;ph)
    Table #2 is the swimming pool (x,y)

    Here's my questions:
    - I want value of every point of table#1 transcript in table#2 for the exact x and y.
    - for the case where there is no data, it need to display the closest value in the the database, but for the two parameter x and y.

    I found a formula for my first question that worked :
    =SUMPRODUCT(($L$21:$L$25=D$9)*($M$21:$M$25=$C10)*($N$21:$N$25))
    But it display 0 when the x and y are not the same from table#1, and i really need excel to calculate the closest value.

    Any help would be very appreciated.

    Thanks
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    03-20-2011
    Location
    UK
    MS-Off Ver
    Excel 2007/10/16
    Posts
    840

    Re: filling a table using a database while finding the nearest value for two parameter

    Hi

    Will this help!!

    Have a look
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    07-06-2012
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: filling a table using a database while finding the nearest value for two parameter

    Hi micope21,

    Actually it's in the other way. I use table#2 to fill table#1.
    So I tried to apply your formula in the other way. But it only displays #REF
    How can I fix this?

    Thanks
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1