J
Jeremy
I am using
=OFFSET(MasterInventoryList!$A$1,MATCH($A4,MasterInventoryList!$A$1:$A$425,0)-1,1)
as a formula and if no data is entered yet the cell shows N/A. How do I have
the N/A not show or hide?
Thank you
Jeremy
=OFFSET(MasterInventoryList!$A$1,MATCH($A4,MasterInventoryList!$A$1:$A$425,0)-1,1)
as a formula and if no data is entered yet the cell shows N/A. How do I have
the N/A not show or hide?
Thank you
Jeremy