Compare Text, Replace Number

[sglick]

Hi --
I have two columns with names and amounts. One of the columns only has text that satisfied a condition.

I need to compare the columns. If the text from the full list appears in the column of the conditional list, Then the full list returned with a 0 next to the names that appear in the conditional list.

(I don't want to repeat any numbers, they need to equal the same amount).

Help me please. Thank you,

Stephanie

[NBVC]

Enter this in H2 and copy down:

=IF(ISNUMBER(MATCH(D2,A:A,0)),0,E2)

[sglick]

That worked. Thank you. Stephanie

Enter this in H2 and copy down:

=IF(ISNUMBER(MATCH(D2,A:A,0)),0,E2)

[NBVC]

You're welcome!