Forum Discussion
Formula help SOS
Hello Excel community, I could really use some help with formulas as part of a RAID log I am pulling together for a project (see below). I don't know if this is possible but I want the formu...
If you tweak your formula in column M on Risk Log Sheet like this...
=IF(A10="","",IF(V10="","Open","Closed"))
You're existing formula on RAID Log Dashboard Sheet in C5 is correct and will return the correct output once you tweak the formula as suggested above.
You should also tweak the formula in L10 on Risk Log Sheet as below...
=IFERROR(VLOOKUP(W10,RiskLook,2,TRUE),"")
This will remove the #N/A error from Column L.
Thanks so much for the help!
You're welcome! Glad you found it helpful.
If any of the replies above resolved the issue, please take a minute to accept the post with the proposed solution as a Best Response to mark your question as Solved.