Hi Howard,

Am Sat, 29 Nov 2014 08:28:41 -0800 (PST) schrieb L. Howard:

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

this is not an array function to use Evaluate. Write it with
Worksheetfunction:

With WorksheetFunction
Range("I2") = .Index(Range("C5:G8"), .Match(Range("D2"), _
Range("B5:B8"), 0), .Match(Range("F2"), Range("C4:G4"), 0))
End With


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional