N/A Question
 

I am using
=OFFSET(MasterInventoryList!$A$1,MATCH($A4,MasterI nventoryList!$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

N/A Question
 

This contains an error check method:

=IF(ISNUMBER(MATCH($A4,MasterInventoryList!$A$1:$A $425,0)),OFFSET(MasterInventoryList!$A$1,MATCH($A4 ,MasterInventoryList!$A$1:$A$425,0)-1,1),"")


--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Jeremy" wrote:

I am using
=OFFSET(MasterInventoryList!$A$1,MATCH($A4,MasterI nventoryList!$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

N/A Question
 

=IF(ISNA(OFFSET(MasterInventoryList!$A$1,MATCH($A4 ,MasterInventoryList!$A$1:$A$425,0)-1,1)),"",OFFSET(MasterInventoryList!$A$1,MATCH($A4 ,MasterInventoryList!$A$1:$A$425,0)-1,1))


Gord Dibben MS Excel MVP

On Fri, 24 Jul 2009 06:49:01 -0700, Jeremy
wrote:

I am using
=OFFSET(MasterInventoryList!$A$1,MATCH($A4,Master InventoryList!$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