IF(AND)

Robert S Fike

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.

Nick Korna

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!

Robert S Fike

Thank you very much. I will look into the index(collect)