也很简单，就是我在第一张表里边求出了有行和列的值，要在第二张表里边根据行值和列值找出对应的单元格的数值

是很简单，按以下步骤即可：

1、将需要查询的数据区域定义一个名称：Data

2、建立一个标准模块

3、在标准模块中写一个自定义函数：

Public Function GetVal(ByVal row As String, ByVal col As String) As Single
    Dim i As Long, j As Long
    Dim D As Range
    Dim v As Single
    v = 0
    'Set D = ActiveWorkbook.Names("Data").Range
    Set D = Worksheets("f").Range("Data")

    For i = 1 To D.Rows.Count
        If D.Cells(i, 1) = row Then
            For j = 1 To D.Columns.Count
                If D.Cells(1, j) = col Then
                    v = D.Cells(i, j)
                    Exit For
                End If
            Next
            Exit For
        End If
    Next
    GetVal = v
End Function

4、在单元格中引用这个自定义函数

 �������ش˸���