Hi Jonathan ,

Are you looking for this?

Please check attached sample workbook and let me know.

Thanks and regards,

Rohan Malusare.

I've tried to get the closest value as per your requirement. Have a look and let me know If you've any query.

Workbook (version 9.3) has been attached for your reference.

Mahfooj

Jonathan,

I may not have caught the gist,

but I had the feeling that you are going to need to do a self-join to get every

combination of Table1 value with every Table2 value.

The difference equation is

WINDOW_MIN(MIN(ABS([Distance])))

where Distance is

[Table1]-[Table2 (Sheet1$1)]

And then the closest is

IF ATTR([Table2 (Sheet1$1)])=

    (IF ATTR(ABS([Distance]))=[MinDistanceTable2]

    THEN ATTR([Table2 (Sheet1$1)])

    END)

THEN ATTR([Table2 (Sheet1$1)])

END