vlookup syntax

Below is an attempt at a code that if the value in F2 is... then it does a vlookup in a shett named panel in a select range (G and H). Can someone please help me with the syntax? Thank you.

'  Step 3 Add Inheritance
i = Range("F" & Rows.Count).End(xlUp).Row
    For Each rngCell In Range("F2" & i)
        With ActiveSheet
        With .Range("C5:C" & lastrow)

        Select Case rngCell.Value
                        Case Is = "Comprensive Epilepsy"
                With rngCell.Offset(0, 6)
                    .Formula = "=Index(Panel!H1:H70, Match(B5,panel!G1:G70,0))"
                  End With
            i = Range("F" & Rows.Count).End(xlUp).Row
            
            Select Case rngCell.Value
                        Case Is = "Marfan Disorder"
                With rngCell.Offset(0, 6)
                    .Formula = "=Index(Panel!H25609:H25628, Match(B5,panel!G25609:G25628,0))"
                  End With
            End Select
            End With

I uploaded a sample to box.net as it is too large to attach.

https://app.box.com/s/mxui3162moqbi8z17ptk

The desired worksheet has the Inheritance (column 3) filled in for the first 4 rows based on the gene in column 2. It looks up the gene name in the panel sheet and returns the value in the column next to the gene. Thanks.

Sorry for the confusion.

There are 3 worksheets (panel, annovar, and desired)

Panel: A-H (G and H are important)

Annovar: A – AY (B and C are important)

Desired: Match the value of B in annovar to column G in panel and return the value in Hin panel to column C in annovar

So PPT1 is in G47 of panel and is autosomal recessive in column H off panel. In column B in annovar PPT1 is the first gene so the value is looked up in panel and the result in column H is returned to column C in annovar.

I hope this helps and thanks.

Thank you very much. Im not sure how it works, but the code is great. Thank you