hi I have the following formula, I want to show blank if its 0
![]()
=IF(LEN(CustomerName)=0,0,IFERROR(VLOOKUP(CustomerName,Contractors!$B:$I,8,0),0))
hi I have the following formula, I want to show blank if its 0
![]()
=IF(LEN(CustomerName)=0,0,IFERROR(VLOOKUP(CustomerName,Contractors!$B:$I,8,0),0))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks