I have two different sheets with records of sales and I want to use index match to calculate the difference between the numbers on each sheet. I have a vlookup formula which sometimes works but has a few value errors so thought index match would work more efficiently.
Another part of the sheet also has to dates which it would be handy if differences could be identified. returning blank if the same or the date from the first list if different. This would obviously be a different formula to keep as simple as possible as the results will be in different columns
Bookmarks