Sorry misunderstood the question after re-readinig it.

"Iriemon" wrote:

=vlookup(c1,d1:e10,2,false)



"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...