Vic,

Try this in N2

=IF(COUNTIF(BM!D2:D500,D2)0,"Yes","")

--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Vic" wrote:

I need to put "Yes" into N2 if my account in D2 is among accounts from sheet
BM cells ranging from D2 thru D500. What is the formula that I need to put in
N2?
Thank you.