I have the below formula, I want to show blank or show nothing instead of bunch of #n/a
please help , thank you.=IF($H17>$L$1,NA(),INDEX(Table3[Desired Stock],MATCH($H17,Table3[No Color Index],0)))
I have the below formula, I want to show blank or show nothing instead of bunch of #n/a
please help , thank you.=IF($H17>$L$1,NA(),INDEX(Table3[Desired Stock],MATCH($H17,Table3[No Color Index],0)))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks