Try
![]()
=IF(AND(NOT(ISBLANK($A28)),$A28<>0),IFERROR(VLOOKUP($A28,InstallTemp!$C:$J,2,FALSE),0),"")
Try
![]()
=IF(AND(NOT(ISBLANK($A28)),$A28<>0),IFERROR(VLOOKUP($A28,InstallTemp!$C:$J,2,FALSE),0),"")
Elegant Simplicity............. Not Always
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks