=INDEX(C3:C5,MATCH(A10&B10,$A$3:$A$5&$B$3:$B$5,0))

You must commit the formula using
CTRL-SHIFT-ENTER since this is an array formula

(hit CTRL-SHIFT-ENTER rather than ENTER when done)


adjust for your cell references.



"silentpro" wrote:

Please help...

This is the best way I can think of writing this out.

IF column C has ID of 1234, & column D has a value of 4, give me the value
of column E.


Thanks...