This returns the value of the intersection of the drop downs in D2 and F2.

Sub Update()

Dim MyValue$

MyValue = Evaluate("INDEX(C5:G8,MATCH(D2,B5:B8,0),MATCH(F2,C 4:G4,0))")
MsgBox MyValue

End Sub

I want to write the value of cell I2 TO the intersection of the drop downs in cells D2 and F2.

I thought the Intersect function would be the key, but all I can find is RETURN the value not ENTER a value in the intersection.

Thanks,
Howard