I think this one will work.....now if I am looking in a different worksheet
for this info, where would I add that?
Let's say the worksheet is named "main"




"Francis" <xlsmate(AT)gmail(DOT)com wrote in message
...
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...