Hey folks, how would i go about making the below formula show a blank (i.e. nothing), instead of the FALSE when the formula isn't true please?
=IF(L12=Sheet1!$B$36,Sheet1!$A$36,IF(New!L12=Sheet1!$B$37,IF(L12=Sheet1!B38,Sheet1!A38,"")))
Basically until a value is selected in L12 i want this formula box to remain blank, once they select a value it gives the answer i need.
Thanks
Bookmarks