I want this formula to return zero if it cannot match the value. Right now it is returning #N/A and i don't want that. I just want to return "0" if it can't match it. Thanks
Here is my formula
![]()
=IF(V1="ALL", VLOOKUP(B17,$AC$21:$AD$31,2,0), VLOOKUP(B17,$P$21:$R$31,3,0))
Bookmarks