=IF(AND($K$9=2,I17=3),"--",INDEX(A:A,MATCH(K17,D:D,0)))
This formula is returning the FALSE result when $K$9=2, I17=3 and therefore should return "--". The problem is with the "2" in $K$9 as I have changed $K$9 to a text symbol instead and the formula works. Is it something to do with being formatted as a number? I can't see why it would be because I17 is formatted as a number and is recognised fine. Thanks.
Dan
check k9 only has 2 in it and no hidden spaces
check k9 does =2 change format to number 15 places to see if there are any decimals in there
Last edited by martindwilson; 06-23-2012 at 06:47 AM.
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Ah, is it maybe something to do with the Data Validation I have in $K$9?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks