Hi,
I have an IF formula that works for me but I have to drag it down to work on other colums. It's currently
=IFS(M5:M="AO","S",M5:M="","")
Id like it to be automatic on every column. I have attached an example relation to the prior mentioned formula. Basically I need "s" to appear in column P when I type "AO" in column M. I think it may be an array formula. I've tried searching for this on YouTube to no avail.
Be grateful if you could help.
Thanks,
Chris
1.png
Bookmarks