Look-up
 

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.

Look-up
 

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.

Look-up
 

It's not working. When I copy this formula down from D2 thru d900 it keeps on
changing all numbers from BM sheet.

"Mike H" wrote:

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.

Look-up
 

If you are copyng the formula down, then perhaps you intended to change
=IF(COUNTIF(BM!D2:D500,D2)0,"Yes","")
to
=IF(COUNTIF(BM!D$2:D$500,D2)0,"Yes","") ?
--
David Biddulph

"Vic" wrote in message
...
It's not working. When I copy this formula down from D2 thru d900 it keeps
on
changing all numbers from BM sheet.

"Mike H" wrote:

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.

Look-up
 

Hmmm..., maybe: IF(COUNTIF(BM!$D$2:$D$500,D2)0,"Yes","")
Micky


"Vic" wrote:

It's not working. When I copy this formula down from D2 thru d900 it keeps on
changing all numbers from BM sheet.

"Mike H" wrote:

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.

Look-up
 

This formula works great. Now, I need to expand it. I am looking for D2 thru
D500 to be in BM sheet and the corresponding G2 thru G500 to be blank. How
can I combine these two?

"מיכאל (מיקי) אבידן" wrote:

Hmmm..., maybe: IF(COUNTIF(BM!$D$2:$D$500,D2)0,"Yes","")
Micky


"Vic" wrote:

It's not working. When I copy this formula down from D2 thru d900 it keeps on
changing all numbers from BM sheet.

"Mike H" wrote:

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.