IF(AND)
My formula was working and then i tweaked it by adding an IF(AND statement to it. Is this possible and i have something wrong. Or will this not work in this senario.
Answers
-
Hi @Robert S Fike,
Trim it down a bit to:
IF(AND([Neighborhood Lots]@row="Hampstead - LNH", [Block]@row ="U"), "6A",
And then move it before the previous IF statement - this has the "Hampstead - LNH" Neighborhood Lot in there already (giving a "6B" result), which will be triggered as a positive before your AND statement if left as is.
If I'm honest I'd probably be using a cross sheet reference and an INDEX(COLLECT) given the number of results! π
Hope this helps, but if I've misunderstood anything or you've any further problems/questions then just ask!
-
Thank you very much. I will look into the index(collect)
