Finding the closest value in a table

[BCMCF]

I need some assistance, please

I am working on a DB for maintenance of medical records for use by medical mission groups in Central America. As a child’s information is entered into the DB, I want to be able to display his growth progress percentile numerically instead of graphically as found on a standard CDC.gov weight vs height growth chart. The graph are nonlinear so I just can't use an expression.



I have the data for percentiles based on weight and height but I need to be able to find the CLOSEST value on this table to the child’s observed values of height and weight.



How do I find the value on a table which is closest to a specified number?


Thanks in advance

BCMCF

 

[mahenkj2]

I do not think it would just be calculating the difference otherwise you would not have asked here. Can you post with some sample data what you want to extract?

 

[jdraw]

As mahenkj2 asked, can you provide some sample data to show what exactly you are dealing with.
If you could show some representative data, and the calculation result you expect, it would help.

 

[BCMCF]

Thank you for your reply to my question.


The growth charts display the statistical percentile based on a child’s height and weight. The Table, includes the exact weigh of the child at each included percentile, for each included height.


For example, this fragment of the table:

54.5​

3.770975​

3.846658​

3.969008​

4.190816​

4.466563​

4.779003​

5.097891​

5.308799​

5.454877​

55.5​

4.010448​

4.087392​

4.211993​

4.438598​

4.721731​

5.04466​

5.376818​

5.598043​

5.752027​

56.5​

4.250088​

4.328585​

4.45586​

4.687883​

4.978904​

5.312536​

5.657821​

5.889087​

6.050711​

Where the Columns are height in cm, and various percentiles, 3rd, 5th 10th..... 90th, 95th 97th.
The values in the body (rows) of the table are the wt in Kg, out to 6 decimal places, for each height and percentile.
Given an observed weight and height, I need to be able to choose the closest weight value on the table for the specified height. I can then know the percentile.
Not too precise, but acceptable for our purposes.


Thanks

 

[BCMCF]

Well,that didn't end up like I wanted it to...........



.

 

[BCMCF]

Thank you for your reply to my question.
The growth charts display the statistical percentile based on a child’s height and weight. The Table, includes the exact weigh of the child at each included percentile, for each included height.
For example, this fragment of the table:

54.5 3.770975 3.846658 3.969008 4.190816 4.466563 4.779003 5.097891 5.308799 5.454877
55.5 4.010448 4.087392 4.221993 4.438598 4.721731 5.044660 5.376818 5.598043 5.752027
56.5 4.230088 4.328585 4.455860 4.687883 4.978904 5.312536 5.657821 5889087 6.050711

Where the Columns are height in cm, and various percentiles, 3rd, 5th 10th..... 90th, 95th 97th.
The values in the body (rows) of the table are the wt in Kg, out to 6 decimal places, for each height and percentile.
Given an observed weight and height, I need to be able to choose the closest weight value on the table for the specified height. I can then know the percentile.
Not too precise, but acceptable for our purposes.

Sorry for the confusing previous posts. I hope this is clearer.

BCMCF

 

[jdraw]

????? How about putting some labels on something?