Hi guys & gals,
Need help with formula for vlookup to generate a zero if a match is not found in the first column. My formula looks for a matching date in B1, and if it finds it does a vlookup. This is for part inventory so I need a zero returned if the part is not on the list in col A because only parts with a positive inventory show up in the report I have to use.
Here is the current formula: =IF(BL5=Inventory!$B$1,VLOOKUP($C7,Inventory!$A3:$C72,2),BK10)
Thanks in Advance!
Bookmarks