Hi,
I am trying to create an if statement that has a vlookup to pull back data and then have an argument to say if the cutoff dates table has a date use that if not just show the data from the avail inventory clean tab. Id like the formula to look at the data in the mirrored table and then if = to date in cutoff tab then show cut off for that date, if false show the remaining inventory from the Avail inventory clean tab. The vlookups are correct but the formula is off somewhere. I have attached the sample to help. Thank you for your help.
Best Regards,
Brett
Bookmarks