try this, assume that your data start at row 2

=IF(AND(C2=1234,D2=4),E2,"not match")

--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked

Thank You

cheers, francis

Am not a greek but an ordinary user trying to assist another



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