Excel 2003 formula
in [Functions]
|
Prev: How enter time DURATIONS mm:ss (not clock times), then sum?
Next: how to count#cells w/= value in other column and not count bla
From: Don Guillett on 10 Apr 2010 09:56 If desired, send your file to my address below. I will only look if: 1. You send a copy of this message on an inserted sheet 2. You give me the newsgroup and the subject line 3. You send a clear explanation of what you want 4. You send before/after examples and expected results. -- Don Guillett Microsoft MVP Excel SalesAid Software dguillett(a)gmail.com "Ginger" <Ginger(a)discussions.microsoft.com> wrote in message news:3A86AF07-5D9C-49B9-922C-EFAA4E7CE6E7(a)microsoft.com... > Thanks but still not working. Excel takes the conditional formula but the > sheet isn't changing. I tried both formulas with the same results. Any > other > suggestions? I could email it to one of you? > > > "David Biddulph" wrote: > >> You don't need IF(...,TRUE,FALSE) >> The formula =(VLOOKUP(A1,'Sheet 2'!A:B,2,FALSE)="yes" will already return >> the Boolean values TRUE or FALSE, so your IF function adds nothing. >> -- >> David Biddulph >> >> >> "tompl" <tompl(a)discussions.microsoft.com> wrote in message >> news:7A183C1E-568C-4C12-ADA5-A3F2C14052C8(a)microsoft.com... >> > If you are familiar with conditional formatting you could apply >> > conditional >> > formatting using a formula similar to this: >> > "=IF(VLOOKUP(A1,'Sheet 2'!A:B,2,FALSE)="yes",TRUE,FALSE) >> > where A1 is the cell being formatted. Then choose the strikethrough >> > format >> > for when the condition is true. >> > >> > Tom >> > >> >> . >>
From: Don Guillett on 10 Apr 2010 15:06
CF does not like other sheet references but you can fool it by simply defining a name on the words sheet lookupwords= $a1:$b$18 or make it dynamic by using this formula to define the name =offset($a$1,0,0,counta($a:$a),2) then use this in the players sheet for your CF =VLOOKUP(E2,lookupwords,2,0)="yes" and format as desired in black or strike -- Don Guillett Microsoft MVP Excel SalesAid Software dguillett(a)gmail.com "Don Guillett" <dguillett1(a)gmail.com> wrote in message news:OS41WWL2KHA.5588(a)TK2MSFTNGP06.phx.gbl... > If desired, send your file to my address below. I will only look if: > 1. You send a copy of this message on an inserted sheet > 2. You give me the newsgroup and the subject line > 3. You send a clear explanation of what you want > 4. You send before/after examples and expected results. > > > -- > Don Guillett > Microsoft MVP Excel > SalesAid Software > dguillett(a)gmail.com > "Ginger" <Ginger(a)discussions.microsoft.com> wrote in message > news:3A86AF07-5D9C-49B9-922C-EFAA4E7CE6E7(a)microsoft.com... >> Thanks but still not working. Excel takes the conditional formula but the >> sheet isn't changing. I tried both formulas with the same results. Any >> other >> suggestions? I could email it to one of you? >> >> >> "David Biddulph" wrote: >> >>> You don't need IF(...,TRUE,FALSE) >>> The formula =(VLOOKUP(A1,'Sheet 2'!A:B,2,FALSE)="yes" will already >>> return >>> the Boolean values TRUE or FALSE, so your IF function adds nothing. >>> -- >>> David Biddulph >>> >>> >>> "tompl" <tompl(a)discussions.microsoft.com> wrote in message >>> news:7A183C1E-568C-4C12-ADA5-A3F2C14052C8(a)microsoft.com... >>> > If you are familiar with conditional formatting you could apply >>> > conditional >>> > formatting using a formula similar to this: >>> > "=IF(VLOOKUP(A1,'Sheet 2'!A:B,2,FALSE)="yes",TRUE,FALSE) >>> > where A1 is the cell being formatted. Then choose the strikethrough >>> > format >>> > for when the condition is true. >>> > >>> > Tom >>> > >>> >>> . >>> > |