I have the following formula that works however I get a “FALSE” outcome when it doesn’t have the right answer.
Is there a way to remove the FALSE outcome with a blank outcome, i.e. “”
=IF(OR($L4={"L","P"}),"",IF($L4="S",IF($A4="WPA",VLOOKUP(H4,Arrays!B:E,3,0)*'HESG Funding'!$C$4,VLOOKUP(H4,Arrays!B:E,4,0))))
Thanks for your help.
Bookmarks