Heres the statement I am using
=IF(VLOOKUP(B17,Products,5,FALSE)<>"",IF($U17="Gal",($F17/(VLOOKUP($B17,Products,5,FALSE)/100))/10,($F17/(VLOOKUP($B17,Products,5,FALSE)/100))))
The goal of the statement is to have it look up a number and if there is no number to leave it blank (cant have div/0 errors) and if not blank follow through with the formula. The Charts for the lookup are on a different tab as well. I hope that helps... I've tried to work through this for about 3 hours now and just cant seem to get it to work.
Edit
figured out the false issue now im getting div / 0 errors due to the product code being a blank number for some reason its giving issues the code I'm using now is.
=IF(VLOOKUP(B17,Products,5,FALSE)<>"","",IF($U17="Gal",($F17/(VLOOKUP($B17,Products,5,FALSE)/100))/10,($F17/(VLOOKUP($B17,Products,5,FALSE)/100))))
Bookmarks