Originally posted by scooterscot
View Post
Thanks for that Scooter, almost there. The formula you gave doesnt quite work though, although it may just be me being dense.
=IF(VLOOKUP($A$1,A5:EE316,2,FALSE)='x',TRUE,FALSE) doesn't work, but giving it a hard coded cell location does.
=IF(VLOOKUP(A5,A5:EE316,3,FALSE)="x",TRUE,FALSE)
So either $A$1 isnt correctly evaluating to the active cell in that range or I've done something wrong somewhere in setting it up. Any ideas?
Comment