Good Afternoon,
I have spent the last hour reading post after post and some have helped but...still no complete answer to the following problem:
In my standard Index,match statement
=Iferror(index('Sheet1'!a2:a6,match('sheet2'!b3,'sheet1'!x2:x6,0)),"")
Any blank cell comes up 0. If I custom format [=0]"";General that renders the cell blank, however, there ARE times I need a 0 to show as entered in Sheet1!a2:a6
Is there a way to do this other than re-iterating my first statement with an additional if/then statement such as:
=if(index('Sheet1'!a2:a6,match('sheet2'!b3,'sheet1'!x2:x6,0)=0,0,Iferror(index('Sheet1'!a2:a6,match('sheet2'!b3,'sheet1'!x2:x6,0)),""))
I would append a copy of this document but it contains PHI and due to HIPAA "blah blah blah"
This document is going to be a beast as it is (boss hates Access, so I get to force Excel to perform as such) and I am trying to keep calculations to the minimum needed to run as fast as possible.
Bookmarks