Try
=IF(ISNA(Vlookup(A1,Sheet1!A:C,3,False),"",ISNA(Vl ookup(A1,Sheet1!A:C,3,False))
&
IF(ISNA(Vlookup(A1,Sheet1!B:C,2,False),"",ISNA(Vlo okup(A1,Sheet1!B:C,2,False))

assuming DM# and CM# don't have any number in common.
and COL A has DM# or CM.

"Dinesh" wrote:

Hi,

I have three columns in Sheet1. COL A has DM#, COL B has CM# and COL C has
an amount.

Sheet2 has two columns. COL A has DM# and CM#. In COL B, I like to bring the
amount based on CM# or DM# from sheet1.

Is there a simple formula for this?

Thanks,
Dinesh