Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|