主题：EXCEL表LOOKUP公式在FOX表如何做？

 做一张对照表，在foxtable里，通过表查询对应的值；如果是导出excel报表的话，就根据表写入对应的公式。

Dim s1() As Integer = {0,97,101,105,110,115,120,125,130,135,140,145,150,155,160,165,170,175,180,185,190,195,200,205,210,215,220,225,230,241,256,271,286,301,316,331,351,371,385,401}
Dim s2() As Double = {1.07,1.03,1,0.97,0.93,0.9,0.87,0.85,0.82,0.8,0.78,0.76,0.74,0.72,0.71,0.69,0.68,0.66,0.65,0.64,0.63,0.62,0.61,0.6,0.59,0.58,0.57,0.56,0.55,0.53,0.51,0.5,0.48,0.47,0.46,0.44,0.43,0.42,0.41,0.4}
Dim n As Integer = 188            '这里就是要确定范围内的数值
For i As Integer = 1 To s1.length
    If s1(i-1) < n And s1(i) >= n

        Output.Show(s2(i))
        Exit For
    End If
Next

主表的单价是输入，关联表则根据主表的单价以及主表的重量的大小自动输入，如主表的单价是8.5，重量是97斤，则关联表的单价＝8.5+1.03，希望有一点简单的办法，并且上述的｛｝、｛｝内的数据可以随时修改。

你把数组存到表里面去就可以随意修改了. 用的时候到表里去读取.

不懂，如何做？

参考帮助http://www.foxtable.com/help/topics/2747.htm

对不起！不过师父你的指点真的很有用！

昨天刚复习了下lookup，其实说白了很简单，就是条件判断，