I am trying to figure out how to make it so if column A on sheet 1 matches column A on sheets 2 and 3 it subtracts the number in column G on sheets 2 and 3 from Column B on sheet 1. I am not very well versed in excel but what i came up with is. This works but only finds the first value on each page and the data in column A appears more than once on each page. any help would be appreciatedFormula:
Please Login or Register to view this content.
Bookmarks